Hello.
>> > I changed the log level to 'alert' but got output in the log file. > Stopped and started the (apache) server and mysql server. > Any particular level that I should set it to? You should enable slow log in mysql configuration file. See: http://dev.mysql.com/doc/mysql/en/Slow_query_log.html http://dev.mysql.com/doc/mysql/en/Program_Options.html Luke Vanderfluit wrote: > Hi. > > Ruslan Zakirov wrote: > >> On 10/25/05, Luke Vanderfluit <[EMAIL PROTECTED]> wrote: >> >> >>> Hi. >>> >>> I have upgraded RT from 3.0.11 to 3.4.4. Mysql 4.0.18, Apache 1.3.27 >>> (with static modperl module). >>> The database we are using is quite large. >>> The main problem we are having is when a user needs to comment on a >>> ticket, the loading of a ticket can take quite a long time. >>> This is due to mysql churning through data. >>> I'd like to find out how to speed up this process. >>> >>> How do I find out what tables mysql is checking through when RT is >>> loading the Update.html page? >>> >> >> http://wiki.bestpractical.com/?Debug >> >> >> > I changed the log level to 'alert' but got output in the log file. > Stopped and started the (apache) server and mysql server. > Any particular level that I should set it to? > > Kind regards. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
