Maximum Key Buffer Size

2004-09-29 Thread Ian Mahaney
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 Admin

RE: mysql-4.0.16 to mysql-4.0.17

2004-07-15 Thread Ian Mahaney
We have a Dell Poweredge 1750 with dual 3GHz Xeon's and 4GB of memory.  It is connected to a EMC CX600 through a Brocade Silkworm 2800 and QLogic HBA running qla2300 v6.07.  Anyways, we are attempting to migrate to the 4 tree from 3.23.56.  When we began doing so I started running some sql-ben