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 1H7WAj-00034c-FK for garchives@archives.gentoo.org; Thu, 18 Jan 2007 12:15:14 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.8/8.13.8) with SMTP id l0ICE8ZG019811; Thu, 18 Jan 2007 12:14:08 GMT Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.232]) by robin.gentoo.org (8.13.8/8.13.8) with ESMTP id l0IC9uf1005806 for ; Thu, 18 Jan 2007 12:09:57 GMT Received: by wr-out-0506.google.com with SMTP id 57so51176wri for ; Thu, 18 Jan 2007 04:09:55 -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=sy5Ka5/FxplMOZwZtW5SXnowfjFe8oQPwBwAoyuRcmHM4CViaayYUaglP9x1VMRClXOKhKcD+699ikf59YIE0pgf5kFw0ofhX+UMJH53idCg+hfoovPNaEngvXfZl7OEQZ+3hGNyw6HCiJt82k/yaDQv1n3TbRy0P1HnDTl2pQ4= Received: by 10.90.118.12 with SMTP id q12mr1055951agc.1169122195672; Thu, 18 Jan 2007 04:09:55 -0800 (PST) Received: by 10.90.81.2 with HTTP; Thu, 18 Jan 2007 04:09:55 -0800 (PST) Message-ID: Date: Thu, 18 Jan 2007 13:09:55 +0100 From: "Thomas Balthazar" To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] MySQL5 and Innodb not working In-Reply-To: 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_108914_8310120.1169122195166" References: <45AEB1D5.8000700@badapple.net> X-Archives-Salt: bbcb2d16-a369-4e70-b5d9-0837a7f85d55 X-Archives-Hash: c5c8994232f2876a6ca29f85dba6f240 ------=_Part_108914_8310120.1169122195166 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I've re-installed a 32 version of Gentoo, installed the same components, and it works now. Maybe it was a problem with the 64 bits version. Thanks to everybody for the support. Thomas. On 1/18/07, Thomas Balthazar wrote: > > 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_108914_8310120.1169122195166 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I've re-installed a 32 version of Gentoo, installed the same components, and it works now.
Maybe it was a problem with the 64 bits version.

Thanks to everybody for the support.
Thomas.

On 1/18/07, Thomas Balthazar <thomas.tmp@gmail.com> wrote:
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_108914_8310120.1169122195166-- -- gentoo-user@gentoo.org mailing list