MySQL - The Perfect Server - MySQL

Discussion in 'Developers' Forum' started by fatbear, Apr 28, 2012.

  1. fatbear

    fatbear Member HowtoForge Supporter

    Hi all,

    I'm new to the developer group and I'm starting to install ISPConfig this weekend. One of the first things I want is to ensure that the MySQL is tuned appropriately. Please find attached the my.cnf file (inside my.zip) that I've used for some time. Note that I specify innodb as the default storage engine.

    I'm looking for a critical analysis of this my.cnf file. What would you change to make this appropriate for a "The Perfect Server - MySQL" article that I'm considering to write?

    I hope you enjoy looking at the my.cnf file!
     

    Attached Files:

    • my.zip
      File size:
      1.4 KB
      Views:
      89
    Last edited: Apr 28, 2012
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The optimal mysql settings depend on the hardware of the server and the actual load. It can e.g. be better to disable innodb instead of making it the default if your server has very low ram like 1GB in a vserver as the setup has mostly reads in the db and transactions are not used. To write a perfect mysql setup guide, it might be good to define server classes like 2, 4, 8 and 16GB RAM and make individual settings for them.

    My recommendation is to use mysqltuner to find the optimal settings for a specific system:

    http://www.faqforge.com/linux/optimize-mysql-performance-with-mysqltuner/
     

Share This Page