Most likely your mysql database is still MyISAM, right? -----Original Message----- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 12:35 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Key_buffer_size
On Tue, Sep 30, 2003 at 08:17:20PM +0100, [EMAIL PROTECTED] wrote: > > > Hi all :) > > I'm working with InnoDB tables only, and i read that the Key_buffer_size is only > used for MyISAM tables. Is it true? > If yes, i can put this variable to 0? Why not leave it at the default value? If MySQL doesn't need it, it won't use it. I'll bet $1000 that you have *some* MyISAM tables... Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 16 days, processed 588,389,126 queries (405/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]