Percona's MySQL & InnoDB performance and scalability blog
…look at query performance. In the event that a new release of 5.6 appears…that I used the community editions of MySQL 5.5.30 and MySQL 5.6.10 with no tuning …MySQL apparently has no problem with either of the following statements: mysql> insert into dir_test_innodb3 (fts_doc_id, full_name) values (1…
…of other features useful in high performance environments. Percona XtraDB includes all … and lock information, and fixed problems with lock information. documentation Improvements to…existing MySQL-5.1.30 installation http://www.percona.com/mysql/5.1.30/binary/percona-xtradb-1.0.2-1-5.1.30.x86_…
… MySQL Performance and concurrency ? The reason is – replication. In MySQL before 5.1…MySQL before 5.1. In MySQL 5.1 this as well as few other problems…0 0: len 30; hex 306338386465646233353863643936633930363962373361353736383261; asc 0c88dedb358cd96c9069b73a57682a;…(truncated); 1: len 4; hex …
Problem with kernel_mutex in MySQL 5.1 and MySQL 5.5 is known: Bug report. In fact in MySQL 5.6 there…problem is really fixed. Meantime the problem with kernel_mutex is raising, I had three customer problems related to performance…0 to 100 (default is 30): Threads Throughput NA 1 11178.34 2 27741.06 4…
…performance, but also stable and predictable performance. I refer you to Peter’s post, Performance…MySQL 5.5.8 we have regular dips (3 times per hour) from 24900 NOTPM to 17700 NOTPM (dips of around 30…(not available in MySQL 5.5.8). The problem with flushing…buffer_pool_instances=1, as we …
…every time it is needed. The problem with the sort buffer comes from…index: CREATE TABLE `sorttest` ( `data` char(30) DEFAULT NULL ) ENGINE=MyISAM DEFAULT …to perform 12 queries like ‘select * from sorttest order by data limit 78000,1‘ with…35 UTC 2010 i686 GNU/Linux MySQL: 5.1.41-3ubuntu12.6-log P.S.:…
…for this scalability problem and it is merged into MySQL 5.0.30 “Enterprise” but … Woodcrest has best performance in this test (and in many other MySQL tests), …MySQL 4.1 actually scaled pretty well with Niagra, suffering slow regression with increased concurrency rather than quick drop. In MySQL 5…
… for comparison of overall performance All releases were compiled from sources with options: ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb and… problem, but the main goal was the comparison of overall performance of InnoDB before fix (in 5.0.27) and after fix (5.0.30/5.1…
… Group Commit in Percona Server 5.1. As background information, the problem appears when you have strict…performance significantly. And the similar with writeback cache enabled thread trx=1, No binlog trx=1, Binlog sync=0 trx=1, Binlog sync=1 1….43 32 4422.41 3662.40 3842.30 64 4389.14 3860.01 3888.56…
…version 5.1 has a feature know as “Lazy Drop Table” that alleviates the problem to…First of all before running the benchmark, 30 tables were created and populated with …MySQL. Conclusion The new DROP TABLE related fixes in MySQL >= 5.5.23 have certainly reduced the performance hit, and the performance…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.