MySQL Forums
Forum List  »  InnoDB

Incredible slow down... Why?
Posted by: Lucio Menci
Date: September 05, 2014 05:25AM

Hy,

A customer has a DB, that I backed up. I dropped the schema into my PC, and restored that DB. I saw that some rows, added into my PC, made verifies, copied that rows into another tables, backed up that tables, changed the table name into the sql and restored into the customer DB.

Now, performing a select into my PC, it needs about a seconds, into my customer'd PC, it needs over than 50 seconds.

The select is a single table select, with conditions about two columns that are the first two columns into a index that is not the primary one. The Set Explain shows this index as the possible_key to perform the select.

How do I restore an adequate performance?

Options: ReplyQuote


Subject
Views
Written By
Posted
Incredible slow down... Why?
1606
September 05, 2014 05:25AM
807
September 05, 2014 02:43PM
810
September 07, 2014 10:43AM
882
September 08, 2014 07:37AM
987
September 08, 2014 09:56AM
850
September 09, 2014 01: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.