Ratheesh K J wrote:
Hello All,
I wanted to know what is the best size for Innodb key cache. We are currently
running MySQL 4.1.11
And we have set the buffer size to 1GB.
innodb_buffer_pool_size = 1G
The system has 4 GB RAM.
1) In such a case is the above setting ok?
2) All the tables are of Innodb type
3) We are using the same server for Apache and MySQL
I'd say it's too high but it depends completely on your usage.
Don't forget apache needs some memory as well (and your o/s too) plus
whatever the "glue" between the two is (php? perl? ruby? python?)
http://dev.mysql.com/doc/refman/5.1/en/innodb-configuration.html says:
# Set buffer pool size to 50-80% of your computer's memory,
# but make sure on Linux x86 total memory usage is < 2GB
There's a lot of information in the manual if you do some searching.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
