…, compression was only possible with streaming backups + external (usually single-threaded) compression… to restore a single table). Percona XtraBackup now supports streaming… against debug versions of InnoDB. This is only for very… the upcoming Percona Live MySQL Conference and Expo (register now!)….
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_status_fileblogpercona.commanual innodb_strict_modeblogpercona.commanual innodb_support_xablogpercona.commanual innodb_sync_spin_loopsblogpercona.commanual innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb…compressed…
Post: Percona XtraBackup 1.6.3
September 23, 2011 By 5 Comments
… work for compressed InnoDB tables due to missing support for compressed pages in tar4ibd. Bug Fixed: #665210 (Alexey Kopytov). XtraBackup failed when innodb_flush_method… ID mismatch when using per-table tablespaces. Note that this fix may not work correctly with MySQL 5.5 or Percona Server…
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… now handles non-InnoDB tables. (Vadim Tkachenko) Bug #606981 – Streaming InnoDB files with tar4ibd could lead to filesystem hangs when InnoDB was configured to… #688417 – It’s now possible to do incremental backups for compressed InnoDB tables. Bug #701767 – The script innobackupex-1.5.1 was renamed…
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… for Innodb table, while data pages and pages for different indexes may well have very different compression ratio. As Innodb indexes are not prefix compressed…
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…. 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…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
…table it often makes sense to keep it compressed. Unfortunately MySQL does not provide compressed BLOB/TEXT columns (I would really love to have COMPRESSED…you with true data size and performance gains, especially for Innodb tables. With Innodb tables BLOB gets its own page (allocated outside of …
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL…compressible and light compression can compress results at faster than wire speed for 1Gb networks. Plus if we can get MySQL…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
…tables: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE ‘INNODB%’; +—————————————-+ | Tables_in_INFORMATION_SCHEMA (INNODB%) | +—————————————-+ | INNODB_CMP | | INNODB_CMP_RESET | | INNODB_CMPMEM | | INNODB_CMPMEM_RESET | | INNODB…
Post: Innodb Caching (part 2)
May 10, 2011 By 7 Comments
…set of primary key values from sysbench table and reading them over and over again….Compression results come as a huge disappointment. The compressed .idb file was only 620MB so if Innodb would chose to keep only compressed… results for 16K and 16K Compressed to be very similar on MySQL 5.5 As a …
