Hello I want to ask if i get better performance if i move my database on a new partition or is it better on a new hard disk? Is it a big difference on performance between new partition and new disk? Thank you
Yes. If your hard drive is already under heavy load (thus increasing %wa) then a new partition won't fix anything. You're better off getting a new hard disk and setting it up on that.
It helps a lot moving database to another hard drive. It performs better and your site will be more responsive and faster.
iostat -d -x 5 3 : Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util sda 0.01 61.62 0.09 72.21 3.09 1070.92 14.85 0.07 0.95 0.04 0.27 sda1 0.00 2.04 0.00 1.03 0.12 24.61 23.84 0.00 0.34 0.13 0.01 sda2 0.01 8.72 0.02 2.76 1.47 91.82 33.59 0.00 0.41 0.11 0.03 sda3 0.00 33.49 0.06 65.40 0.89 791.30 12.10 0.06 0.95 0.03 0.23 sda4 0.00 0.00 0.00 0.00 0.00 0.00 2.00 0.00 35.25 35.25 0.00 sda5 0.00 0.00 0.00 0.00 0.00 0.00 24.88 0.00 4.15 3.51 0.00 sda6 0.00 0.60 0.00 0.20 0.00 6.40 32.30 0.00 0.44 0.11 0.00 sda7 0.00 16.78 0.01 2.82 0.62 156.79 55.55 0.00 1.76 0.07 0.02 Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util sda 0.00 46.20 0.20 32.00 3.20 625.60 19.53 0.02 0.67 0.12 0.38 sda1 0.00 1.40 0.20 0.60 3.20 16.00 24.00 0.00 3.00 3.00 0.24 sda2 0.00 15.80 0.00 2.40 0.00 145.60 60.67 0.00 0.00 0.00 0.00 sda3 0.00 14.20 0.00 28.20 0.00 339.20 12.03 0.02 0.67 0.04 0.12 sda4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 sda5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 sda6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 sda7 0.00 14.80 0.00 0.80 0.00 124.80 156.00 0.00 0.25 0.25 0.02 Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util sda 0.00 141.00 0.00 196.80 0.00 2704.00 13.74 0.26 1.33 0.02 0.38 sda1 0.00 5.20 0.00 0.60 0.00 46.40 77.33 0.00 0.00 0.00 0.00 sda2 0.00 14.20 0.00 2.20 0.00 131.20 59.64 0.00 0.64 0.09 0.02 sda3 0.00 87.80 0.00 174.20 0.00 2097.60 12.04 0.24 1.39 0.02 0.36 sda4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 sda5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 sda6 0.00 1.40 0.00 0.40 0.00 14.40 36.00 0.00 0.00 0.00 0.00 sda7 0.00 32.40 0.00 19.40 0.00 414.40 21.36 0.02 0.96 0.01 0.02 Code (markup): hdparm -Tt (device) : Filesystem Size Used Avail Use% Mounted on /dev/sda1 48G 670M 45G 2% / /dev/sda7 87G 1.4G 81G 2% /home /dev/sda6 9.5G 152M 8.9G 2% /tmp /dev/sda3 48G 2.4G 43G 6% /var /dev/sda2 48G 4.5G 41G 10% /usr tmpfs 7.9G 0 7.9G 0% /dev/shm root@server [~]# hdparm -Tt /dev/sda2 /dev/sda2: Timing cached reads: 13892 MB in 2.00 seconds = 6957.42 MB/sec Timing buffered disk reads: 410 MB in 3.01 seconds = 136.26 MB/sec root@server [~]# hdparm -Tt /dev/sda3 /dev/sda3: Timing cached reads: 13636 MB in 2.00 seconds = 6828.73 MB/sec Timing buffered disk reads: 1122 MB in 3.00 seconds = 373.88 MB/sec root@server [~]# hdparm -Tt /dev/sda7 /dev/sda7: Timing cached reads: 10620 MB in 1.98 seconds = 5365.54 MB/sec Timing buffered disk reads: 688 MB in 3.02 seconds = 227.56 MB/sec Code (markup): What do you think?