…=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_open_cache_instances=8 sort…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` ( `id`…is where Metadata files come in to play Creating a Metadata File The format of the metadata file is XML-based…all columns in the schema, really handy to sort by name to see if you have …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… about employing a filtering solution of any sort and it’s something you’re not …libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ …-tables and insert a few rows into an InnoDB table, but trying to run a simple …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…= 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_…_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_…
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…= 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = …
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
… the recovery cases I worked on, customers did have some sort of backup, but it just wasn’t working, complete and… lost: MySQL had a dedicated partition on XFS file system Server was running innodb_file_per_table There was a production master and… file recovery tools for xfs – apparently they are all targeting specific file types and sure enough InnoDB is not one of the supported files…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…=15G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=512M innodb…=1000000 query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size=16…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
… which may take too long to complete Index build by sort. This is in ToDo but so important I’ll still… key and promoting real one to unique. Tablespaces. To call “innodb_file_per_table” option tablespaces is a joke. It is better… be very helpful with direct IO as well as with innodb_file_per_table=1 allowing to flush all of modified tablespaces…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_doublewriteblogpercona.commanual innodb_fast_shutdownblogpercona.commanual innodb_file_formatblogpercona.commanual innodb_file_format_checkblogpercona.commanual innodb_file_format_maxblogpercona.commanual innodb_file_per_tableblogpercona.commanual innodb…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_LOG | 50 | 80 | | OPEN_FILES_LIMIT | 1024 | 5000 | | INNODB_AUTOEXTEND_INCREMENT | 8 | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE | 2097152 | 262144… | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON | | SYNC_MASTER_INFO | 0 | 10000 | | DATADIR… innodb_file_per_table is now ON by default. This is very big change and is good one. We have been running innodb_file…
