June 19, 2013

Post: ZFS on Linux and MySQL

… work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock” and the flush operation will take some time to complete. Compression ZFS can compress data on the… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will…

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

… replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT… the lower-level slaves. You can also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a… get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple…

Comment: Benchmarking Percona Server TokuDB vs InnoDB

… was able to get good results with InnoDB compression. Usually it was worse than without compression. So far I can say that I… only one specific use case useful with InnoDB compression: i.e. you have a separate table with TEXT column, which stores data, like… compress this table to save some storage and do not have a big performance hit. That’s why Facebook has their own InnoDB compression

Post: Benchmarking Percona Server TokuDB vs InnoDB

… 4x data compression on this dataset. We can easily fill TokuDB tables with 1bln of rows on this SSD, and projected InnoDB performance… SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush…

Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

… => ’192.168.57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression‘ => true, ), ); $cache = Zend_Cache::factory(‘Core’, ‘Libmemcached’, $frontendOpts, $memcacheOpts); $…max per/cmd 0.0951 ms range per/cmd InnoDB MySQL Select (same table): Fetching [1,000,000] items: 441573 ms …

Comment: Benchmarking Percona Server TokuDB vs InnoDB

Then why comparing ompressed tables and uncompressed table on size ? That’s clearly not relevant ! Could you redo the same test with innodb compression ? Thanks

Comment: Benchmarking Percona Server TokuDB vs InnoDB

In your my.cnf conf I don’t see barracuda file format and did you create your table using row_format = compressed with InnoDB which enables tablespace compression ?

Comment: Benchmarking Percona Server TokuDB vs InnoDB

… on uncompressed table scale as expected. Mark did you cover this case in your patches ? Add my vote on compression as we are facing more and more big data challenges where innoDB and TokuDB will have to…

Post: Testing InnoDB "Barracuda" format with compression

… from index compression. For test I use dump created with mysqldump, final size 30286M. To create InnoDB compression table I use ENGINE=InnoDB KEY_BLOCK_SIZE=8 and to test fast index creation I create table only with primary…

Post: InnoDB compression woes

… –oltp-table-size=25000000 run Results: Load time for regular tables: 19693 sec, for compressed tables: 38278 sec. Compressed tables are create as: ROW_FORMAT=COMPRESSED KEY…. With compressed tables CPU utilization is 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression tables we…