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