Hello, I'm receiving something like 10 emails like this everyday. It's mostily in "mailqueue" title (80% of cases), but there're also many other and random tables involved with this. The only constant is "MySQL Error : MySQL server has gone away". Script, referrer, ip address, username always different.
I've contacted the hosting and they said that the problem is that the database is too big.
I've around 400'000 messages and the DB size is around 900mb. The biggest tables are "post" 280mb, "searchcore_text" 480mb.
The server should be quite good. I've also a blog with wordpress on another database and I can have also 600 users online at the same time on wordpress.
With vbulletin everything goes really slow when I've 200 users online at the same time and it hit the limit of resource I can use from the cloud hosting. I receive these "error emails" also when I've only 20 users online. What can I do?
I've done a repair/optimize, but I'm continuing to receive errors.
Database error in vBulletin 4.2.0:
Invalid SQL:
UPDATE datastore SET
data = data - 7,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, September 30th 2014 @ 03:40:28 PM
Error Date : Tuesday, September 30th 2014 @ 03:53:42 PM
Script : ******URL hidden***
Referrer : ******URL hidden***
IP Address : **IP hidden**
Username : Non Registrato
Classname : vB_Database
MySQL Version :
I've contacted the hosting and they said that the problem is that the database is too big.
I've around 400'000 messages and the DB size is around 900mb. The biggest tables are "post" 280mb, "searchcore_text" 480mb.
The server should be quite good. I've also a blog with wordpress on another database and I can have also 600 users online at the same time on wordpress.
With vbulletin everything goes really slow when I've 200 users online at the same time and it hit the limit of resource I can use from the cloud hosting. I receive these "error emails" also when I've only 20 users online. What can I do?
I've done a repair/optimize, but I'm continuing to receive errors.
Database error in vBulletin 4.2.0:
Invalid SQL:
UPDATE datastore SET
data = data - 7,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, September 30th 2014 @ 03:40:28 PM
Error Date : Tuesday, September 30th 2014 @ 03:53:42 PM
Script : ******URL hidden***
Referrer : ******URL hidden***
IP Address : **IP hidden**
Username : Non Registrato
Classname : vB_Database
MySQL Version :
Comment