…mysql #for 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…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb…= 64M serverid = 101 key_buffer_size = 8M … myisam_max_sort_file_size = 10G myisam_repair…
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: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…next point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best… can write CSV files with any programming language. Naturally, CSV files don’t store … inconvenient limitations on some key parts of partitioning, such as maintenance and repair commands, that …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…_preload_keys‘, ’0′ ‘Com_prepare_sql’, ’0′ ‘Com_purge’, ’0′ ‘Com_purge_before_date’, ’0′ ‘Com_rename_table’, ’0′ ‘Com_repair‘, ’0… to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… issue different queries which may trigger check/repair running for many tables at onces,…files or .frm being unsync with internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL… Start – If you restart MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,…
Post: Adventures in archiving
February 11, 2013 By 16 Comments
…InnoDB‘s inbuilt row compression MySQL‘s inbuilt compress() function leveraging zlib to provide compression of data. MySQL…PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY…, ensure you have innodb_file_format Barracuda as…table checksum. #57188 Repair tools will not …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb… key_buffer_size = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…files. MySQL configuration: [mysqld] gdb innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb… = 10 #*** MyISAM Specific options key_buffer_size = 8M read_…_max_sort_file_size = 10G myisam_repair_threads = 1 …
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
…PRIMARY KEYs with Innodb tables due to the fact all other key will refer to the rows by primary key…but meta data such as original image sizes, file size as well as thumbnail location on …/repairing large MyISAM tables in case of MySQL/System crash is painful and great to be avoided. Long primary key…
