June 19, 2013

Post: MySQL and Sun - Oportunity for smaller companies ?

MySQL background of CEO of the companies mentioned. Some of these companies may also be faster to fix your MySQL issues – at Percona we do a lot of work with performance analyzes and Scaling. Proven Scaling is well known for contributing SHOW PROFILE patch

Post: Building Indexes by Sorting In Innodb (AKA Fast Index Creation)

… early 2011 adding innodb_merge_sort_block_size variable and I was thinking this small patch will be merged to MySQL 5.5 promptly…_creation=0″ which allows to disable fast index creation in Percona Server and force complete table to be rebuilt instead. Looking… table rebuild could have done fast too. Results are from Percona Server 5.5.24

Post: Estimating Replication Capacity

…”UserStats” functionality from Google patches, which is now available in Percona Server and MariaDB. …mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql….26 0 185.83 0 # Merge pas 0 0 0 0 0 …

Comment: Looking for MySQL 4.0 Support post EOL ?

Percona simply does not have such restriction. It is also question about practice not theory. In theory you could also make MySQL… need in MySQL on consulting basics, in practice I rarely see it happening during last few years. Even Google patches when there was both desire to see certain features and code already provided take years to be merged. The…

Post: Optimizing slow web pages with mk-query-digest

… you are usually interested in queries that are consuming most MySQL time and that’s how mk-query-digest groups …query_time=0 and all the eXtra benefits from Percona slow query log patch), I knew some particular pages were taking …8.01k 475.89 918.49 689.98 258.32 # Merge passes 0 0 0 0 0 0 0 0 # …

Post: Great work Innodb Team

… seems to be merged with MySQL Documentation which makes it much more usable and Innodb Plugin is shipped with MySQL 5.1 which makes it much easier to use which means wider community testing. Number of patches suggested by community such as Google and Percona were reworked and included in the plugin…