Problem after setup remote mySQL

mahdy_sharifi

Well-Known Member
Feb 26, 2012
220
1
68
cPanel Access Level
Root Administrator
Hi :

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

Code:
-----------------------------------------------+
| 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
 

mahdy_sharifi

Well-Known Member
Feb 26, 2012
220
1
68
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,910
2,216
463
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.