…plugin… As part of the standard MySQL 5.6 GA distribution, there is a memcached plugin included in the base plugin directory (/usr/lib64/mysql/plugin…57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression‘ => true, ), ); $cache = Zend_Cache::factory(‘Core’, ‘Libmemcached’, $…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…of TokuDB: it has more than 4x data compression on this dataset. We can easily fill TokuDB…in_group = 2 innodb_log_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write…myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and …fileblogpercona.commanual pluginblogpercona.commanual plugin_dirblogpercona.commanual plugin_loadblogpercona.commanual portblogpercona….skip_thread_priorityblogpercona.commanual slave_compressed_protocolblogpercona.commanual slave_exec_modeblogpercona…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… the TEXT field was compressed which we felt indicated there would be a benefit derived from table compression. With the original InnoDB… plugin 1.1 or MySQL 5.5) you can now leverage table compression by specifying ROW_FORMAT=COMPRESSED. In our case we only wanted MySQL… InnoDB system tablespace cannot be compressed, see this page for further details on how to enable compression for a table. To utilize…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
… is Innodb Plugin which has significant architectural changes such as new storage format, compression and fast index build. Innodb plugin 1.0.3… instead we get MySQL 5.4 release with yet another set of Innodb changes. Why not to include plugin in MySQL 5.4…. Now I’m confused – if Innodb Plugin is not taking place of default Innodb in MySQL 5.4 will this ever going…
Post: Interested to learn about New Innodb Plugin Performance ?
April 15, 2008 By 2 Comments
As you probably have already heard Innodb Announced new Plugin version for MySQL 5.1 So now you can see Heikki and… less than 24 hours) as well as performance improvements to compression and fast index build functionality. As it is now publicly… Scalability Limits. I will not go a lot into this plugin performance because I did not know when it would be…
Post: xtrabackup-1.1
March 24, 2010 By 5 Comments
…: XtraBackup is built on a base of MySQL 5.1.44 with InnoDB plugin 1.0.6 Added –host option tar4ibd can… method for stream, even tar is specified the binary supports compressed tables and Baraccuda format Fixed bugs: Bug #529874: innobackupex cannot… #498660: xtrabackup not handling barracuda compressed table format Bug #498660: innobackupex doesn’t pass –defaults-files to mysql child proc Bug #510960…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… complete, seqno: 105 120619 13:21:17 [Note] Plugin ‘FEDERATED’ is disabled. 120619 13:21:17 … atomic builtins 120619 13:21:17 InnoDB: Compressed tables use zlib 1.2.3 120619 …mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
…UPDATE statement containing BLOB values for a compressed table. This regression was introduced in … Bug fixed #1105709 (Laurynas Biveinis). INFORMATION_SCHEMA plugin name innodb_changed_pages serves also …command line option innodb_changed_pages_limit. MySQL option handling would then shadow the …
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
… some compiler warnings. (Stewart Smith) Ported XtraBackup to MySQL 5.1.55, MySQL 5.5.9, Percona Server 5.1.55-12… Percona Server 5.5, rather than MySQL 5.5. Support for building against InnoDB plugin in MySQL 5.1 has been removed. (Alexey… #688417 – It’s now possible to do incremental backups for compressed InnoDB tables. Bug #701767 – The script innobackupex-1.5.1…
