…INSERT INTO sbtest (hid, mid, id, k) VALUES ($HID, $MID, $ID, $K); INSERT INTO…benchmark, the sysbench code is on Launchpad lp:~vadim-tk/sysbench/insert-roll-2, command line to run: sysbench –test=insert…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema…large stream of queries. Benchmarks We benchmarked with slow query logs captured…insert statements that have duplicate key errors may be faster than an actual database write. The slow logs were split into…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…time; the remaining 3600 seconds were averaged into 10-second intervals. All tests were …be declared the clear winner. Base MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench …= 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size =…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… number of simple benchmarks. Let’s start with a table containing 4 million rows and one secondary key: mysql> CREATE TABLE t… affected (0.00 sec) mysql> INSERT INTO t(c) VALUES (RAND()); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t(c) SELECT RAND() FROM t; Query OK, 1 row affected (0.00 sec) Records: 1 Duplicates: 0 Warnings: 0 . . . mysql> INSERT INTO…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
….00 sec) mysql> SELECT * FROM test_table; — 1 Ticket Used +——+ | id | +——+ | 1 | +——+ 1 row in set (0.00 sec) mysql> INSERT INTO test_table… sec) mysql> INSERT INTO parent (id) VALUES (1),(2),(3),(4); — 3 Tickets Used Query OK, 4 rows affected (0.03 sec) mysql> INSERT INTO child…
Post: Sharing an auto_increment value across multiple MySQL tables
October 4, 2010 By 9 Comments
… to insert into, and grab the insert_id: CREATE TABLE option1 (id int not null primary key auto_increment) engine=innodb; # each insert does one operations to get the value: INSERT INTO option1 VALUES (NULL); # $connection->insert_id(); Option #2: Use a…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
…` mysql test -e “insert into sorttest value (‘$UUID’);” let “COUNT=COUNT+1″ done I know, I could have used the uuid() function of MySQL. For the benchmark, I used an old PII 350 MHz computer, I think for such CPU bound benchmarks, an old…
Post: How expensive is a WHERE clause in MySQL?
October 31, 2008 By 17 Comments
… NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; insert into t(a) values(current_date); insert into t select * from t; I repeated the last… how long a table scan with no WHERE clause takes: mysql> select sql_no_cache count(*) from t; +———-+ | count(*) | +———-+ | 8388608 | +———-+ 1…
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
…. mysql> create table t1 (a int not null auto_increment, primary key(a)); Query OK, 0 rows affected (0.11 sec) mysql> insert into t1 values (),(),(),(),(); Query OK, 5 rows affected (0.06 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql> select * from…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…Session1: mysql> begin; Sessino2: mysql> begin; Session1: mysql> insert into test2 values (4,’FEDERATED’); Session2: select * from test2; +—-+——–+ | id | names | +—-+——–+ | 1 | Mysql | |… transaction So we can’t run SysBench benchmark with current version. Hopefully next beta will…
