I would check the slow query log. Queries that are taking a long time
(meaning slow) should be logged there. You can check your MySQL
configuration file to find out how long a query will run before it's
considered slow and where it is logging the info.
On Oct 25, 2005, at 3:16 AM, 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.
--
Luke
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
