Hello.
MySQL allows you to find out the slow queries. Have a look here: http://dev.mysql.com/doc/mysql/en/Slow_query_log.html Luke Vanderfluit wrote: > Hi. > > I have upgraded RT Request Tracker. I'm using 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 that certain processes 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 (the > application) is loading a particular page? > > I'm pretty sure that the lag is caused by an oversized table. > Are there any suggestions on how to find out more precisely which > processes are taking place during the lag? > > Thanks. > > 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]
