… be in an acceptable range. It opens the possibility for active master – active master setups. You can write on both masters and… is based on standard InnoDB 5.1 instead of InnoDB-plugin. Standard InnoDB is seriously behind InnoDB-plugin in terms of features and performance. Update (6-Jun-2011): It was my misunderstanding: Galera does work with InnoDB-plugin…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… performance. Over time msl patch grew with new features to let people learn more details of query … hostname-slow.log file. Must be enabled to activate other slow log options. This is the most…InnoDB extensions msl patch for MySQL 5.0.51a with InnoDB extensions msl patch for MySQL 5.0.54a with InnoDB…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
… be actively maintained now. And hey this is exactly one if the reasons behind Drizzle project. Lower usage density means features are… is why I guess all new Innodb Development is going with Innodb Plugin which is separate from Innodb included default MySQL. Why is… how it all affects bugs an not features ? Well if you want to use latest Innodb you will need to use plugin…
Page: Consulting for MySQL
July 31, 2006 By
… your application needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load…. Custom features and patches for MySQL We can help with developing custom features and … help with deadlocks, understanding how Innodb locking works or having Innodb performance issues ? We can help…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
… parameters in the XtraDB io patches: innodb_ibuf_max_size — Restrict innodb-insert-buffer size innodb_ibuf_active_contract — Enabling it makes… InnoDB tables (unless you used innodb_extra_undoslots) and we are going to keep compatibility in further releases. We are open for features…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… used mk-query-digest (with some new features) to watch the traffic on the active master and replay SELECT queries against the… the active master’s buffer pool with the following query: select table_schema, table_name, page_type, count(*) from information_schema.innodb…-digest to watch the traffic on the active master: mk-query-digest –processlist h=active \ –filter ‘$event->{arg} =~ m/^SELECT/i’ –execute…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
…changes we’ve made from previous Percona Server releases: New Features InnoDB adaptive hash function searches can now be spread across …renamed to innodb_ibuf_merge_rate. Bug fixed: #695906 (Yasufumi Kinoshita) Old variable innodb_ibuf_active_contract was renamed to innodb_ibuf_active_merge. Bug…
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
… we maintain the feature in subsequent minor versions of the server free of charge. Features that we don…parts. When it comes to Sun/MySQL, we actively and openly talk to them about it, …modification to the MySQL server, XtraDB, Maatkit, our InnoDB data recovery tools, MMM, innotop, or even projects…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
… development (nothing stops you from starting to actively break old code though). Indeed there are …since MySQL 4.0. This even applies to Innodb tables which were already on par with … replication, advanced Monitoring and scaling features some users need other features than MySQL adding in newer MySQL…
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 45 Comments
… NULL, PRIMARY KEY (`id`), KEY `uu` (`uu`), ) ENGINE=InnoDB The access pattern to this table is to…10 times as couple of partitions which were actively used could fit in buffer pool completely so…trying to archive. Partitioning is not some magic feature which just makes everything a lot faster. I…
