… has been developed by Tokutek. Though the “1 billion row insert challenge” for which this … in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5…. While secondary indexes cause read performance to improve, but they have an impact on the write…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5 w/ mrr_buffer_size=4M Created_tmp_disk_tables 1 1 1 1 1… used, there is no difference in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area of improvement in the optimizer, as it…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… available in both MySQL 5.6 and MariaDB 5.5. You can read more about BKA in MySQL 5.6 here and BKA in MariaDB 5.5 here. However, MariaDB 5.5 has…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 numbers of…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… of these features are also available either in Percona Server or in the upcoming MySQL 5.6 in the same or slightly different forms, so… 5.3 is based on MySQL 5.1, but MariaDB 5.5 will be based on MySQL 5.5, so it will inherit a lot of the great improvements Oracle has made to the MySQL 5.5…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… a lot larger problems with MySQL 5.5 with addition of user variables, …| sum(data_length+index_length) | +——————————-+ | 126984 | +——————————-+ 1 row in set (0.00 sec) You… future releases of MySQL, MariaDB or Drizzle bring improvements in this space allowing …
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
…questions: 1. Will the Percona Toolkit version just released work for regular community MySQL 5.5.23 or does it only work (or work better) with a Percona type version of MySQL – ie one of Percona’s “improved…here? It seems as if MySQL 5.5 has been getting much slower (in terms of qps) …
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
…with slow query output. The tables are in InnoDB with MySQL 5 and RHEL 5. Its a 32 bit machine with 12…buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 A count command … by field1; 14 rows in set (15 min 54.29 sec) Please help to improve performance and suggest if any…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… second in sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in …1.26, … Or if we represent graphically (point means even arrival): As you see interval is far from being strict 0.5…three nodes, will it help to improve the response time ? – Do we need…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
March 7, 2012 By 21 Comments
…MySQL RDS, InnoDB engine. Our requirement is to insert data in…in 8 chunks then it took 10min. Question : Can 14min time be reduce further? Is there anyway I can improve…
