… read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up… in a high-performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL Proxy…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…difference for the database and application performance. Over time msl patch grew with new features to…(1/log_slow_rate_limit) session. With high traffic coming to your database, the …patch for MySQL 5.0.45 msl patch for MySQL 5.0.51a msl patch for MySQL 5.0.54a msl patch for MySQL 5.0.56 msl patch…
Page: Consulting for MySQL
July 31, 2006 By
…MySQL Performance Optimization and Scaling Consulting – Hardware and OS configuration, MySQL Server Configuration, Schema, Queries, Application Architecture, Caching etc. MySQL High… Custom features and patches for MySQL We can help with developing custom features and extensions for MySQL, help …
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… more in MySQL 5.0 Baron has spotted it by incident when we were verifying some of examples for High Performance MySQL book. In the bug Heikki explains the code was probably removed in MySQL 5.0 during XA…. Interesting enough similar functionality is implemented in Mark Callaghan’s patches if you use rpl_transaction_enabled=1 Note even though…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… web. Since that time I matured and so did MySQL ecosystem. MySQL is powering a lot more demanding and business critical applications… MySQL or Percona Server 5.1 than 5.5 Facebook also sticks with MySQL 5.1 even though their highly patched and improved version. MySQL… when you see old MySQL versions are used is typically when application is not overly demanding so performance improvements in recent releases…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… and use them same as single MySQL server with improved performance and high availability. Of course there is MySQL Cluster but it does not get where quite yet having very particular performance properties… guys inside who can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise market and develop enterprise…
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
… new high-performance transactional storage engine Maatkit, which is a toolkit that provides advanced functionality for MySQL. We have a team of dedicated MySQL… contribute your patches back to MySQL?” We do contribute our patches. They are GPL-licensed, which is both generous and fair, and MySQL is…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…. If you choose this number too high the compression ratio will not be … which will start offering more performance benefits in MySQL 5.1 It also should …patches Mark Callaghan from Google released so many MySQL patches so we can call patched version GoogleSQL. Among them there are number of patches…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…isolate some functionalities from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-…their usage is very high temporarily block users having huge spike in MySQL usage Personally …currently fall under Other_commands a few MySQL performance counters broken down by users (full joins,…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… favorite MySQL configurations for high availability is master-master replication, which is just …write workload. Since we’re running Percona’s patched server, we can actually measure what’s …workload! The insert buffer can also cause terrible performance. There are some subtleties about exactly what’…
