By TurtleX on

I have a large site that I just moved from shared to VPS. My VPS went down and fast. Drupal a heavy load on MySQL. I can't access my site via web browser. What changes should I make and how can I make those changes without browser access to my site? I hace FTP access if that helps.

⋅ Categories: Drupal 4.6.x

Comments

TurtleX’s picture

TurtleX commented

Here's some log info if anyone can pinpoint the problem from it I'd be very grateful.

| 171 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '66.67.223.61', session = 'messages|a:0:{}', timestamp = 114 |
| 173 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '72.244.7.1', session = 'messages|a:0:{}', timestamp = 11406 |
| 175 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '68.104.224.44', session = 'messages|a:0:{}', timestamp = 11 |
| 176 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '151.203.236.133', session = 'messages|a:0:{}', timestamp =  |
| 177 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '69.152.136.46', session = 'messages|a:0:{}', timestamp = 11 |
| 178 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '216.144.226.3', session = 'messages|a:0:{}', timestamp = 11 |
| 180 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '24.24.168.27', session = 'messages|a:0:{}', timestamp = 114 |
| 182 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '216.7.248.254', session = 'messages|a:0:{}', timestamp = 11 |
| 183 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 184 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 186 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '68.196.186.154', session = 'messages|a:0:{}', timestamp = 1 |
| 187 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '205.188.116.69', session = 'messages|a:0:{}', timestamp = 1 |
| 188 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 189 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 190 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 191 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 192 | database_drpl2 | localhost | database_drpl2 | Query   | 0    |             |                                                                                                      |
| 193 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 194 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 195 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 196 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 197 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | Locked      | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 198 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | Locked      | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 199 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | Locked      | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 200 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 201 | database_drpl2 | localhost | database_drpl2 | Query   | 0    |             |                                                                                                      |
| 202 | database_drpl2 | localhost | database_drpl2 | Query   | 0    |             |                                                                                                      |
| 203 | database_drpl2 | localhost | database_drpl2 | Sleep   | 2    |             |                                                                                                      |
| 204 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | statistics  | SELECT u.* FROM users u WHERE u.uid = 0                                                              |
| 205 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 206 | database_drpl2 | localhost | database_drpl2 | Sleep   | 2    |             |                                                                                                      |
| 207 | database_drpl2 | localhost | database_drpl2 | Query   | 0    |             |                                                                                                      |
| 208 | database_drpl2 | localhost | database_drpl2 | Sleep   | 1    |             |                                                                                                      |
| 209 | database_drpl2 | localhost | database_drpl2 | Sleep   | 1    |             |                                                                                                      |
| 210 | database_drpl2 | localhost | database_drpl2 | Sleep   | 1    |             |                                                                                                      |
| 211 | database_drpl2 | localhost | database_drpl2 | Sleep   | 2    |             |                                                                                                      |
| 212 | database_drpl2 | localhost | database_drpl2 | Query   | 2    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('5f05a3e5dab024a7e8454284dd8397a1', 0,  |
| 213 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | statistics  | SELECT data, created, headers FROM cache WHERE cid = 'menu:0:en'                                     |
| 214 | database_drpl2 | localhost | database_drpl2 | Sleep   | 2    |             |                                                                                                      |
| 215 | database_drpl2 | localhost | database_drpl2 | Query   | 2    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('0577a33dd3347877b078b5fd88b012e2', 0,  |
| 216 | database_drpl2 | localhost | database_drpl2 | Query   | 1    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('220e9268f401f1dde2c89f0f7dbab909', 0,  |
| 217 | database_drpl2 | localhost | database_drpl2 | Query   | 1    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('056682e32e0cd57bc5cf44d47b3ce4cc', 0,  |
| 218 | database_drpl2 | localhost | database_drpl2 | Query   | 1    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('67d912be3ccfade447073eeffed2ef8e', 0,  |
| 219 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('aed83db3c821154dd23bfd4e09f696c5', 0,  |
| 220 | database_drpl2 | localhost | database_drpl2 | Query   | 2    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('a9012dc11754556a737dcb51a0fc0efb', 0,  |
| 221 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('a2983d7fdc05a6db5779dff3547edc28', 0,  |
| 222 | database_drpl2 | localhost | database_drpl2 | Query   | 1    | statistics  | SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = 'e0f8129169da07b0e |
| 224 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | Locked      | SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = 'e0f292fe55eacf3ed |
| 171 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '66.67.223.61', session = 'messages|a:0:{}', timestamp = 114 |
| 173 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '72.244.7.1', session = 'messages|a:0:{}', timestamp = 11406 |
| 175 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '68.104.224.44', session = 'messages|a:0:{}', timestamp = 11 |
| 176 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '151.203.236.133', session = 'messages|a:0:{}', timestamp =  |
| 177 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '69.152.136.46', session = 'messages|a:0:{}', timestamp = 11 |
| 178 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '216.144.226.3', session = 'messages|a:0:{}', timestamp = 11 |
| 180 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '24.24.168.27', session = 'messages|a:0:{}', timestamp = 114 |
| 182 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '216.7.248.254', session = 'messages|a:0:{}', timestamp = 11 |
| 183 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 184 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 186 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '68.196.186.154', session = 'messages|a:0:{}', timestamp = 1 |
| 187 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | UPDATE sessions SET uid = 0, hostname = '205.188.116.69', session = 'messages|a:0:{}', timestamp = 1 |
| 188 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 189 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 190 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 191 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 192 | database_drpl2 | localhost | database_drpl2 | Query   | 0    |             |                                                                                                      |
| 193 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 194 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 195 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 196 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 197 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | Locked      | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 198 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | Locked      | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 199 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | Locked      | SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM sessions WHERE timestamp >= 1140635613 AN |
| 200 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 201 | database_drpl2 | localhost | database_drpl2 | Query   | 0    |             |                                                                                                      |
| 202 | database_drpl2 | localhost | database_drpl2 | Query   | 0    |             |                                                                                                      |
| 203 | database_drpl2 | localhost | database_drpl2 | Sleep   | 2    |             |                                                                                                      |
| 204 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | statistics  | SELECT u.* FROM users u WHERE u.uid = 0                                                              |
| 205 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | cleaning up | SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1140635612 AND uid = 0                   |
| 206 | database_drpl2 | localhost | database_drpl2 | Sleep   | 2    |             |                                                                                                      |
| 207 | database_drpl2 | localhost | database_drpl2 | Query   | 0    |             |                                                                                                      |
| 208 | database_drpl2 | localhost | database_drpl2 | Sleep   | 1    |             |                                                                                                      |
| 209 | database_drpl2 | localhost | database_drpl2 | Sleep   | 1    |             |                                                                                                      |
| 210 | database_drpl2 | localhost | database_drpl2 | Sleep   | 1    |             |                                                                                                      |
| 211 | database_drpl2 | localhost | database_drpl2 | Sleep   | 2    |             |                                                                                                      |
| 212 | database_drpl2 | localhost | database_drpl2 | Query   | 2    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('5f05a3e5dab024a7e8454284dd8397a1', 0,  |
| 213 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | statistics  | SELECT data, created, headers FROM cache WHERE cid = 'menu:0:en'                                     |
| 214 | database_drpl2 | localhost | database_drpl2 | Sleep   | 2    |             |                                                                                                      |
| 215 | database_drpl2 | localhost | database_drpl2 | Query   | 2    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('0577a33dd3347877b078b5fd88b012e2', 0,  |
| 216 | database_drpl2 | localhost | database_drpl2 | Query   | 1    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('220e9268f401f1dde2c89f0f7dbab909', 0,  |
| 217 | database_drpl2 | localhost | database_drpl2 | Query   | 1    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('056682e32e0cd57bc5cf44d47b3ce4cc', 0,  |
| 218 | database_drpl2 | localhost | database_drpl2 | Query   | 1    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('67d912be3ccfade447073eeffed2ef8e', 0,  |
| 219 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('aed83db3c821154dd23bfd4e09f696c5', 0,  |
| 220 | database_drpl2 | localhost | database_drpl2 | Query   | 2    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('a9012dc11754556a737dcb51a0fc0efb', 0,  |
| 221 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | Locked      | INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('a2983d7fdc05a6db5779dff3547edc28', 0,  |
| 222 | database_drpl2 | localhost | database_drpl2 | Query   | 1    | statistics  | SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = 'e0f8129169da07b0e |
| 224 | database_drpl2 | localhost | database_drpl2 | Query   | 0    | Locked      | SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = 'e0f292fe55eacf3ed |
Duplika’s picture

Duplika commented

How many visits and what type of VPS do you have? I remember having 12 Drupal sites at a cheap VPS (one had 5k uniques per month) and load was low.
--
Duplika | Web Hosting

TurtleX’s picture

TurtleX commented

Wow, that's awesome! My site is fairly busy. I get about 30,000 uniques a month. I have many modules on so I am now in the process of turning many off. I found this thread: http://drupal.org/node/32091 and am optimizing now.

Duplika’s picture

Duplika commented

You should also try to optimize your VPS. Where did you get it from? (just curious)
--
Duplika | Web Hosting

BryanSD’s picture

BryanSD commented

Version of PHP and MySQL between old and new server would also help. I also assume you changed the Drupal settings file for the new server?

Drupal Sites Coming Soon:
CMSReport

TurtleX’s picture

TurtleX commented

I'm hosted at jaguarpc. I finally got things working. I disabled a lot of modules.

radiofranky’s picture

radiofranky commented

what host are u using?