… user=justin 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: 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…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… files over taken from backups. But in some cases even .frm files is not an option: Table was dropped and innodb_file_per_table is ON Frm file corrupt, zeroed out, lost or SHOW CREATE TABLE crashes MySQL…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… your 80×24 terminal UI in your FRM file, you instead get some bunch of bytes per 19 columns). create_fields.elements*FCOMP… 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…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… innodb_flush_method = O_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…
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_log_at_trx_commit = 1 innodb_log_file…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…_files_in_group = 2 innodb_flush_log_at_trx_commit = 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: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…has been merged. Fixed by removing files corresponding to tables that are missing in the incremental … fixed #1130145. Percona XtraBackup didn’t initialize per-thread data in the log copying thread… #1169509. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to …
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
1) innodb_file_per_table is OFF by default, which means all tables are in ibdata1. 2) if it was HW problem and …/wiki/innodb-data-recovery-tool:mysql-data-recovery:start . The biggest challenge here is to find index_id for each table – http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:advanced…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
1) innodb_file_per_table видимо по умолчанию, ибо в my.ini он отсутствует. 2) …
