… same machine if you use the BLACKHOLE storage engine) in between the actual master and the … slaves. You can also use the slave_compressed_protocol option in /etc/my.cnf if …in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
… file: -rw-rw—- 1 mysql mysql 19 Nov 12 11:31 requests_061111.ARM -rw-rw—- 1 mysql mysql 984628803 Nov 12 11:29…% better than compressed by gzip. I wish Archive storage engine would specify archiving method and compression level. Some people may like fast compression while others…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… rows used from query syntax may be hard. Query Cache Storage Engines MySQL Query Cache now stores queries in local memory, which is… storage for storage. Compression You can see it as a property of Storage Engine but let me put it separately as well. I believe Query Storage would benefit a lot from fast compression, such…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical order can be applied to most storage engines, it certainly can…, clustered by (user_id,message_id). [+] Row compression Falcon uses some nice fast row compression methods, for example using only as many…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option …engine_logsblogpercona.commanual Com_show_engine_mutexblogpercona.commanual Com_show_engine…_priorityblogpercona.commanual slave_compressed_protocolblogpercona.commanual slave_….commanual standaloneblogpercona.commanual storage_engineblogpercona.commanual symbolic_…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… improved, because the engine itself is closed source. Along with its “fractal tree indexesâ€, TokuDB also uses compression, which significantly ( Graph… storage engine. The biggest problem is that MySQL does not yet provide an interface for that. This is going to be fixed in MySQL 6.0, but I can’t yet say how it will work with mix of storage engines. – The Tokutek engine I…
Post: Countless storage engines
May 3, 2007 By 6 Comments
…count of storage engines were presented. In good old time when Oracle bought InnoDB, MySQL did one step – announced MySQL supports Plugginable Storage Architecture. In…and read-only engine designed for DataWarehouse applications with compression rate from 10:1 to 30:1 ScaleDB The engine based on …
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
…been written about the new InnoDB pluggable storage engine, which Innobase released at the MySQL conference last month. We’ve … The _CMP tables show statistics about compression; they contain a lot of useful information about compression, decompression, memory management, fragmentation etc…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… – Storage Engine developers showcase as one of keynotes. Today let me start with most popular transactional storage engine for MySQL – Innodb. Innodb Storage Engine …well have very different compression ratio. As Innodb indexes are not prefix compressed they have very good compression potential. I …
Post: Adventures in archiving
February 11, 2013 By 16 Comments
… can solve disk storage issues – but you must always consider the caveats and bugs related to a storage engine before going ahead and… testing. InnoDB’s inbuilt row compression MySQL‘s inbuilt compress() function leveraging zlib to provide compression of data. MySQL‘s Archive storage engine. Tooling The tooling phase…
