Re: MySQL 4.1 to 5.1 large scale upgrade
Posted by: Jcink Cink
Date: April 02, 2011 11:33AM

Yeah, SHOW TABLES is just incredibly slow. I haven't been able to use it in years now, but with that many tables I expect it. Honestly, a custom script that runs a repair on each one that takes the output of a plain old 'ls' would work so much better. The size and all the other data just don't matter and it just slows everything down.

But even that is going to take some time to run through and repair all the tables. Still better than waiting hours on end for SHOW TABLES.

I've been testing our software all week on MySQL 5.1 without issuing any repair tables and things are still ok. The upgrade will happen hopefully in the next few days and I'll post back if there were any problems.

Edited 2 time(s). Last edit at 04/02/2011 11:40AM by Jcink Cink.

Options: ReplyQuote

Written By
Re: MySQL 4.1 to 5.1 large scale upgrade
April 02, 2011 11:33AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.