On Fri, 6 May 2005, Kevin Burton wrote:
> For the record... no a loaded system what type of IO do you guys see?
> Anywhere near full disk capacity? I'm curious to see what type of IO
> people are seeing on a production/loaded mysql box.
Mostly Linux in this thread so far, so I figured I'd throw some FreeBSD in
the mix. Our latest build which so far has worked out great, is MySQL
4.0.24 with linuxthreads on FreeBSD 4.10-R.
1) 15k RPM SCSI in RAID-10 configuration:
Threads: 61 Questions: 192440153 Slow queries: 1600 Opens: 361204
Flush tables: 1 Open tables: 128 Queries per second avg: 199.496
tty da0 fd0 pass0 cpu
tin tout KB/t tps MB/s KB/t tps MB/s KB/t tps MB/s us ni sy in id
0 1 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0 1 3 0 95
0 19 16.00 1 0.02 0.00 0 0.00 0.00 0 0.00 0 0 1 0 98
0 19 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0 7 9 1 84
0 19 15.57 14 0.21 0.00 0 0.00 0.00 0 0.00 0 4 4 1 91
0 19 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0 0 1 0 98
0 19 16.00 3 0.05 0.00 0 0.00 0.00 0 0.00 0 1 3 1 95
0 19 16.00 7 0.11 0.00 0 0.00 0.00 0 0.00 0 0 3 0 97
0 19 16.00 5 0.08 0.00 0 0.00 0.00 0 0.00 0 1 4 0 95
0 19 16.00 1 0.02 0.00 0 0.00 0.00 0 0.00 0 1 3 0 96
0 19 16.00 7 0.11 0.00 0 0.00 0.00 0 0.00 0 1 1 0 98
It does spike up to 15MB/s and 400tps, but that's pretty rare. For the
most part it stays below .20MB/s.
2) 15k RPM SCSI (single disk, no raid)
Threads: 427 Questions: 929834784 Slow queries: 99 Opens: 421800 Flush
tables: 2 Open tables: 128 Queries per second avg: 467.845
tty da0 fd0 pass0 cpu
tin tout KB/t tps MB/s KB/t tps MB/s KB/t tps MB/s us ni sy in id
0 1 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 2 2 15 2 78
0 38 28.00 4 0.11 0.00 0 0.00 0.00 0 0.00 2 1 15 1 81
0 38 64.00 1 0.06 0.00 0 0.00 0.00 0 0.00 2 1 17 2 78
0 38 5.50 4 0.02 0.00 0 0.00 0.00 0 0.00 0 2 12 3 82
0 38 64.00 1 0.06 0.00 0 0.00 0.00 0 0.00 3 3 16 1 76
0 38 64.00 1 0.06 0.00 0 0.00 0.00 0 0.00 4 2 18 1 75
0 38 64.00 1 0.06 0.00 0 0.00 0.00 0 0.00 1 2 13 4 80
0 38 22.67 3 0.07 0.00 0 0.00 0.00 0 0.00 2 3 13 2 79
0 38 64.00 1 0.06 0.00 0 0.00 0.00 0 0.00 3 0 18 1 77
0 38 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 0 2 14 1 83
The last setup was barely able to handle the load with pthreads as it does
spike to 700q/s daily, but with linuxthreads it's not even that loaded
anymore. Both of these systems are dual P4s.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
