On 04/06/12 20:24, Daniel Kraft wrote: > On 04/06/12 16:23, hvw59601 wrote: >> Daniel Kraft wrote: >>> Hi, >>> >>> I'm running Wheezy, and a recent update to MySQL made a database >>> application much, much slower. The query performed is a stored >>> procedure containing some loops, which before (at least on 24th May) >>> took less than one second, and now (today) more than four minutes. I >>> didn't change either the code nor the data. >>> >> >> <snip> >> >> What's the version of MySQL? > > It's the current version of Wheezy, 5.5.23+dfsg-2. Follow-up: I now installed mysql-common 5.1.26-1 from the snapshot archive and then the matching mysql-server-5.1 and mysql-client-5.1 packages. With them, I get back the old performance. Thus I hope that my immediate problem is fixed, but it is still interesting why the current version has this problem! Yours, Daniel -- http://www.domob.eu/ OpenPGP: 3BA2 3DDB 7758 F010 BDAB 0DCF 527E 79BA A3B5 3998 -- Done: Arc-Bar-Cav-Kni-Ran-Rog-Sam-Tou-Val-Wiz To go: Hea-Mon-Pri
Attachment:
signature.asc
Description: OpenPGP digital signature