Fixing MySQL indexes

A little background. I've been noticing that posting to my Wordpress site is incredibly slow, so I logged into phpMySQL to poke around and noticed some unusual looking info on the "Runtime Information" page for my db. Among the findings is thie :

In reply to:

---

Select_full_join 19 k
Handler_read_rnd 54 M
Handler_read_rnd_next 666 M

---

From the Googling I've done it seems that one or more of my indexes has become corrupted. I've run some queries like this :

In reply to:

---

REPAIR TABLE wp_widgets USE_FRM

---

...but the slowness continues. Does anyone know a good,safe way to recreate the indexes for my tables? I saw some mentions of a utility called "myisamchk", but that doesn't seem to work from me from the command line.

Remember that the MySQL servers are shared so it might be someone ELSE'S data causing your server fits.

Generally in these cases we recommend reporting it to DH support for the MySQL admin gurus to take a look and do the maintenance things you described and maybe even kick the user that isn't playing nice.

Wholly - Use promo code WhollyMindless for full 97$ credit. Let me know if you want something else!