Problem after setup remote mySQL

[mahdy_sharifi]

Hi :

after setup remote mysql server , some website not loaded , after check mysql processlist I see following detail :

-----------------------------------------------+
| Id  | User           | Host                            | db                | Command | Time | State          | Info
                                               |
+-----+----------------+---------------------------------+-------------------+---------+------+----------------+-------------------------------------------------------
-----------------------------------------------+
| 184 | username_ayeha | server6.domain.net:45217 | username_username | Query   | 3    | Writing to net | SELECT
                        userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user. |
| 185 | username_ayeha | server6.net:45224 | username_username | Sleep   | 36   |                |
                                               |
| 189 | username_ayeha | server6.net:45278 | username_username | Query   | 25   | Writing to net | SELECT *
                        FROM datastore
                        WHERE title IN ('smiliecache','bbcodecache','mailqueue','bookmarksitec |
| 190 | username_ayeha | server6.net:45290 | username_username | Query   | 22   | Writing to net | SELECT *
                        FROM datastore
                        WHERE title IN ('userstats','birthdaycache','maxloggedin','iconcache', |
| 191 | username_ayeha | server6.net:45295 | username_username | Query   | 21   | Writing to net | SELECT *
                        FROM datastore
                        WHERE title IN ('iconcache','mailqueue','prefixcache','options','bitfi |
| 217 | username_ayeha | server6.net:45388 | username_username | Query   | 11   | Writing to net | SELECT *
                        FROM datastore
                        WHERE title IN ('smiliecache','bbcodecache','options','bitfields','att |
| 226 | username_ayeha | server6.net:45424 | username_username | Query   | 8    | Writing to net | SELECT *
                        FROM datastore
                        WHERE title IN ('smiliecache','bbcodecache','mailqueue','bookmarksitec |
| 230 | username_ayeha | server6.net:45430 | username_username | Query   | 7    | Writing to net | SELECT *
                        FROM datastore
                        WHERE title IN ('smiliecache','bbcodecache','mailqueue','bookmarksitec |
| 231 | root           | localhost                       |                   | Query   | 0    |                | show processlist
                                               |
+-----+----------------+---------------------------------+-------------------+---------+------+----------------+-------------------------------------------------------
-----------------------------------------------+

Remote mysql server on same DC , with Ping under 1ms

Regards

 

[toshost]

check you website's config file may be some of your website config file try to connect mysql using localhost.

 

[mahdy_sharifi]

check you website's config file may be some of your website config file try to connect mysql using localhost.

Thank You
But It is appear your comment not help us , website config change with new server detail .

 

[cPanelMichael]

Hello

Could you let us know the specific error message you see on your website or in the Apache error log when it fails to load?

Thank you.

 

[mahdy_sharifi]

Time out ...

 

[cPanelMichael]

Time out ...

Could you elaborate? For instance, are there no entries in the Apache error log or the MySQL error log when this happens?

Thank you.