Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a 4-core MySQL server with 4 GB of RAM, holding 19 MyISAM tables (total: ~164GB of data) and 32 innodb tables ( 5mb ) .

QUESTIONS

  • Since the databases size is smaller than the available memory, how can I make full usage of my server's resources?
  • What settings should I attempt configure in my.cnf?
  • Can I force data + indexes to stay in memory?
share|improve this question
    
While this does not answer your question, I strongly recommend switching over to InnoDB. Here's why –  Shlomi Noach Oct 2 '13 at 5:00

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.