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. -- Douglas Furlong Senior Unix Administrator tel: +44 (0) 1727 891 423 fax: +44 (0) 1727 891 401 mob: +44 (0) 7795 601 836 web: www.arc.com ARC International, Verulam Point, Station Way, St Albans, AL1 5HE, United Kingdom.
signature.asc
Description: This is a digitally signed message part
_______________________________________________ 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/
