Tag Archives: optimize mysql

Use mysqlcheck to Optimize and Repair MySQL Databases

Use mysqlcheck to Optimize and Repair MySQL Databases | mysqlcheck is a simple command line app that can check mysql databases for corruption, make repairs, and also optimize your databases. Here are three quick commands that are useful to check, optimize, and also repair your mysql databases! 1. Check Databases $ mysqlcheck -cA -u root -p (-c for check database, -A for all databases)

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