MySQL Forums
Forum List  »  Optimizer & Parser

Optimizer struggling with smaller dataset
Posted by: Damian Harvey
Date: March 31, 2010 09:09PM

Hi all,

I have two datasets in two databases with identical structures:
- Database A is our production dataset
- Database B is our QA dataset and is roughly half the size of database A

For some reason one of our queries runs in about 2-3 seconds on database A but takes more than 10 minutes on database B.

This is definitely a data issue as I've exported the data in the relevant tables from A and loaded it into B (ie. same structure) and the query runs quickly.

The query plans are different for each dataset. I can only assume that the Optimizer is adjusting it's logic based on the data?

What could cause this behaviour? What settings can I adjust to try to remedy the situation?

Many Thanks,

Damian.

Options: ReplyQuote


Subject
Views
Written By
Posted
Optimizer struggling with smaller dataset
2388
March 31, 2010 09:09PM


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.