… is the excellent compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB compression is not RLE….cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
…default transactional storage engine in MySQL 6.0 – I did not truly understand if it will be recommended transactional storage engine or just default storage engine …new storage engines such as Nitro and InfoBright but there was nothing told about Innodb features, even ones such as page compression …
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… it works with existing MySQL data sets and queries. Another advantage is that it works with all MySQL storage engines. This set of benchmarks… should note that I did this preprocessing with the MyISAM storage engine, then I dumped the data to tab delimited flat files… loading, there was approximately 23GB of data. After loading, ICE compressed this data to about 2GB. The test virtual machine was…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 4 Comments
MyISAM storage engine has key compression which makes its indexes much smaller, allowing better fit in … if it is not packed. Compressed blocks need to be treated differently. For uncompressed index blocks MySQL can do binary search inside… for left or right half. For compressed block this is not going to work and MySQL will need to scan keyblock from…
Post: Innodb Caching (part 2)
May 10, 2011 By 7 Comments
…, though I expect results for 16K and 16K Compressed to be very similar on MySQL 5.5 As a summary: If you have very random access pattern with small rows consider using 4K pages, compression may not give you much gains from cache fit efficiency. Next I should look more about performance of different storage engines in…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… as original file system Why snapshot based MySQL backups are great ? There are number of reasons…storage engines It works with MyISAM and Innodb and BDB, It also should work with Solid, PrimeXT and Falcon storage engines…. Easy to Integrate Do you want to compress backup ? Backup it to tape, FTP or …
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
…TEXT, PRIMARY KEY (id) ) Engine=InnoDB; Now you insert some test data into it: mysql> INSERT INTO example -> …(HY000) at line 1: Got error 139 from storage engine What’s going on? Innodb gives you…the worse compression will work). Something important to note is that the result of the COMPRESS function…
Post: Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon
March 19, 2013 By Leave a Comment
… and load environment. Yoshinori Matsunobu will discuss database storage costs and provide performance tuning tips and tricks …MySQL Conference and Expo by Facebook technical experts include: Nizameddin Ordulu, Software Engineer, and Justin Tomer, Software Engineer, will present “InnoDB Compression…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
… Falcon. It is worth to note MySQL official marketing never position MySQL as such per say (for … primary key and unlike Innodb has key compression (one of major Innodb problems in my …Transactional storage engines though one need to take into account a lot of variables – how stable is engine and…
Post: Join performance of MyISAM and Innodb
May 29, 2006 By 6 Comments
… benchmarks of Join speed for MyISAM and Innodb storage engines for CPU bound workload, this is when data … and using hash, which is faster MyISAM does compression for character keys which makes it perform slower … the index, so there is no need for MySQL to request next row matching index Note: This …
