Hello.
Use SHOW PROCESSLIST to see what's going on in your database. Fajar Priyanto <[EMAIL PROTECTED]> wrote: > Hi all, > I'm hosting my web on a provider with MySQL 4.0.25-standard. > > I've got this situation when I open my database using phpMyadmin, one of my > table has status is "in use". > > And then when I try to repair the database, MySQL just hung there while > consumed around 50% of CPU. And then when I tried to export the database, > phpMyadmin got stuck at that tables, with a status of SHOW TABLE STATUS FROM > 'thetroubledtable'. > > I tried to contact the hosting provider, but it seems they're having weekend > break. > > Is there any way that I or my hosting provider can do about it? Maybe > restarting the mysql server is enough? Or can the table just being deleted? > Thanks, -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
