… versions, compression was only possible with streaming backups + external (usually single-threaded) compression utilities,…Percona XtraBackup against debug versions of InnoDB. This is only for very advanced …topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically,…
Post: Innodb Caching (part 2)
May 10, 2011 By 7 Comments
… trying standard Innodb page size, 4KB page size as 16K page size compressed to 4. The data in this case compresses perfectly (all…. Compression results come as a huge disappointment. The compressed .idb file was only 620MB so if Innodb would chose to keep only compressed pages…, though I expect results for 16K and 16K Compressed to be very similar on MySQL 5.5 As a summary: If you…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…=16 –max-requests=0 –rand-type=uniform –max-time=1800 –mysql-user=root –report-interval=10 run this will report us… compressed tables CPU utilization is 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression tables…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…slave_compressed_…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… can use same “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances hashed by query… is highly compressible and light compression can compress results at faster than wire speed for 1Gb networks. Plus if we can get MySQL protocol to support such light compression in addition to zlib we could stream compressed results directly from storage and only de-compress…
Post: Percona XtraBackup 1.6.3
September 23, 2011 By 5 Comments
… TABLE, DROP/CREATE the_same_table or ALTER statements on InnoDB tables are executed while taking a backup, an upgrade to… work for compressed InnoDB tables due to missing support for compressed pages in tar4ibd. Bug Fixed: #665210 (Alexey Kopytov). XtraBackup failed when innodb_flush… tablespaces. Note that this fix may not work correctly with MySQL 5.5 or Percona Server 5.5 prior to version…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
… Percona Server 5.5, rather than MySQL 5.5. Support for building against InnoDB plugin in MySQL 5.1 has been removed. (Alexey… O_DIRECT on input InnoDB files if the value of innodb_flush_method is O_DIRECT in the InnoDB configuration. (Alexey Kopytov) Bug… #688417 – It’s now possible to do incremental backups for compressed InnoDB tables. Bug #701767 – The script innobackupex-1.5.1 was…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… me to my next point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best bet. (Actually… InnoDB/XtraDB tables… Optimize For I/O It is pretty much inevitable: if you do this kind of data processing in MySQL…, CSV files don’t store as compactly on disk as [Compressed] MyISAM or Archive. These are just some ideas I’m…
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… usability issues with this release (which you can blame both MySQL and Innodb for) – for example neither of standard data load tools…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… storage engine for MySQL – Innodb. Innodb Storage Engine was covered in a lot of talks, many of them done by Innodb users. I found… compression ratio. As Innodb indexes are not prefix compressed they have very good compression potential. I also would like to see some stats about compressed…
