… tool iiBench which has been developed by Tokutek. Though the “1 billion row insert challenge” for which this tool was originally… to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I…_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx…
Comment: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
March 11, 2012 By 7 Comments
… 5.1.22 change autoincrement mod http://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.html I have the same problem. 1… is traditional lock mode == > funcionality of auto_increment like before 5.1.22 # =1 is default value – consecutive lock mode # =2 is interleaved lock…’),(‘Oto’),(‘Jan’),(‘Jan’),(‘Jan’),(‘Romco’); select * from tab order by 1; 1 Peter 2 Oto 3 Jan 4 Romco ===> not 7 Romco…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… MariaDB 5.5. You can read more about these variables here. The query used is: select l_orderkey, sum(l_extendedprice * (1 – l… Handler_mrr_rowid_refills N/A N/A N/A 22 0 0 Handler_read_key 1829910 4440511 4372096 1801917 1790641…_read 4127318 6718351 6611675 6707882 5479445 5527245 Select_scan 1 1 1 1 1 1 Sort_scan 1 1 1 1 1 1 The first obvious improvement is shown by the high…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… the export files SET GLOBAL innodb_import_table_from_xtrabackup = 1; ALTER TABLE data IMPORT TABLESPACE; After those being done i… %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23… log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information.
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
…Percona Live New York, which will be held October 1-2, 2012 at the Sentry Conference Center in …signed the contract for next year’s event: April 22-25, 2013. The dates are confirmed and final, … new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better …
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
March 7, 2012 By 21 Comments
… select my_id+1,.,.,.,.,.,.,. from SAME_TABLE where myid = input_my_id (myid is 1st column of composite (5 columns) primary key). Reading and Writing in same table. For 22,518,912 rows it is…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… dropped OS caches by `echo 1 > /proc/sys/vm/drop_caches` and restarting mysqld) 5.1 – time 1 hour 14 min 36.90 sec 6.0 – time 1 hour 6 min 2.21…-sz avgqu-sz await svctm %util sda 16.22 1.23 534.29 1.85 132547.02 24.64 66273.51 12.32…
Post: Percona Server 5.5.17-22.1 released
November 18, 2011 By Leave a Comment
… Server 5.5.17-22.1 on November 19th, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.17, including all the bug fixes in it, Percona Server 5.5.17-22.1 is now the current stable release in the 5.5… can be found in the 5.5.17-22.1 milestone at Launchpad or in the Release Notes for 5.5.17-22.1 in the documentation. Bug…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0… close and MySQL 6.0 is even significantly slower than 5.1 for number of queries. Honestly I expected more from MySQL… can see on 100G data set MySQL 5.1 could only complete 10 out of 22 queries within 3hours run time allowed for…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
Percona is glad to announce the release of Percona Server 5.5.16-22.0 on October 14, 2011 (Downloads are available here… 5.5.16, including all the bug fixes in it, Percona Server 5.5.16-22.0 is now the current stable release in the 5.5… a new boolean option, –innodb-blocking-buffer-pool-restore (in 5.1 it is –innodb-blocking-lru-restore), which is OFF by…
