It's some agent job that someone set up?
Crontab -l the user that's running otrs to determine frequency and that
should also help :)
HTH,
Andy
On 10/18/07 10:25 AM, "Douglas Furlong"
Good afternoon all.
Just recently we've suffered a significant slowdown in the OTRS installation that we have (2.0.4).
The system has 2gb of ram, and the DB size (on disk) is about 2.4gb, it would appear that the system spends a phernominal amount of time in IO wait, and the database is constantly processing queries even when the system is not in use.
I enabled the feature in mysql to log slow queries, and I noticed on particular query repeating over and over, it is.
SELECT id FROM article WHERE ticket_id = 1699 AND a_from = 'Martin' AND a_subject = 'Resolving' AND incoming_time = '1191601751';
Where the ticket ID and incoming time varies.
grep -e Martin /var/log/mysql/log-slow-queries.log | grep Resolving | wc -l 49907
What may be causing the above to be constantly run against the DB, I see no similar queries being run for any of the other users within the environment.
Does any one have any thoughts, or hints on where I could look for additional information.