… new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make the life of DBAs much easier… one. Second try: GTIDs enabled, mixing regular replication and GTID replication This time, we will enable GTID replication on slave #1, but not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…focused only on case #1. Which is the perfect case for read-only transaction optimization in MySQL 5.6, because …32 cpu threads) All are NUMA boxes, but the second one has a higher QPI bandwidth, and the …loop, which is probably a bit closer to real life workloads. It’s still the AUTOCOMMIT mode, so …
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… scales with increasing concurrency in effect. Second, there are many cases in which …to be single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some …life with low concurrency. When it comes to benchmarks I would love to see results published starting from concurrency of 1…
Post: MySQL End Of Life (EOL) Policy
August 22, 2008 By 6 Comments
… second is further 3 years of life in “critical bug fixes only” mode with releases available for premium (Silver+) Support offerings. For MySQL… of MySQL 4.1 are followed we’ll soon see stop in MySQL community releases of MySQL 5.0 most likely before MySQL 5.1 will proven MySQL 5.0 replacement. There is no blame on MySQL – it is…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
…table drops or stalls. Percona Server since version 5.1 has a feature know as “Lazy Drop Table… that is not a realistic benchmark. In real life workload we will not be doing create/…showing the QPS over 5 second periods with the new DROP TABLE implementation (MysQL version >= 5.5.23) and DROP TABLE…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… because of the alignment to a stripe unit. In the second example however every other page spans two disks so there… bigger than stripe element; second – logs are actually written in 512 byte units (in Percona Server 5.1 and 5.5 you can customize this…. Now it may be interesting to see what are real life effects of misalignment, my benchmark results are in the second part.
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
… original query had a stable execution time of 1.09 sec, while the following one, which …”rows” value seen above. This is because the second part of the condition -note like ‘%Jaime%’- is…more about the MySQL 5.6 query optimization improvements in a practical way, with real-life examples? Do you…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… in comparison to InnoDB and MyISAM. The second goal of benchmark was a popular myth … in terms of CPU usage. In real life workload results are likely to be very …MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1…
Post: Logging Foreign Key errors
September 27, 2012 By Leave a Comment
….0.5,D=test,t=foreign_key_errors h=127.0.0.1 We are monitoring the MySQL on host 127.0.0.1… run as a daemon for 3600 seconds and will check the last error every 10 seconds. 3- Cause an error I run… problem. These tools are easy to use and make your life easier.
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… out there that can make your life easy. However, there is one such tool… not just for new connections as in MySQL. This is very helpful for measurement …it to some other value say 0.1 seconds, it will miss all queries shorter …_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film …
