Mailinglist Archive: opensuse-bugs (9648 mails)

[bugzilla_noreply@xxxxxxxxxx]

https://bugzilla.novell.com/show_bug.cgi?id=339081

           Summary: mysql performance problem after last onlineupdate
           Product: SUSE Linux 10.1
           Version: Final
          Platform: Other
        OS/Version: Other
            Status: NEW
          Severity: Major
          Priority: P5 - None
         Component: Other
        AssignedTo: bnc-team-screening@xxxxxxxxxxxxxxxxxxxxxx
        ReportedBy: suslan@xxxxxxxxxxxx
         QAContact: qa@xxxxxxx
          Found By: Customer


Hello,

the last update to mysql 5.0.26-12.13 from 5.0.18 brought me a serious
performance problem.

The following mysql statment:

SELECT radpro.id as id, typ, verf, pjtitel, stat, nummer, last
FROM tmp, radpro, wf where radpro.id=tmp.id and tmp.id=wf.id and
wf.reihe=tmp.reihe and next='somename' ORDER BY last;

took 0.3 Sec with mysql 5.0.18 and it took 2 Minutes 30 Sec with mysql 5.0.26
on the same data-tables.

So I went back to mysql 5.0.18

Regards
Roland Langner


-- 
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.