Tag Archives: tuning

Monitor MySQL Performance with mytop

Monitor MySQL Performance with mytop | mytop is an excellent app to monitor mysql performance. Let’s check it out! Firstly, install mytop: $ sudo apt-get install mytop Run mytop with tack tack prompt to have mytop prompt for the root mysql password: $ mytop –prompt Done! You can now monitor the number of mysql queries the server is processing as well

Optimize MySQL my.cnf

Optimize MySQL my.cnf | If you are using MySQL, it can help to optimize MySQL according to how much ram you have on your server. Make these changes by editing: /etc/mysql/my.cnf Ubuntu and most all distros include example config file settings based on your available ram. These examples are generally located in: /usr/share/doc/mysql-server-5.1/examples/ -> my-small.cnf.gz my-medium.cnf.gz my-large.cnf.gz my-huge.cnf.gz my-small.cnf