… GA distribution, there is a memcached plugin included in the base plugin directory (/usr/lib64/mysql/plugin/libmemcached.so) that can be stopped and… full documentation for setting up the plugin: http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-setup.html As a…/start memcached, stop/start plugin). As expected, there is a slowdown for write operations when using the InnoDB version. But there is…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… suitable for InnoDB, and in it we have random inserts into SECONDARY KEYS (k), which is not so good for InnoDB. So let’s…_group = 2 innodb_log_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… version only. An Innodb Plugin is announced and will be separate from MySQL Server, providing a more scalable Innodb version with more features… Updates [MRU] while Community MySQL versions updated every quarter or so. MySQL 5.0.51a is GA and 5.1.24… the conference and announced Percona XtraDB as improved and extended Innodb Plugin version, MySQL 5.1 is FA with 5.1.34…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the… from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov). dialog.so used by the PAM Authentication Plugin couldn’t be loaded with Perl and Python clients when plugin-dir option was…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1\” > /var… in order to use innodb_fake_changes. Thread pool Percona Playback added a connection pool option via –dispatcher-plugin-thread-pool that…. We restored a production database backup to our test database so that our test database was consistent before applying the captured…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the… from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov). dialog.so used by the PAM Authentication Plugin couldn’t be loaded with Perl and Python clients when plugin-dir option was…
Comment: Implications of Metadata Locking Changes in MySQL 5.5
March 27, 2013 By 9 Comments
…, which is what is preventing the ALTER from going through. So you are facing a different scenario in that you have…. If you can enable the InnoDB plugin on your 5.1 installation instead of using the built-in InnoDB, then you can further… ALTER in your test case is waiting on InnoDB row locks by setting innodb_lock_wait_timeout to 1 and then issuing…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…”, which is based on the InnoDB storage engine. It’s 100% backwards-compatible with standard InnoDB, so you can use it as a…, which is forked from InnoDB-plugin-1.0.2. Percona XtraDB is released under GPL v2, as is InnoDB-plugin base source code. Percona… version number of standard InnoDB, so you can always learn what your engine can do. documentation Improvements to SHOW INNODB STATUS. We’ve…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… try it out. Q14: Are there any plans to fix Innodb so it unlocks (or never locks) the rows if they were…€™ve migrated to using INNODB so that it operates 100% out of memory. This way every write is serial so that we can… additional throughput? HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 15 Comments
…”. It was impressed as I personally always wanted it for InnoDB, but we had it in plans at the bottom of… for now is support of InnoDB-plugin, which as we know performs much better than standard InnoDB ®. So what is so interesting about Galera. Couple… InnoDB currently it is set of patches, and I see it is quite possible to make the same for Postgres. So MySQL…
