… on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed … queries (e.g. temp tables)? For performance, it’s hard to make …primary key solution for random selection only work when the IDs for movies are… sequence after making certain insert/update/delete operations. If you have…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
…MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside transaction. 2. Updates…SELECT – It is not supported to perform…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
…for MySQL. Facebook mentions they have over 1,800 MySQL Servers. MySQL Enterprise provides Monthly Rapid Updates [MRU] while Community MySQL versions updated every quarter or so. MySQL…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…For RPM/deb packages, this library will be available for download from our repositories. Benchmark showing the impact of memory allocators on MySQL performance… In case CREATE TABLE AS SELECT statement was running in…UPDATE[18-04-2013]: There was a RPM packaging regression introduced with the fix for…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries in the…the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but …=off –oltp-index-updates=0 –oltp-non-index-updates=0 run POINT_SELECT + UPDATE QPS test sysbench –num…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…produce updates in-place (I will use INSERT .. ON DUPLICATE KEY UPDATE statements for that…for fast inserts, but it is suitable for range selects by `id`. However it will interesting how both InnoDB and TokuDB performs…_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… scanning the entire last two partitions, performance is not bad. (The last 2…would argue that single-row queries (SELECT, INSERT, DELETE, UPDATE) are similar in speed between…for PARTITIONing. I go into more details (and code) here: http://mysql.rjweb.org/doc.php/partitionmaint The third use case for…
Post: SELECT LOCK IN SHARE MODE and FOR UPDATE
August 6, 2006 By 51 Comments
… sec) mysql> select * from tst for update; +—+ | i | +—+ | 1 | +—+ 1 row in set (0.00 sec) #Standard SELECT does not see rows while SELECT for UPDATE and LOCK… by like because locks are taken on Innodb level before MySQL performs like matching, and row is not unlocked if it does…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…performance at 1 thread to the peak performance we see the number is 2.3 for Percona Server 5.1 and around 6 for…for_mysql,ha_innobase::general_fetch,handler::read _multi_range_next,QUICK_RANGE_SELECT::get_next,rr_quick,sub_select,do_select,JOIN::exec,mysql_select,handle_select…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
…perform non locking reads, meaning unless you use some modifiers such as LOCK IN SHARE MODE or FOR UPDATE, SELECT… for MySQL Performance and concurrency ? The reason is – replication. In MySQL before…SELECT would give. This by the way applies to SELECT .. LOCK IN SHARE MODE and SELECT … FOR UPDATE…
