i wrote a ticket to my hosting company and this is what they had to say:
Details given:
We are notifying you that your account, or a portion or feature of your account has caused an overload on one of our servers. We have a shared hosting environment that we must maintain at a certain level of performance. This performance is monitored and balanced by us, however there are times when accounts can cause the server's load to increase degrading the performance for all other customers on this server.
To protect your account from further action you must agree to our request for compliance. Please respond to this message stating your intent to do so. You may either log into your control panel with us, and access this ticket via the 24/7 help desk, or provide this ticket number to our Live Chat or phone representatives.
Failure to respond to this message within 72 hours will result in the suspension of the affected domain with us until such a time as this matter is resolved.
Most common queries for C245476_*:
1.Time: 57% (11748 sec)
Amount: 50% (220 queries)
Rows Examined/Sent: 28262179 / 422
Avg. Query Exec/Lock Time: 53 / 0 sec.
Used databases: [C245476_glistennext]
Query example: use C245476_glistennext; SELECT c.*, i.catid, i.title, i.alias, category.alias as catalias, category.name as categoryname FROM -- k2_comments as c LEFT JOIN -- k2_items as i ON i.id=c.itemID LEFT JOIN -- k2_categories as category ON category.id=i.catid WHERE i.published=1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2012-04-25 07:08:30' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2012-04-25 07:08:30' ) AND i.trash=0 AND i.access<=0 AND category.published=1 AND category.trash=0 AND category.access<=0 AND c.published=1 ORDER BY c.commentDate DESC LIMIT 0, 2;
2.Time: 12% (2489 sec)
Amount: 8% (36 queries)
Avg. Query Exec/Lock Time: 69 / 55 sec.
Used databases: [C245476_glistennext|C245476_joomla4|C245476_joomla5]
Query example: use C245476_glistennext; DELETE FROM -- session WHERE ( time < '1335250641' );
3.Time: 8% (1803 sec)
Amount: 5% (22 queries)
Avg. Query Exec/Lock Time: 81 / 73 sec.
Used databases: [C245476_glistennext]
Query example: use C245476_glistennext; UPDATE -- k2_items SET hits = ( hits + 1 ) WHERE id='28';
4.Time: 6% (1380 sec)
Amount: 6% (27 queries)
Avg. Query Exec/Lock Time: 51 / 38 sec.
Used databases: [C245476_glistennext|C245476_joomla5|C245476_joomla4]
Query example: use C245476_joomla4; UPDATE -- session` SET `time`='1335340503',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1335340502;s:18:\"session.timer.last\";i:1335340502;s:17:\"session.timer.now\";i:1335340502;s:22:\"session.client.browser\";s:71:\"Sogou web spider/4.0(+http://www.sogou.com/docs/help/webmasters.htm#07)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUse ... [too long]
5.Time: 5% (1102 sec)
Amount: 6% (26 queries)
Rows Examined/Sent: 100430 / 14612
Avg. Query Exec/Lock Time: 42 / 2 sec.
Used databases: [C245476_glistennext]
Query example: use C245476_glistennext; SELECT session_id, time, guest, data FROM -- session WHERE '1=1' AND time >= 1335336317 AND time < 1335337200;
6.Time: 2% (591 sec)
Amount: 6% (27 queries)
Avg. Query Exec/Lock Time: 21 / 11 sec.
Used databases: [C245476_glistennext|C245476_joomla4]
Query example: use C245476_glistennext; INSERT INTO -- session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '48u1bu0lioohbodjnkhqhmnn91','1335340500','','0','1','0' );
7.Time: 2% (568 sec)
Amount: 4% (19 queries)
Rows Examined/Sent: 890451 / 190
Avg. Query Exec/Lock Time: 29 / 0 sec.
Used databases: [C245476_glistennext]
Query example: use C245476_glistennext; SELECT * FROM -- k2_comments WHERE itemID=28 AND published=1 ORDER BY commentDate DESC LIMIT 6470, 10;
Database C245476_glistennext has been chmoded to 0.
