You are viewing a plain text version of this content. The canonical link for it is here.
Posted to infrastructure-issues@apache.org by "Sander Temme (JIRA)" <ji...@apache.org> on 2005/11/03 21:23:45 UTC
[jira] Created: (INFRA-613) Move MySQL data files to different spindle on ajax
Move MySQL data files to different spindle on ajax
--------------------------------------------------
Key: INFRA-613
URL: http://issues.apache.org/jira/browse/INFRA-613
Project: Infrastructure
Type: Task
Reporter: Sander Temme
Assigned to: Sander Temme
Move MySQL data files, currently in /x1/mysql-store and symlinked from /var/lib/mysql, to /raid1 which is seeing much lighter use. Hopefully this will reduce the I/O contention on the box somewhat. It'll also give us the benefit of soft RAID1 redundancy.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Closed: (INFRA-613) Move MySQL data files to different spindle on ajax
Posted by "Sander Temme (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/INFRA-613?page=all ]
Sander Temme closed INFRA-613:
------------------------------
Resolution: Fixed
On to step 15. Five second snapshot before:
avg-cpu: %user %nice %sys %iowait %idle
5.01 0.00 2.51 92.48 0.00
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda 22.01 640.25 105.64 3200 528
sda1 0.00 0.00 0.00 0 0
sda2 0.00 0.00 0.00 0 0
sda3 7.20 230.49 0.00 1152 0
sda4 14.01 409.76 99.24 2048 496
sda5 0.80 0.00 6.40 0 32
sdb 455.38 6207.22 0.00 31024 0
sdb1 455.38 6207.22 0.00 31024 0
sdc 7.20 30.41 44.82 152 224
sdc1 7.20 30.41 44.82 152 224
sdd 5.00 12.81 44.82 64 224
sdd1 5.00 12.81 44.82 64 224
after:
avg-cpu: %user %nice %sys %iowait %idle
10.15 0.01 1.22 33.92 54.70
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda 37.41 1.60 985.99 8 4928
sda1 0.00 0.00 0.00 0 0
sda2 0.00 0.00 0.00 0 0
sda3 24.21 0.00 813.12 0 4064
sda4 12.60 1.60 168.07 8 840
sda5 0.60 0.00 4.80 0 24
sdb 18.81 697.87 0.00 3488 0
sdb1 18.81 697.87 0.00 3488 0
sdc 162.66 401.76 939.57 2008 4696
sdc1 162.66 401.76 939.57 2008 4696
sdd 151.06 304.12 939.57 1520 4696
sdd1 151.06 304.12 939.57 1520 4696
> Move MySQL data files to different spindle on ajax
> --------------------------------------------------
>
> Key: INFRA-613
> URL: http://issues.apache.org/jira/browse/INFRA-613
> Project: Infrastructure
> Type: Task
> Reporter: Sander Temme
> Assignee: Sander Temme
>
> Move MySQL data files, currently in /x1/mysql-store and symlinked from /var/lib/mysql, to /raid1 which is seeing much lighter use. Hopefully this will reduce the I/O contention on the box somewhat. It'll also give us the benefit of soft RAID1 redundancy.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (INFRA-613) Move MySQL data files to different spindle on ajax
Posted by "Sander Temme (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/INFRA-613?page=comments#action_12356721 ]
Sander Temme commented on INFRA-613:
------------------------------------
1) Put shutdownhtml in Bugzilla
2) Put shutdownhtml in SpamAssassin Bugzilla
3) Change proxy forwards for Scarab and Jira to Redirects to a maintenance page, graceful httpd
4) Shut down Jira Tomcat
5) Shut down scarab Tomcat
6) Shut down MySQL service
7) Copy /x1/mysql-store to /raid1
8) Change /var/lib/mysql symlink to point to /raid1/mysql-store
9) Start MySQL service
10) Start Jira Tomcat
11) Start Scarab Tomcat
12) Remove Redirects, graceful httpd
13) Remove shutdownhtml in SA Bugzilla
14) Remove shutdownhtml in Bugzilla
15) Drink beer
All this probably tonight when the load is lighter.
> Move MySQL data files to different spindle on ajax
> --------------------------------------------------
>
> Key: INFRA-613
> URL: http://issues.apache.org/jira/browse/INFRA-613
> Project: Infrastructure
> Type: Task
> Reporter: Sander Temme
> Assignee: Sander Temme
>
> Move MySQL data files, currently in /x1/mysql-store and symlinked from /var/lib/mysql, to /raid1 which is seeing much lighter use. Hopefully this will reduce the I/O contention on the box somewhat. It'll also give us the benefit of soft RAID1 redundancy.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira