we are going through an issue of overhead at the mysql db server for quite some time.
Investigating a little further, we found that specific requests are been made continuously.
The queries been made are like bellow:
Code: Select all
SELECT * FROM comments WHERE parent_comment_id = '15250' ORDER BY date_posted
SELECT * FROM comments WHERE parent_comment_id = '14134' ORDER BY date_posted
And there goes on. These queries are surprinsingly consuming about 100% of the cpu load.
It seems like that request is defined in the file CommentDAO.inc.php. We have already moved the system to another more robust server but with no effect, and also upgraded the mysql server, still with no success.
Any ideas what could be the cause of the overload of the server?