Re: How many key buffer size should be allocate?

. The total db size is about 200M. And the system's load is slight. key buffer size is 8M before changing. And the hitrate is about 100% intermittently. If your database is only 200M, then your indexes are probably less than half that (if you total up all of your .MYI files, that's the total

Re: How many key buffer size should be allocate?

4M. The total db size is about 200M. And the system's load is slight. key buffer size is 8M before changing. And the hitrate is about 100% intermittently. If your database is only 200M, then your indexes are probably less than half that (if you total up all of your .MYI files, that's

How many key buffer size should be allocate?

Hi, According to the mysql manual, I changed key_buffer_size from 8M to 512M. But In mysql administrator, key buffer hitrate seems stay unchanged. And key buffer usage always below 4M. The total db size is about 200M. And the system's load is slight. key buffer size is 8M before changing

Re: How many key buffer size should be allocate?

. key buffer size is 8M before changing. And the hitrate is about 100% intermittently. If your database is only 200M, then your indexes are probably less than half that (if you total up all of your .MYI files, that's the total size of all your indexes). Setting key_buffer_size larger than your

Re: Key Buffer Size

Hello. =09To give you an idea of my database, I use Linux box with 6GB ram, MySQL version 4.0.15. Most of my configuration is in lines with my-huge.cnf. Your version of MySQL is rather old, I strongly recommend you to upgrade to the latest release (4.1.14 now). If your server has x86

Key Buffer Size

Greetings, In my database, all the tables use innodb engine. Since I don't use MYISAM, Is it safe to make the key_buffer size to 8 MB? To give you an idea of my database, I use Linux box with 6GB ram, MySQL version 4.0.15. Most of my configuration is in lines with my-huge.cnf.

Re: Key Buffer Size

Yeah, it's safe. -- Alexey Polyakov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Maximum Key Buffer Size

Is there a maximum key buffer size that can be configured in mysql-4.0.20. I had the key buffer set to 4GB and when looking at key_reads vs. key_read_requests they were almost identical indicating that all reads were actually going to physical disk. I then double checked this by using Mysql

Key Buffer Size

Hi, Can somebody tell me whether this is good or bad: Our mysql server has key_buffer_size = 402,653,184 (without the commas) The MySQL administrator tool indicates a 100% usage most of the time, and 362,324,992 as current usage within 24 hours which builds up very fast. Are there memory leaks

RE: Key Buffer Size

i did: http://www.mysql.com/doc/en/Server_system_variables.html -Original Message- From: Terence [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 3:11 PM To: [EMAIL PROTECTED] Subject: Key Buffer Size Hi, Can somebody tell me whether this is good or bad: Our mysql server has

Key Buffer Size

Hi, huge-my.cnf specifies that total memory usage be less than 2 G. What is meant by total memory usage ? Is it some of key_buffer + innodb_buffer_pool_size + record_buffer or does the total memory usage not include innodb_bbufer_size. How are these buffers used ? Are they obtained using malloc

Re: Key Buffer Size

Hi Terence, key_buffer_size is the amount of memory that is used to cache your index tables. If you are using 100% of it most of the time, you may benefit from an increase in it if you can afford to. You can also look at show status and look at key_reads and key_writes to give you an idea of