Re: SQL runing very slow after restore

2005-03-02 Thread Gleb Paharenko
Hello. >seconds, but my mysql 4.1.10 takes forever to run. Do the queries never end? Or they're finishing after the long time? > I don't know whether all indexes are rebuilt correctly in the new database > (mysql 4.1.10). How do I know all my previous indexes are in-placed with the > res

SQL runing very slow after restore

2005-03-01 Thread sam wun
Hi, I finally got the backup data ported from mysql 5.0 (from freebsd) to mysql 4.1.10 in Redhat. Webmin started up and I can browse the data in each table. After installed all prerequisit perl modules, and start the web gui and start to run some queries, I expeirence it runs very slow. A sql in my