MySQL – A simple script to truncate all MySQL tables in a Database
Want a quick and dirty way to Truncate all the tables in a MySQL DB? You can use the following one line script. mysqldump -ppassword YourDBName –no-data dumpfile | mysql…
Read moreMySQL – Innodb Slow Shutdown – Dirty Buffer Pages
If you have a MySQL server that reserves a large amount of memory for the Innodb buffer pool, you may have seen that it can often take a very long…
Read more