… XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they… use writesets to replicate cluster events to the other nodes, in essence these are RBR events, plus a few additional structures…’d like to hear your thoughts and experience on the comments 
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Comment: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
I got it to fail at 59 columns. The maximum column comment length was increased to 1023 in MySQL 5.5, so I modified your script to create comments of that length instead of 255 as you have.
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
… separate table with TEXT column, which stores data, like this comment. In this case it might be helpful to compress this table… their own InnoDB compression, which is available in MySQL 5.6. So we may test MySQL 5.6 more to see what kind…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… in terms of throughput and in terms of latency. I have a Samsung 830 in the laptop I’m using to write this comment… Micron PCIe card, not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the… even heard of the STEC caching solution prior to your comment. Maybe another Perconian will have some insight here.
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… comments here don’t get stuck like that. Wonder if “too many URLs” is the spam signal but URLs for bugs.mysql…/2013/02/mysql-56-is-much-faster-on-io-bound.html) but that patch can’t be used in 5.6. In 5… this and I hope most of them will be fixed in 5.6.12. They should make a difference. I think…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 20, 2013 By 13 Comments
… moving from MySQL to/from Oracle/MSSql/etc is even more painful.) And much of the code was in assembly language for…. The verdicts helped cut back on vendor/service lock-ins (Vadim’s first comments), and made for a more level playing field… with ‘traditional’ business models. Another history note: 100 years ago (in the US), there were 100 auto manufacturers. By the 1970s…
Comment: Is Synchronous Replication right for your app?
May 16, 2013 By 18 Comments
… queue, not MySQL at all. E.g. ActiveMQ, RabbitMQ, Resque, etc. All applications would send updates to the MQ in lieu of… apply them to the database. Possibly committing sets of events in a single transaction to reduce the overhead of the RTT… might address your comment, “I’m not sure how useful it is to update the same row multiple times in a single…
Comment: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… 250K qps. In the 2nd benchmark it is closer to 150K qps. What accounts for the drop? 2) The MySQL Bug #49169 was closed with the comment “lets give this issue a rest because…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
… interested in knowing whether I’m missing anything, but I believe the definition of badness in this article is fairly complete. (Post comments…, which has been available in MySQL for years. This is necessary for determining whether a group of queries completed in a cluster. One… heuristic for detecting bad queries? Let me know by posting in the comments.
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… a recurrent question made by our MySQL Support customers: How can I audit the login attempts in MySQL? Logging all the attempts or… there are not too many audit capabilities in MySQL Community so the first option to audit MySQL‘s authentication process is to get…/mysql/mysql.log general_log = 1 User correctly authenticated: 121227 8:31:49 38 Connect root@localhost on 38 Query select @@version_comment…
