Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 Server Upgrade Notice [update]

views
     
wKkaY
post Sep 4 2007, 12:23 PM

misutā supākoru
Group Icon
VIP
6,008 posts

Joined: Jan 2003
So far, the average-case timings I have are:

15 minutes - mysqldump
5 minutes - transfer
15 minutes - mysql import

Plus another 20 minutes for hardware fiddling. I think 2 hours is a reasonable window to expect smile.gif
wKkaY
post Sep 11 2007, 03:02 PM

misutā supākoru
Group Icon
VIP
6,008 posts

Joined: Jan 2003
Here's some performance graphs before and after the upgrade.

user posted image
This is the old DB server's typical load over a day. Look at the fat IO Wait graph, indicating that we're IO-saturated.

user posted image
While this is the new DB server's typical load. What load!? rclxm9.gif

user posted image
And as a consequence of reduced DB backlog, the webserver's load spikes have reduced as well. This is a weekly graph, so compare the first 3 days (pre-upgrade) and the days following it.

 

Change to:
| Lo-Fi Version
0.0152sec    0.45    6 queries    GZIP Disabled
Time is now: 28th November 2025 - 02:05 AM