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 Administrator and looking at the key efficiency and sure enough it was 0%. I then decreased the key_buffer to 2GB and it mysteriously started working again.
Thx, Ian The information transmitted in this email is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this email in error, please contact the sender and permanently delete the email from any computer.
