@@ -31,9 +31,14 @@ version: 5.6.39
3131+-------------------------------------+----------------+
3232```
3333
34+ Clean page cache before each benchmark.
35+ ```
36+ sync && sudo purge
37+ ```
38+
3439## Test case
3540
36- 1 ) innodb-java-reader-cli
41+ innodb-java-reader-cli
3742```
3843java -jar -Dinnodb.java.reader.enable.trim.char=true -server -Xms2g -Xmx2G \
3944 -XX:+UseConcMarkSweepGC -XX:+UseParNewGC \
@@ -43,29 +48,36 @@ java -jar -Dinnodb.java.reader.enable.trim.char=true -server -Xms2g -Xmx2G \
4348 -c query-all -o lineitem.dat
4449```
4550
46- 2 ) mysql -e command
51+ mysql -e command
4752```
4853mysql -N -uroot -P3306 -e "select * from tpch.lineitem" > mysql-select-result.out
4954```
5055
51- 3 ) mysqldump
56+ mysqldump
5257```
5358mysqldump -uroot tpch lineitem > mysqldump-result.out
5459```
5560
5661## TPC-H benchmark
5762
58- Test against ` LINEITEM ` table, data are generated by running ` dbgen -s < size, like 4> `
63+ Test against ` LINEITEM ` table, data are generated by running ` dbgen -s size `
5964
60- | | 1G | 2G | 4G | 8G | 16G |
61- | ------------------------ | --------- | ---------- | ---------- | ---------- | ---- |
62- | line number | 6001215 | 11997996 | 23996604 | 47989007 | |
63- | lineitem.tbl file length | 759863287 | 1532344491 | 3085874988 | 6210377564 | |
64- | lineitem.ibd file length | 943718400 | 1879048192 | 3745513472 | 7486832640 | |
6565
66+ | | 1G | 2G | 4G | 8G | 16G |
67+ | ----------------------- | --------- | ---------- | ---------- | ---------- | ----------- |
68+ | line number | 6001215 | 11997996 | 23996604 | 47989007 | 95988640 |
69+ | lineite.tbl file length | 759863287 | 1532344491 | 3085874988 | 6210377564 | 12509214305 |
70+ | lineite.ibd file length | 943718400 | 1879048192 | 3745513472 | 7486832640 | 14965276672 |
6671
72+ Test result in seconds.
6773
74+ | | 1G | 2G | 4G | 8G | 16G |
75+ | ------------------ | ------ | ------ | ------ | ------ | ------- |
76+ | mysql -e command | 46.743 | 98.81 | 203.86 | 593.83 | 1206.93 |
77+ | mysqldump | 13.11 | 26.511 | 53.656 | 106.87 | 215.49 |
78+ | innodb-java-reader | 57.763 | 62.79 | 116.77 | 228.81 | 481.12 |
6879
80+ ![ ] ( images/tpch_benchmark.png )
6981
7082## Realcase benchmark
7183
@@ -133,6 +145,6 @@ Max_data_length: 0
133145 Comment: t
134146```
135147
136- For commonly used column types, Innodb -java-reader is as good as mysqldump or even better. Also, it enables you to offload from mysql process.
148+ For commonly used column types, innodb -java-reader is as good as mysqldump or even better. Also, it enables you to offload from mysql process.
137149
138150![ ] ( images/benchmark.png )
0 commit comments