How many key buffer size should be allocate?

2008-09-07 Thread Yi Wang
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. And

Re: How many key buffer size should be allocate?

2008-09-07 Thread Dan Nelson
In the last episode (Sep 08), Yi Wang said: 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.