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 1H7KLE-0008HZ-Iz for garchives@archives.gentoo.org; Wed, 17 Jan 2007 23:37:17 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.8/8.13.8) with SMTP id l0HNa4u2021938; Wed, 17 Jan 2007 23:36:04 GMT Received: from popmail.jettissystems.com (popmail.jettissystems.com [38.118.146.212]) by robin.gentoo.org (8.13.8/8.13.8) with ESMTP id l0HNVe0M015355 for ; Wed, 17 Jan 2007 23:31:41 GMT Received: from [10.23.0.116] (unknown [74.93.11.97]) by popmail.jettissystems.com (Postfix) with ESMTP id B293B56D492 for ; Wed, 17 Jan 2007 15:31:39 -0800 (PST) Message-ID: <45AEB1D5.8000700@badapple.net> Date: Wed, 17 Jan 2007 15:31:33 -0800 From: kashani User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) 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 To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] MySQL5 and Innodb not working References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Archives-Salt: a3cb0704-9ce8-4cb5-afe5-0b2c57540998 X-Archives-Hash: feb21920ac7d9d0ec81430ef7b44535d 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