Skip to content

Instantly share code, notes, and snippets.

@SpringMT

SpringMT/gist:3999564

Created November 2, 2012 08:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save SpringMT/3999564 to your computer and use it in GitHub Desktop.
Save SpringMT/3999564 to your computer and use it in GitHub Desktop.
Download ZIP
duplicate
Raw
gistfile1.txt
(root@localhost:mysql.sock) [bench_work] 17:30 (5.5.19-log)> insert into test select * from test;
Query OK, 20000 rows affected (0.58 sec)
Records: 20000 Duplicates: 0 Warnings: 0
(root@localhost:mysql.sock) [bench_work] 17:30 (5.5.19-log)> insert into test select * from test;
Query OK, 40000 rows affected (0.94 sec)
Records: 40000 Duplicates: 0 Warnings: 0
(root@localhost:mysql.sock) [bench_work] 17:30 (5.5.19-log)> insert into test select * from test;
Query OK, 80000 rows affected (2.14 sec)
Records: 80000 Duplicates: 0 Warnings: 0
(root@localhost:mysql.sock) [bench_work] 17:30 (5.5.19-log)> insert into test select * from test;
Query OK, 160000 rows affected (3.99 sec)
Records: 160000 Duplicates: 0 Warnings: 0
(root@localhost:mysql.sock) [bench_work] 17:30 (5.5.19-log)> insert into test select * from test;
Query OK, 320000 rows affected (11.40 sec)
Records: 320000 Duplicates: 0 Warnings: 0
(root@localhost:mysql.sock) [bench_work] 17:31 (5.5.19-log)> insert into test select * from test;
Query OK, 640000 rows affected (25.66 sec)
Records: 640000 Duplicates: 0 Warnings: 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment