… of logging failed connection attempts has been discussed on a previous post in our blog. Starting with 5.1, the new plugin… support has been an important missing feature on the server, which has made using MySQL in PCI or SOX compliant environments, to name just two, artificially complicated, as one had to rely on too…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
This blog post is part two in what is now a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10…/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based … $ mysqlindexcheck –server=user:pass@localhost test.test # Source on localhost: … connected. $ pt-duplicate-key-checker –tables test.test # …
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
Today’s blog post diving into the waters of the MySQL buffer pool is a cross-post from Groupon’s engineering blog, and…. We’ll be posting Part 2 on Thursday. I’ll be at the Percona Live MySQL Conference and Expo next week in… about MySQL buffer pools or anything else that’s on your mind! There are numerous solutions for MySQL high availability. Many rely on MySQL’s…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… breakout sessions including presentations on Oracle MySQL, Percona Server, and MariaDB during the Percona Live MySQL Conference. Percona Live MySQL Conference Keynotes Tuesday Peter… and CEO of Percona. The discussion will focus on MySQL 5.6 and how MySQL must evolve if it is to remain competitive…. And if you cannot make it this year, watch this blog following the conference and we’ll announce when and where…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…. This has no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much worse than Galera. As I illustrated in a blog… your hotspots are all updates with autocommits, you can rely on wsrep_retry_autocommit to auto-retry the transactions for you…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…. For the REPEATABLE_READ isolation level, the snapshot is created on the first SELECT for each transaction. For lower isolation levels… scan in MySQL 5.5 basically kills throughput on high concurrency. The picture changes dramatically when the read-only optimization in MySQL 5… currently in the alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release…
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… base and community around your product. Growing public knowledge: discussions on blogs, forums, social networks. Well, of course, some or all of… and Kickfire, two companies that based their products on a closed-source version of MySQL… and you know their fate – sold for… grains of truth in the article “Dead database walking: MySQL‘s creator on why the future belongs to MariaDB.” To quote that…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… MySQL performance at low concurrency is important for you. I decided to write about this topic as a number of recent blog posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6… performance at just high-concurrency values? This might mislead you on how your production will be impacted. Think about, for example…
Comment: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 27, 2013 By 1 Comment
… place to do it) What is going on with the mysql 5.5 / 5.6 changelogs on MySQL.com. Anyone else noticed how extremely…-free MySQL release… or they are taking bug fixing / development behind closed doors I believe it deserves some kind of blog post on Percona asking what’s going on, or answering it [if anyone at Percona…
