…, 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: 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: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… the excellent compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB compression is …mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb…
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 tables…
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: 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: 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: 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 …
Post: InnoDB page sizes: plans and ideas
April 21, 2011 By 8 Comments
…InnoDB compression. Right now if you use 16K and trying to compress, the only good choice is to compress…to set parameter per table and per index would make InnoDB really flexible for different type of use cases and storage. As Oracle makes a lot of new good features in MySQL…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… InnoDB tables — don’t use GUIDs. Which brings me to my next point: Use InnoDB Assuming that you will use the stock MySQL… use 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…
