… innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock” and… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will… working. Also, instead of having 1 or 2 spare drives per controller, I have 2 for the whole setup. A small…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… an option: Table was dropped and innodb_file_per_table is ON Frm file corrupt, zeroed out, lost or SHOW CREATE TABLE crashes MySQL There…_TABLES SYS_INDEXES SYS_COLUMNS SYS_FIELDS SYS_TABLES Here InnoDB keeps correspondence between human readable table names and their internal identifiers. CREATE TABLE `SYS_TABLES…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… ms per/cmd 0.3208 ms min per/cmd 0.4159 ms max per/cmd 0.0951 ms range per/cmd InnoDB MySQL Select (same table): Fetching [1,000,000] items: 441573 ms total 0.441573 ms per/cmd 0.4327 ms min per…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb_read_io_threads = 8 innodb_write…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb_log_buffer_size = 128M innodb_flush…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… = 1 innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io…
Post: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
March 20, 2013 By 2 Comments
… or the –tables option in xtrabackup. Bug fixed #1130627 (Alexey Kopytov). innobackupex didn’t add the file-per-table setting for table-independent backups. Fixed by making XtraBackup auto-enable innodb_file_per_table when the –export option…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… your FRM file, you instead get some bunch of bytes per 19 columns). create_fields.elements*FCOMP is just number of… and just says “Can’t create table ‘test.t’ (errno: 139)”. This is because InnoDB has a hard limit of 1,000… MySQL 5.6 you can create a table with a few more columns in InnoDB! This led me on another idea… what…
