Jesse Vincent schrieb: > > On Fri, Jul 11, 2008 at 02:41:09PM +0200, Raphael Loziczky wrote: > >> thx for the tip, Arran but it's currently running with mysql 5.0.22 so >> the broken query optimizer can't be the problem... >> > > > Actually, 5.0.22 is known to have some AWFUL query optimizer bugs. My > recollection is that they were fixed in 5.0,45 or so > >
ok updated to 5.0.45 but still the same problem :( >> some more ideas? >> >> thanks, >> Raphael >> >> Arran Cudbard-Bell schrieb: >> >>> Raphael Loziczky wrote: >>> >>>> How can I enable RT debug log? mysql error log shows no errors... >>>> >>>> very slow means that it hangs for about 1 minute - we have our old >>>> system running with the same db which is much faster! (on old hardware) >>>> the mysql dump is about 20 gigs... when I made the dump from the old >>>> system I had to use "force recovery" mode with mysql to get a working >>>> dump. maybe thats the problem? >>>> >>> If your new mysql instance running mysql 5.1 ? >>> >>> If so the query optimizer is slightly broken, this can cause issues >>> with queries. Try with a version 5.0. >>> >>> Thanks, >>> Arran >>> >>>> Ruslan Zakirov schrieb: >>>> >>>>> RT debug log. mysql slow log. >>>>> >>>>> Very slow? How slow? Hangs forever or 1 minute? How big is your DB? >>>>> >>>>> On Fri, Jul 11, 2008 at 12:47 PM, Raphael Loziczky >>>>> <[EMAIL PROTECTED]> wrote: >>>>> >>>>> >>>>>> hi, >>>>>> >>>>>> I fixed the issue with lighttpd and got it up and running :) >>>>>> >>>>>> Now for testing proposals I use lighttpd and apache.... with both >>>>>> webservers I have the problem that e.g. opening a ticket is very slow >>>>>> (with both webservers) and the CPU usage increases to 100% .... >>>>>> >>>>>> Does anyone has an idea how to fix this? Its a brand new server and i >>>>>> dumped the mysql data in it... >>>>>> >>>>>> Thanks for any help! >>>>>> >>>>>> best regards, >>>>>> Raphael >>>>>> _______________________________________________ >>>>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >>>>>> >>>>>> Community help: http://wiki.bestpractical.com >>>>>> Commercial support: [EMAIL PROTECTED] >>>>>> >>>>>> >>>>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>>>>> Buy a copy at http://rtbook.bestpractical.com >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>> -- >>>> Raphael Loziczky >>>> System Administrator >>>> [EMAIL PROTECTED] >>>> ---------------------------------------------- >>>> Greentube Internet Entertainment Solutions AG >>>> Mariahilfer Straße 47/1/102 >>>> A-1060 Wien >>>> FN 197003k, HG Wien >>>> >>>> Tel: +43 1 494 50 56 - 30 >>>> Fax: +43 1 494 50 56 - 14 >>>> http://www.greentube.com/ >>>> >>>> ------------------------------------ >>>> Internet Email Confidentiality Footer >>>> ------------------------------------ >>>> Privileged/confidential information may be contained in this message. >>>> If you are not the addressee indicated in this message (or >>>> responsible for delivery of the message to this person), you may not >>>> copy or deliver this message to anyone. In such a case, you should >>>> destroy this message and kindly notify the sender by replying. Please >>>> make it known immediately f you or your employer does not consent to >>>> the medium of e-mail for messages of this kind. Opinions, conclusions >>>> and other information in this message that do not relate to the >>>> official business of my firm shall be understood as neither given nor >>>> endorsed by it. >>>> ------------------------------------------------------------------------ >>>> >>>> _______________________________________________ >>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >>>> >>>> Community help: http://wiki.bestpractical.com >>>> Commercial support: [EMAIL PROTECTED] >>>> >>>> >>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>>> Buy a copy at http://rtbook.bestpractical.com >>>> >>> >> -- >> Raphael Loziczky >> System Administrator >> [EMAIL PROTECTED] >> ---------------------------------------------- >> Greentube Internet Entertainment Solutions AG >> Mariahilfer Straße 47/1/102 >> A-1060 Wien >> FN 197003k, HG Wien >> >> Tel: +43 1 494 50 56 - 30 >> Fax: +43 1 494 50 56 - 14 >> http://www.greentube.com/ >> >> ------------------------------------ >> Internet Email Confidentiality Footer >> ------------------------------------ >> Privileged/confidential information may be contained in this message. If you >> are not the addressee indicated in this message (or responsible for delivery >> of the message to this person), you may not copy or deliver this message to >> anyone. In such a case, you should destroy this message and kindly notify >> the sender by replying. Please make it known immediately f you or your >> employer does not consent to the medium of e-mail for messages of this kind. >> Opinions, conclusions and other information in this message that do not >> relate to the official business of my firm shall be understood as neither >> given nor endorsed by it. >> >> _______________________________________________ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: [EMAIL PROTECTED] >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> >> > > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
