Satoshi Tajima s-tajima
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [root@mysql-test01 fio1]# sysbench --test=fileio --file-total-size=20G --file-test-mode=rndrw --max-requests=100000 run | |
| sysbench 0.4.12: multi-threaded system evaluation benchmark | |
| Running the test with following options: | |
| Number of threads: 1 | |
| Extra file open flags: 0 | |
| 128 files, 160Mb each | |
| 20Gb total file size | |
| Block size 16Kb |
s-tajima
/ fio1_ext4_seq_01.txt
Created
May 29, 2014 13:31
Result of ioDrive benchmark. (sequential)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [root@mysql-test01 fio1]# sysbench --test=fileio --file-total-size=20G --file-test-mode=seqwr --max-requests=100000 run | |
| sysbench 0.4.12: multi-threaded system evaluation benchmark | |
| Running the test with following options: | |
| Number of threads: 1 | |
| Extra file open flags: 0 | |
| 128 files, 160Mb each | |
| 20Gb total file size | |
| Block size 16Kb |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| for DIR in "fio1" "fio2" "hdd1" "hdd2" | |
| do | |
| sync | |
| echo 3 > /proc/sys/vm/drop_caches | |
| sync | |
| sysbench \ | |
| --test=oltp \ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [root@mysql-test01 result]# df -hT | |
| Filesystem Type Size Used Avail Use% Mounted on | |
| /dev/mapper/VolGroup-lv_root ext4 50G 3.4G 44G 8% / | |
| tmpfs tmpfs 15G 0 15G 0% /dev/shm | |
| /dev/sda1 ext4 485M 32M 428M 7% /boot | |
| /dev/mapper/VolGroup-lv_hdd1 ext4 74G 1.3G 69G 2% /hdd1 | |
| /dev/mapper/VolGroup-lv_hdd2 xfs 75G 1.3G 74G 2% /hdd2 | |
| /dev/fioa ext4 74G 1.3G 69G 2% /fio1 | |
| /dev/fiob xfs 75G 1.3G 74G 2% /fio2 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [mysqld_multi] | |
| mysqld=/usr/bin/mysqld_safe | |
| mysqladmin=/usr/bin/mysqladmin | |
| log=/var/log/mysql/mysqld_multi.log | |
| [mysqld] | |
| user=mysql | |
| character-set-server=utf8 | |
| long_query_time=1 |
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 7 in line 1.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "Dstat 0.7.0 CSV output" | |
| "Author:","Dag Wieers <[email protected]>",,,,"URL:","http://dag.wieers.com/home-made/dstat/" | |
| "Host:","mysql-test01.hq.ecnavi.info",,,,"User:","root" | |
| "Cmdline:","dstat -tclmdrn --output result/dstat_sysbench.csv 3",,,,"Date:","01 Jun 2014 05:42:09 JST" | |
| "system","total cpu usage",,,,,,"load avg",,,"memory usage",,,,"dsk/total",,"io/total",,"net/total", | |
| "date/time","usr","sys","idl","wai","hiq","siq","1m","5m","15m","used","buff","cach","free","read","writ","read","writ","recv","send" | |
| 01-06 05:42:09,1.817,0.557,97.419,0.184,0.004,0.019,2.090,2.030,2.010,2887806976.0,202784768.0,12348837888.0,16097980416.0,198036.477,4464182.055,15.400,289.822,0.0,0.0 | |
| 01-06 05:42:12,21.235,12.015,61.452,4.631,0.292,0.375,2.090,2.030,2.010,2528866304.0,1417216.0,24043520.0,28983083008.0,149090304.0,45397.333,9045.0,7.0,546.0,788.667 | |
| 01-06 05:42:15,57.952,15.233,2.770,22.157,0.881,1.007,3.360,2.290,2.090,2528804864.0,1466368.0,24047616.0,28983091200.0,402731008.0,64170.667,24578.333,8.333,238.667,491.333 |
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 7 in line 1.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "Dstat 0.7.0 CSV output" | |
| "Author:","Dag Wieers <[email protected]>",,,,"URL:","http://dag.wieers.com/home-made/dstat/" | |
| "Host:","mysql-test01.hq.ecnavi.info",,,,"User:","root" | |
| "Cmdline:","dstat -tclmdrn --output result/dstat_sysbench.csv 3",,,,"Date:","01 Jun 2014 07:10:51 JST" | |
| "system","total cpu usage",,,,,,"load avg",,,"memory usage",,,,"dsk/total",,"io/total",,"net/total", | |
| "date/time","usr","sys","idl","wai","hiq","siq","1m","5m","15m","used","buff","cach","free","read","writ","read","writ","recv","send" | |
| 01-06 07:10:51,1.783,0.552,97.424,0.218,0.004,0.019,1.920,2.0,2.0,4254179328.0,1740800.0,18673664.0,27262816256.0,307614.938,4346259.893,21.981,281.470,0.0,0.0 | |
| 01-06 07:10:54,54.904,16.513,18.022,9.179,0.712,0.671,3.050,2.230,2.070,5205237760.0,2875392.0,25862144.0,26303434752.0,316738218.667,32426.667,19246.333,6.667,336.667,4300.0 | |
| 01-06 07:10:57,64.304,18.205,1.720,14.346,0.713,0.713,3.050,2.230,2.070,6245322752.0,2908160.0,25858048.0,25263321088.0,344883200.0,45056.0,21054.0,4.0,290.0,4216.667 |
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 7 in line 1.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "Dstat 0.7.0 CSV output" | |
| "Author:","Dag Wieers <[email protected]>",,,,"URL:","http://dag.wieers.com/home-made/dstat/" | |
| "Host:","mysql-test01.hq.ecnavi.info",,,,"User:","root" | |
| "Cmdline:","dstat -tclmdrn --output result/dstat_sysbench.csv 3",,,,"Date:","01 Jun 2014 21:23:31 JST" | |
| "system","total cpu usage",,,,,,"load avg",,,"memory usage",,,,"dsk/total",,"io/total",,"net/total", | |
| "date/time","usr","sys","idl","wai","hiq","siq","1m","5m","15m","used","buff","cach","free","read","writ","read","writ","recv","send" | |
| 01-06 21:23:31,1.431,0.480,97.839,0.232,0.003,0.015,1.850,1.910,2.980,4276502528.0,1417216.0,608673792.0,26650816512.0,387455.559,3407668.729,25.536,220.067,0.0,0.0 | |
| 01-06 21:23:34,47.029,14.226,23.096,14.393,0.544,0.711,2.740,2.100,3.040,5044092928.0,3162112.0,25317376.0,26464837632.0,261320704.0,30037.333,15849.0,7.333,380.0,799.333 | |
| 01-06 21:23:37,69.153,19.866,1.593,7.795,0.796,0.796,2.740,2.100,3.040,6165258240.0,3346432.0,26124288.0,25342681088.0,375156736.0,25941.333,22900.667,5.0,978.0,936.0 |
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 7 in line 1.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "Dstat 0.7.0 CSV output" | |
| "Author:","Dag Wieers <[email protected]>",,,,"URL:","http://dag.wieers.com/home-made/dstat/" | |
| "Host:","mysql-test01.hq.ecnavi.info",,,,"User:","root" | |
| "Cmdline:","dstat -tclmdrn --output result/dstat_sysbench.csv 3",,,,"Date:","01 Jun 2014 21:32:39 JST" | |
| "system","total cpu usage",,,,,,"load avg",,,"memory usage",,,,"dsk/total",,"io/total",,"net/total", | |
| "date/time","usr","sys","idl","wai","hiq","siq","1m","5m","15m","used","buff","cach","free","read","writ","read","writ","recv","send" | |
| 01-06 21:32:39,1.438,0.482,97.809,0.253,0.003,0.015,2.110,5.040,5.080,15639875584.0,2957312.0,24035328.0,15870541824.0,434943.708,3399727.415,28.423,219.556,0.0,0.0 | |
| 01-06 21:32:42,60.277,17.953,9.983,9.941,0.671,1.174,2.110,5.040,5.080,16463581184.0,33243136.0,30912512.0,15009673216.0,270903978.667,25427968.0,16781.0,4485.0,680.667,1038.667 | |
| 01-06 21:32:45,68.889,20.713,1.887,6.457,0.797,1.258,3.380,5.250,5.150,17397170176.0,71507968.0,39022592.0,14029709312.0,308944896.0,32279210.667,19147.667,5671.667,748.3 |
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 7 in line 1.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "Dstat 0.7.0 CSV output" | |
| "Author:","Dag Wieers <[email protected]>",,,,"URL:","http://dag.wieers.com/home-made/dstat/" | |
| "Host:","mysql-test01.hq.ecnavi.info",,,,"User:","root" | |
| "Cmdline:","dstat -tclmdrn --output result/dstat_sysbench.csv 3",,,,"Date:","01 Jun 2014 21:46:05 JST" | |
| "system","total cpu usage",,,,,,"load avg",,,"memory usage",,,,"dsk/total",,"io/total",,"net/total", | |
| "date/time","usr","sys","idl","wai","hiq","siq","1m","5m","15m","used","buff","cach","free","read","writ","read","writ","recv","send" | |
| 01-06 21:46:05,1.447,0.485,97.766,0.283,0.003,0.016,1.910,3.500,5.200,4435611648.0,1564672.0,697929728.0,26402304000.0,491903.746,3429070.843,31.376,220.633,0.0,0.0 | |
| 01-06 21:46:08,46.205,16.722,22.686,12.886,0.542,0.959,1.910,3.500,5.200,5218349056.0,24522752.0,31113216.0,26263425024.0,267513856.0,19592533.333,16444.333,3278.333,667.333,3196.0 | |
| 01-06 21:46:11,56.355,17.298,1.936,22.685,0.715,1.010,2.880,3.670,5.250,6063812608.0,48705536.0,36384768.0,25388507136.0,281077077.333,23334912.0,17360.333,3647.667,62 |