Turn this on in your my.cnf file so you can see if it's the MySQL queries: #log_slow_queries = /var/log/mysql/mysql-slow.log
Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com 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? > > > 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 _______________________________________________ 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
