Search code examples
mysqlindexingshutdown

MySQL was shut down during Index - How to fix the index?

MySQL was shut down in the middle of an indexing operation. It still works but some of the queries seem much slower than before. Is there anything particular we can check? Is it possible that an index gets half way through?

Thanks much

Solution

  • As a suggested in my comment, you could try a repair on the relevant table(s).

    That said, there's a section of the MySQL manual dedicated to this precise topic, which details how to use the REPAIR <table> statement and indeed dump/re-import.

    Is this doesn't make any difference, you may need to check the database settings (if it's a InnoDB engined table/database, it'll love being able to be resident in memory for example) and perhaps try to see what specific indexes are being used via an EXPLAIN on the queries that are causing pain.

    There are also commercial tools such as New Relic that'll show what specific queries are being sluggish in quite a lot of detail as well as monitoring other aspects of your system, which may be worth exploring if this is a commercial project/web site.