….cnf|grep innodb innodb_data_home_dir = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem… set (15 min 54.29 sec) Please help to improve performance and suggest if any config changes are to be made…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
… amount of time. Setting innodb_concurrency_tickets too high can have startlingly negative performance implications. On the other hand…innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_files_in_group=2 innodb…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
…used innodb-log-block-size=4096 in Percona Server to get better throughput, but later Dimitri in his article MySQL Performance: Analyzing… 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…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… 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… next step, read detailed investigation what is the reason of performance drop in next post. And last one workload I tried…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb_data_home_dirblogpercona.commanual Innodb_data_pending_fsyncsblogpercona.commanual Innodb_data_pending_readsblogpercona.commanual Innodb_data_pending_writesblogpercona.commanual Innodb_data…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…innodb_data_home_dir = /data/mysql/var innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… the best peak performance, but also stable and predictable performance. I refer you to Peter’s post, Performance Optimization and Six …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…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
…(which is default and most performance mode) does not warranty storing all InnoDB transactions on permanent storage. …innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=256M innodb_thread_concurrency=0 innodb…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… stage. Is it the current performance, future performance, scalability, ability to recover … may run ‘du’ on the data files, or simply skip this step….there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for…/mysqlsla perl mysqlsla -lt slow /path/to/slow.log By default,…
