MySQL

When you are using MySQL, you will (likely) have tables that can be fragmented. In MySQL terms this is called “OPTIMIZE”. You could simply OPTIMIZE every table in every database, but during an OPTIMIZE, the tables are locked, so writing is not possible. To minimize the time that MySQL will be locked (and results cannot … Read more

Another tool of a similar nature is the MySQLReport tool which can be found at http://hackmysql.com. Information can be found here about how to read and analyse the report that is produces from this link http://hackmysql.com/mysqlreportguide. You can load it up remotely and build it on your server in a similar way making use of … Read more

Download/Installation Simple You can download the entire repository by using ‘git clone’ followed by the cloning URL above. The simplest and shortest method is: Change the permissions you can execute it without calling perl directly. [stextbox id=”warning”]——– Recommendations —————————————————–[/stextbox] General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 … Read more

Check a Specific Table in a Database If your application gives an error message saying that a specific table is corrupted, execute the mysqlcheck command to check that one table. The following are some of the key options that you can use along with mysqlcheck. -A, –all-databases Consider all the databases -a, –analyze Analyze tables -1, –all-in-1 Use … Read more

Export a database mysql Plesk Server To export a single table from your database you would use the following command: Import a database or table # mysql -p -u username database_name < file.sql [/bash] For Plesk server [bash] # mysql -u admin -p`cat /etc/psa/.psa.shadow` database < /tmp/database.sql [/bash] To import a single table into an ... Read more