The mysql database he is referring to is /var/lib/mysql/mysql where it
holds the access rights for users, tables, columns, etc. That HAS to be
MYISAM.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-----Original Message-----
-->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, September 30, 2003 1:12 PM
-->To: Misaochankun
-->Cc: [EMAIL PROTECTED]
-->Subject: RE: Key_buffer_size
-->
-->
-->Mysql database have only innodb tables. I'm not using MyISAM.
-->
-->Quoting Misaochankun <[EMAIL PROTECTED]>:
-->
-->> 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]
-->>
-->
-->
-->
-->--
-->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]
