Re: Slow connection, urgent!
Did you add appropriate indexes to MySQL after you migrated?
You need to isolate what's running slowly and why. When a page that loads slowly is loading, do SHOW PROCESSLIST; to see which query is taking long to execute and what it's doing while executing. Then EXPLAIN that query and paste the result here, then SHOW CREATE TABLE any relevant tables the slow query uses and paste that here too.
Subject
Views
Written By
Posted
2783
September 30, 2005 12:37PM
Re: Slow connection, urgent!
1542
September 30, 2005 02:20PM
1842
September 30, 2005 04:35PM
1519
September 30, 2005 07:55PM
1764
October 08, 2005 05:01AM
1596
October 08, 2005 05:47AM
1776
October 08, 2005 06:22AM
1532
October 11, 2005 09:45AM
1570
October 13, 2005 09:35AM
1513
October 16, 2005 10:58AM
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.