Gmail User wrote: > I had perfectly working complex queries both with LEFT JOIN and without > and they were returning results in under a second. After upgrade to > 5.0.x, the same queries would return results in 20-30 second range.
I had a similar problem once (not related to 4.x->5.x though), it turns out after some maintenance mysql had lost the stats for the table and was doing a terrible job in optimizing queries. A quick analyze of all the tables in the db fixed the problem. mysqlcheck -h$host -u$user -p$pass --analyze $dbname ds > Through trial and error, I discovered that in case of SELECT ... FROM > table1, table2 ... ORDER BY table2.column will be very slow (10s of > seconds), while the same query ordered by table1.column will be in under > 1 second. If I switch the order of tables in FROM, the same will hold > true in reverse order. Is this a bug or I missed something in my > googling? More importantly, what can I do change this--I need those > sorts! :-( > > I got same results with 5.0.22, 5.0.27 (Linux). > > > TIA, > > Ed > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
