Tag Archives: mysql

The mysql servers we use are configured to log slow queries ( those that take over 5 seconds to run or queries that do not use any index). The output is put in /var/log/mysqld.slow.log  ( on the dbhost server! ) … Continue reading →

Creating indexes in mysql on large tables can take a long time. Because it makes a temporary copy of the entire DB file first then creates the indexes. So be sure you have enough free space for the complete DB … Continue reading →

If you have a mysql database table with indexes and you want to get the alter table  commands to “create” the same indexes on another db You can run this sql — replacing the tablename with your table. Just add … Continue reading →