…13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] …6.11-60.3 release notes. Bugs Fixed: Transaction objects are now allocated calling calloc() directly … error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked… size 440760, 799203 row lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp….label_id, cai.inventory_id All 4 tables in the query are locked!
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-statement transactions (TPS mode, see… read-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode are, by definition, read-only transactions, so the…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… using MySQL GTID. Then the question is: Is there any easy way to skip a single transaction? There is! Injecting empty transactions. Let…: Error ‘Duplicate entry ’4′ for key ‘PRIMARY” on query. Default database: ‘test’. Query: ‘insert into t VALUES(NULL,’salazar’)’ Retrieved_Gtid_Set…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… of failing or returning immediately if there is a transaction that executed a query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…-only transactions, while a great optimization in itself, applies only to the following kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created… does PK lookup SELECT queries wrapped into regular (i.e. not marked as read-only) transactions. In this case MySQL 5.6 scalability…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… of failing or returning immediately if there is a transaction that executed a query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… ’0′, PRIMARY KEY (`hid`,`mid`,`id`) ) and transactions are: $HID=rand(0,10000) // distributed by uniform… = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len =…_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…the exact same pattern when looking at transaction latency; the baseline numbers are roughly…requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp… 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… being confused, thinking MySQL Query Cache is the same as Oracle Query Cache – meaning cache where execution plans are cached. MySQL Query Cache is not… using statements outside of transaction you have best chance for them to be cached. Query must be deterministic – Query might provide same result…
