https://bugzilla.novell.com/show_bug.cgi?id=339081#c3
--- Comment #3 from Roland Langner
are you able to reproduce the performance drop with the latest rpms from http://download.opensuse.org/repositories/server:/database/SUSE_Linux_10.1/ ?
with the latest rpms (mysql-5.0.45-15.1) the performance drop has gone.
Also, could you provide a test case, eg. a script to create and fill in the tables and the query that's slow with 5.0.26?
I made a testcase for 5.0.26 with two tables tmp and wf. (bug339081db.tar.gz) Test query: SELECT tmp.id as id FROM tmp, wf where tmp.id=wf.id and wf.reihe=tmp.reihe and next='pickdata' ORDER BY last; On my machine it takes 1 min 21 sec for mysql 5.0.26 it takes 0.02 sec for mysql-5.0.45-15.1 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.