… compression on compress()-ed data just to see if there is any benefit 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…
Post: InnoDB page sizes: plans and ideas
April 21, 2011 By 8 Comments
… setting is for whole database instance and you need to mysqldump your data, re-create database and load data. It could… needed ? For InnoDB compression. Right now if you use 16K and trying to compress, the only good choice is to compress to 8K pages (which gives you only 2:1 compress ratio), and…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup) as this is only way… LZO default compression file compressed in 10.5 seconds and resulted in 390MB compressed file, this gives us 97MB/sec compression speed which is… backups. I should also note for mysqldump backup typically tools with better and slower compression make sense because it takes longer to…
Post: Interested to learn about New Innodb Plugin Performance ?
April 15, 2008 By 2 Comments
… less than 24 hours) as well as performance improvements to compression and fast index build functionality. As it is now publicly… you can blame both MySQL and Innodb for) – for example neither of standard data load tools (mysqldump import, using LOAD DATA INFILE or ALTER TABLE from other storage engine) would use Fast Innodb Index creation. Keep…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… records then InnoDB / MyISAM. Actually in internal cache records are stored in uncompressed form, but OS Cache can keep compressed pages in memory. For the data set we tested, TokuDB used 6.2x less disk space than InnoDB, and… a release soon. – The ways to do a backup is mysqldump/mysqlhotcopy. It is not fully transparent backup, as it applied…
Post: Living with backups
November 6, 2008 By 28 Comments
… queries against each table in the database when mysqldump is used or reading a lot of data … you can immediately, on the fly, create a compressed archive. For example: /root/backup-tools/tar –read-…. Even though it’s always the case for InnoDB tablespaces, other MySQL data files do not comply …
Comment: About This Blog
June 15, 2007 By 48 Comments
Peter – I have a question about backing up InnoDB tables, namely: I have a very very large database, on …,000 records in various InnoDB tables. Is there a faster way to back this up then a lengthy mysqldump to a text file? This also is extremly large, and even compressed with tar && gzip -9…
