XF 1.3 Persistent database errors.

[LurkerLou]

Zend_Db_Adapter_Mysqli_Exception: Lost connection to MySQL server at 'reading initial communication packet', system error: 104 - library/Zend/Db/Adapter/Mysqli.php:333

#0 /home/*****/***.com/library/Zend/Db/Adapter/Abstract.php(315): Zend_Db_Adapter_Mysqli->_connect()
#1 /home/*****/***.com/library/XenForo/Application.php(685): Zend_Db_Adapter_Abstract->getConnection()
#2 [internal function]: XenForo_Application->loadDb(Object(Zend_Config))
#3 /home/*****/***.com/library/XenForo/Application.php(922): call_user_func_array(Array, Array)
#4 /home/*****/***.com/library/XenForo/Application.php(953): XenForo_Application->lazyLoad('db', NULL)
#5 /home/*****/***.com/library/XenForo/Application.php(1481): XenForo_Application::get('db')
#6 /home/*****/***.com/library/XenForo/Model.php(161): XenForo_Application::getDb()
#7 /home/*****/***.com/library/XenForo/Model/DataRegistry.php(138): XenForo_Model->_getDb()
#8 /home/*****/***.com/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
#9 /home/*****/***.com/library/XenForo/Dependencies/Abstract.php(144): XenForo_Model_DataRegistry->getMulti(Array)
#10 /home/*****/***.com/library/XenForo/FrontController.php(127): XenForo_Dependencies_Abstract->preLoadData()
#11 /home/*****/***.com/index.php(13): XenForo_FrontController->run()
#12 {main}

Also

Zend_Db_Adapter_Mysqli_Exception: Lost connection to MySQL server at 'reading authorization packet', system error: 0 - library/Zend/Db/Adapter/Mysqli.php:333

 

[Mike]

Both of these really just represent server issues. There's nothing XF can do to cause or prevent them. I would suspect that this indicates a high load or an inconsistent network link (if MySQL is on a separate server).

 

[LurkerLou]

There's usually under 250 people on at a time. It hasn't been a problem in the past. The provider is claiming it's because of server load. I call BS on that because it hasn't been an issue in the past and server load has declined in the past month, not increased.

 

[LurkerLou]

One of their suggestions is to optimize the database. Is there any danger in doing so through myPHP? The directions seem almost too easy, select the tables and then select optimize.

 

[Mike]

Well it could be network issues. You may want to have a look at these:

http://dev.mysql.com/doc/refman/5.0/en/error-lost-connection.html
http://stackoverflow.com/questions/1434451/what-does-connection-reset-by-peer-mean

(The first error has a system error code of 104 which is "connection reset by peer".)

I still think load could be a factor, b doing table optimization isn't likely to do anything to solve it.