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" <[EMAIL PROTECTED]> wrote: > 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. _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
