Jump to content

How do you know there is a problem with indexes ?

Recommended Posts

Hello ! :)

I sometimes have mysql reaching about 150% of CPU usage. I told myself this had perhaps something to do with indexes.

In the IPB ACP, there are tools to check if everything is ok with the database and the indexes.

When I ran these tools (database checker, database index checker in the "Support" tab) they told me everything was ok. But then I decided to use phpMyAdmin in order to check the tables and it told me I had duplicate indexes in my database. It was messages of this kind :

There are problems with the `ibf_attachments_type` table's indexes
The atype_extension and atype_extension_2 indexes seem identical and one of them could be deleted

So I got the duplicate indexes deleted, but in the end I'm not sure everything is ok with the indexes. Both the ACP tools and phpMyAdmin say it's ok, but is there another way to check the indexes very precisely ?

Thank you ! :)

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...