Performance settings for MyISAM tables - keep everything in memory

6 votes

2 answers

14865 views

mysql performance myisam mysql-5.1 mysql-5

                          I have a 8-core MySQL server with 32 GB of RAM, holding 40 MyISAM tables (total: ~4GB of data).
Since the databases size is several times smaller than the available memory, how can I make full usage of my server's resources?

1. What settings should I attempt configure in my.cnf?

2. Can I force data + indexes to stay in memory?

Asked by Vlad Zloteanu (205 rep)

Mar 11, 2012, 05:59 PM
Last activity: Dec 21, 2021, 06:30 PM

Performance settings for MyISAM tables - keep everything in memory

Related Questions