From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.62) (envelope-from ) id 1H7TNO-0003j1-Mm for garchives@archives.gentoo.org; Thu, 18 Jan 2007 09:16:07 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.8/8.13.8) with SMTP id l0I9Ew0i002940; Thu, 18 Jan 2007 09:14:58 GMT Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.226]) by robin.gentoo.org (8.13.8/8.13.8) with ESMTP id l0I9AgLi017308 for ; Thu, 18 Jan 2007 09:10:43 GMT Received: by wx-out-0506.google.com with SMTP id i30so224631wxd for ; Thu, 18 Jan 2007 01:10:42 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=Uu+lU/OZC9jGooGopgg1ZZDYpAC5PlLoRuNmAkF1SBY4JwcLQM3pbBlwsE9fo/GkIvMwKNDc0Z1ARaE09AfP0+E643hfSfwSxVxib8VJb6BfDlje1aDR68J+o4bfBKNm6k4DAQITckc4gSFUjibXjkRDbByqRnoBKEcgXUkPPz4= Received: by 10.90.99.20 with SMTP id w20mr807102agb.1169111442321; Thu, 18 Jan 2007 01:10:42 -0800 (PST) Received: by 10.90.81.2 with HTTP; Thu, 18 Jan 2007 01:10:42 -0800 (PST) Message-ID: Date: Thu, 18 Jan 2007 10:10:42 +0100 From: "Thomas Balthazar" To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] MySQL5 and Innodb not working In-Reply-To: <45AEB1D5.8000700@badapple.net> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_107298_15416753.1169111442261" References: <45AEB1D5.8000700@badapple.net> X-Archives-Salt: a5c9f94d-0588-4638-a59e-620358afdbf4 X-Archives-Hash: 5d06a92e0335f467e05c315663cf4315 ------=_Part_107298_15416753.1169111442261 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello, Thanks for your answer! I've re-formatted the whole server and I'm re-installing Gentoo 32 bits instead of 64 bits. I want to see if I face the same problem. I'll keep you posted. Regards, Thomas. On 1/18/07, kashani wrote: > > Thomas Balthazar wrote: > > Hello, > > > > I'm using Gentoo Base System version 1.6.14 on a x86_64 Intel(R) > > Celeron(R) CPU 2.66GHz. > > I've added "dev-db/mysql innodb berkdb" to my package.use then I've run > > emerge -1 dev-db/mysql. > > > > I've installed PHPMyAdmin that is up and running (MySQL 5.0.26). > > When I try to create a Innodb table, I get an error : > > #2013 - Lost connection to MySQL server during query > > > > After that, I cannot stop or start my MySQL server. > > Everything seems to be corrupted, and all I can do is to erase all the > > content of /var/lib/mysql and restart from scratch. > > > > Has anyone heard of problems with MySQL/InnoDB/Gentoo? > > > > Any help would be much appreciated! > > Thanks in advance, > > Thomas. > > Couple of things on this. > > This whole community vs enterprise is making things a bit weird at > the > moment for ebuilds. For Innodb I highly recommend going with the > enterprise build, dev-db/mysql which you've already installed, and using > the ~arch version of 5.0.32. It fixes a number of high concurrency/multi > thread issues in Innodb and I'd move to it sooner rather than later. > > Have you modified your my.cnf at all? The default Innodb settings > are > TINY. Assuming you have at least a 1 GB of RAM in you machine I'd bump > the following setting up so that you can fit real tables into Innodb. > > #innodb_buffer_pool_size = 16M > innodb_buffer_pool_size = 128M > > Innodb buffers and general Mysql buffers like key, sort, etc are > managed separately. If you're starting to migrate things into Innodb > from Myisam you might need to decrease some of the current buffers if > you've got limit RAM. > > The Gentoo Mysql startup script is a bit retarded when starting > Mysql > with Innodb tables turned on the first time, at least with large tables > and log files. I use two 512M log files in production and the startup > script fails though Mysql is actually running, it's just pausing to > write the log files and initial ibdata files out. In your case I'd start > and stop Mysql a few times before trying to create an Innodb table just > to be sure that Mysql is finished with all the file writes. > > I suspect the issues is Innodb not having enough memory assigned to it > rather than the binary being borked. You might also try creating a > simpler table in Innodb and see if you have the same issues. > > I'd also recommend adding the setting, innodb_file_per_table, so that > each table gets it's own ibdata file in the form of > lib/mysql/$db/$table.idb. It performs better and it is a bit easier to > tell how big your db is on disk or which db is using all your disk. > > kashani > -- > gentoo-user@gentoo.org mailing list > > ------=_Part_107298_15416753.1169111442261 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello,

Thanks for your answer!
I've re-formatted the whole server and I'm re-installing Gentoo 32 bits instead of 64 bits.
I want to see if I face the same problem.
I'll keep you posted.

Regards,
Thomas.

On 1/18/07, kashani <kashani-list@badapple.net> wrote:
Thomas Balthazar wrote:
> Hello,
>
> I'm using Gentoo Base System version 1.6.14 on a x86_64 Intel(R)
> Celeron(R) CPU 2.66GHz.
> I've added "dev-db/mysql innodb berkdb" to my package.use then I've run
> emerge -1 dev-db/mysql.
>
> I've installed PHPMyAdmin that is up and running (MySQL 5.0.26).
> When I try to create a Innodb table, I get an error :
> #2013 - Lost connection to MySQL server during query
>
> After that, I cannot stop or start my MySQL server.
> Everything seems to be corrupted, and all I can do is to erase all the
> content of /var/lib/mysql and restart from scratch.
>
> Has anyone heard of problems with MySQL/InnoDB/Gentoo?
>
> Any help would be much appreciated!
> Thanks in advance,
> Thomas.

Couple of things on this.

        This whole community vs enterprise is making things a bit weird at the
moment for ebuilds. For Innodb I highly recommend going with the
enterprise build, dev-db/mysql which you've already installed, and using
the ~arch version of 5.0.32. It fixes a number of high concurrency/multi
thread issues in Innodb and I'd move to it sooner rather than later.

        Have you modified your my.cnf at all? The default Innodb settings are
TINY. Assuming you have at least a 1 GB of RAM in you machine I'd bump
the following setting up so that you can fit real tables into Innodb.

#innodb_buffer_pool_size = 16M
innodb_buffer_pool_size = 128M

        Innodb buffers and general Mysql buffers like key, sort, etc are
managed separately. If you're starting to migrate things into Innodb
from Myisam you might need to decrease some of the current buffers if
you've got limit RAM.

        The Gentoo Mysql startup script is a bit retarded when starting Mysql
with Innodb tables turned on the first time, at least with large tables
and log files. I use two 512M log files in production and the startup
script fails though Mysql is actually running, it's just pausing to
write the log files and initial ibdata files out. In your case I'd start
and stop Mysql a few times before trying to create an Innodb table just
to be sure that Mysql is finished with all the file writes.

I suspect the issues is Innodb not having enough memory assigned to it
rather than the binary being borked. You might also try creating a
simpler table in Innodb and see if you have the same issues.

I'd also recommend adding the setting, innodb_file_per_table, so that
each table gets it's own ibdata file in the form of
lib/mysql/$db/$table.idb. It performs better and it is a bit easier to
tell how big your db is on disk or which db is using all your disk.

kashani
--
gentoo-user@gentoo.org mailing list


------=_Part_107298_15416753.1169111442261-- -- gentoo-user@gentoo.org mailing list