My hosting company is throttling my website due to database issues. I started getting the database problems after upgrading to VB 4.2.0 PL3
From my host:
From VB:
It is from various pages within my site and different users everytime.
Anyone else?
From my host:
The drop in the MySQL connection was actually not due to server wide issues with MySQL, but are due to your queries hitting limits on our server which cause your queries to be killed. These limits are dynamic and based on load, slow_query time and a variety of other factors. I found a large number of instances of your processes being blocked.
Our system has fairly generous limits so the first thing I would suggest is if you can optimize anything going on in that database and see if you can stay under the limits.
I will copy a portion of the entries from our logs, though this is just a sample and there are many more entries for your account username:
[Mon Apr 8 17:23:12 2013] tulsaoff LIMIT_ENFORCED period current value, field busy_time value 62/limit 30 restrict level 1 loadavg(1.93 1.98 1.67 3/744 59310) vmstat( 0 1 0 6891548 834100 11619564 0 0 25 97 1 1 6 2 92 1 0 ) slow_queries_timeout = 32, busy_time = 62, cpu_time = 1, bytes_received = 148779, bytes_sent = 207706, binlog_bytes_written = 0, rows_fetched = 1505, rows_updated = 124, table_rows_read = 71, select_commands = 7, update_commands = 32, other_commands = 4, commit_transactions = 10, rollback_transactions = 0, denied_connections = 0, lost_connections = 0, access_denied = 0, empty_queries = 6
Our system has fairly generous limits so the first thing I would suggest is if you can optimize anything going on in that database and see if you can stay under the limits.
I will copy a portion of the entries from our logs, though this is just a sample and there are many more entries for your account username:
[Mon Apr 8 17:23:12 2013] tulsaoff LIMIT_ENFORCED period current value, field busy_time value 62/limit 30 restrict level 1 loadavg(1.93 1.98 1.67 3/744 59310) vmstat( 0 1 0 6891548 834100 11619564 0 0 25 97 1 1 6 2 92 1 0 ) slow_queries_timeout = 32, busy_time = 62, cpu_time = 1, bytes_received = 148779, bytes_sent = 207706, binlog_bytes_written = 0, rows_fetched = 1505, rows_updated = 124, table_rows_read = 71, select_commands = 7, update_commands = 32, other_commands = 4, commit_transactions = 10, rollback_transactions = 0, denied_connections = 0, lost_connections = 0, access_denied = 0, empty_queries = 6
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT *, thread.title AS threadtitle
FROM rsslog AS rsslog
INNER JOIN rssfeed AS rssfeed ON(rssfeed.rssfeedid = rsslog.rssfeedid)
INNER JOIN thread AS thread ON(thread.threadid = rsslog.itemid)
WHERE rsslog.threadactioncomplete = 0
AND rsslog.itemtype = 'thread'
AND rsslog.threadactiontime <> 0
AND rsslog.threadactiontime < 1365725718;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, April 11th 2013 @ 08:15:18 PM
Error Date : Thursday, April 11th 2013 @ 08:20:33 PM
Script : http://www.tulsaoffroad.com/forums/c...and=1365725716
Referrer : http://www.tulsaoffroad.com/forums/forum.php
IP Address : 123.456.789.001
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
Invalid SQL:
SELECT *, thread.title AS threadtitle
FROM rsslog AS rsslog
INNER JOIN rssfeed AS rssfeed ON(rssfeed.rssfeedid = rsslog.rssfeedid)
INNER JOIN thread AS thread ON(thread.threadid = rsslog.itemid)
WHERE rsslog.threadactioncomplete = 0
AND rsslog.itemtype = 'thread'
AND rsslog.threadactiontime <> 0
AND rsslog.threadactiontime < 1365725718;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, April 11th 2013 @ 08:15:18 PM
Error Date : Thursday, April 11th 2013 @ 08:20:33 PM
Script : http://www.tulsaoffroad.com/forums/c...and=1365725716
Referrer : http://www.tulsaoffroad.com/forums/forum.php
IP Address : 123.456.789.001
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
Anyone else?
Comment