Re: Slow sql on one dataset, fast on others...how to use explain and optimize

explain for the fast database is exactly the same, but the rows number is now: 3,1,1,6,1,3,1 instead. Why do these queries run so differently? We have over 100 databases that run this query fast, all with different rowcounts in the tables. But in one database it runs slow... -

Slow sql on one dataset, fast on others...how to use explain and optimize

s that run this query fast, all with different rowcounts in the tables. But in one database it runs slow... --------- Are Pedersen Development Team Leader Server Operations manager -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Loadbalancing and redundancy for mysql servers.

fancy, but does it work well? anyone have any experience you want to share? ----- Are Pedersen Development Team Leader Server Operations manager ([EMAIL PROTECTED]) - -- MySQL General Mailing List For list arch