…the new features over the coming weeks. Major features include: Multi sourced replication XtraBackup included IPv6 data type ZeroMQ plugin Log output to syslog is enabled…the Percona InnoDB…The Ubuntu packages are available from the Drizzle PPA. Instructions on how to install from the PPA are in the…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…features are added to the application new queries pop up that need to…the ability to enable logging atomically, not just for new connections as in MySQL…InnoDB_IO_r_bytes: 16121856 InnoDB_IO_r_wait: 0.001414 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
… on how to recover a single tablespace using stock MySQL server. First, you must meet certain prerequisites to be able to restore a ibd tablespace: The…. innodb_import_table_from_xtrabackup=1 should be enabled for such advanced import process to work. You can read more about this feature in Percona…
Post: What's up with HandlerSocket?
March 28, 2011 By 42 Comments
…MySQL 5.1 are not using the InnoDB plugin because it is not enabled by default! If people cannot be bothered to add a couple of lines to my.cnf to enable the InnoDB…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…Enable the view to use it The SQL_API call flexviews.enable() is used to actually build the contents of the view, making it available for querying: mysql…how to create a complete refresh view which reads from an incrementally refreshable one. This allows the use of SQL features not available with the…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…that the execution is not serializable. PZ: Cool. This is one of little known new features in MySQL 5.1 Q15: How frequently does Innodb …to enable tuning of the checkpointing rate? Postgres exposes this data and allows the user to tune the checkpointing values. HT: Hmm… we could tune the way InnoDB…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…the database what you want but not how to get it. Most distributed engines work with rows. They break the queries up into the…In fact, it is embarassingly parallel. Because Shard-Query works on sets, and features pluggable partition mapping, it allows partitioning resources to…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…to disable Query Cache than to enable it. It can cause contention problems as well as stalls and due to…to the core of original implementation which appeared in MySQL 4.0 Query Cache was designed to…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…to have the problem fixed soon ? Yes indeed there is patch out where already which may come in MySQL 5.2 or even MySQL…Innodb to unleash performance such as multiple purge threads or parallel log recovery features, which he however needs to test properly before really enabling it. Innodb…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…to enable…how much speed benefit did it really provide in this case. innodb_max_dirty_pages_pct=15 – Another interesting one. So the…features which are worth a bit of performance overhead. My best wishes to the Tom Daly and his team in…
