May 25, 2012

Post: Percona welcomes Drizzle 7.1

… function HTTP JSON API (experimental) Some of the Percona InnoDB patches have been merged Since Drizzle 7.0 (which was released last year…_DICTIONARY tables, the Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to…

Post: Percona Server and XtraBackup weekly news, February 26th

… the next release, which will be based on MySQL 5.1.55. We merged a fix for InnoDB’s slow DROP TABLE… porting the innodb_sync_checkpoint_limit feature from the Facebook patches into Percona Server. Peter requested a high priority for logging queries… mailing list requested us to merge Google’s KILL IF_IDLE functionality into Percona Server, and proposed the merge on Launchpad. In XtraBackup…

Post: Profiling MySQL stored routines

…_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SELECT…’s SHOW PROFILE patch – which is included in all Community tree based Percona MySQL builds since it is part of MySQL community version ever since 5.0.37 (note – not all Percona builds are…

Post: Faster MySQL failover with SELECT mirroring

…you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is …to handle the write workload. Since we’re running Percona‘s patched server, we can actually measure what’s …-state. The buffered records are forced to be merged by the SELECTs, and a lot more of …

Post: New patches, new builds

… scalability control_io-threads.patch | InnoDB patch to control count of IO threads control_flush_and_merge_and_read.patch | InnoDB patch to control insert… with MySQL 5.1 RC, at least stable to name whole MySQL-5.1-percona release as RC. Along with previously mentioned patches, to…

Post: The performance effects of new patches

… show the effects of the new patches applied to Percona HighPerf release. As you see from …no thinking time, no keying time), it uses MySQL C API and the server side prepared …it is redundant value…) control_flush_and_merge_and_read.patch This patch makes more parameters about IO configurable. …

Post: MySQL Binaries Percona build10

… | ON | | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF | to…/A | | | innodb_io_patches.patch | Cluster of past InnoDB IO patches | 1.0 | Percona | GPL | This patch contains fixed (control_flush_and_merge_and_read, control…

Post: Percona build7 with latest patches

… for MySQL 5.0.67 build 7 which include patches we recently announced. The -percona release includes: | innodb_check_defrag.patch | Session …A | | | innodb_io_patches.patch | Cluster of past InnoDB IO patches | 1.0 | Percona | GPL | This patch contains fixed (control_flush_and_merge_and_read, …

Post: Percona Server 5.5.8 Beta Release

…This is a beta release of Percona‘s enhancements to the MySQL 5.5.8 server. Here …_contract was renamed to innodb_ibuf_active_merge. Bug fixed: #695906 (Yasufumi Kinoshita) Old variable …. Bug fixed: #693269. (Yasufumi Kinoshita) The SHOW PATCHES command was removed. (Vadim Tkachenko) The INFORMATION_…

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