… settings: innodb_buffer_pool_size=24G 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_log_file_size=1900M innodb…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…=16M innodb_buffer_pool_size=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_status_file…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…=32M innodb_data_home_dir=/home/mysqld/mdmp/data/ innodb_log_group_home_dir=/home/mysqld/mdmp/data #innodb_data_file_path=innodbspace1.dbf:1073741824;innodbspace2.dbf:1073741824:a utoextend innodb_data_file_path…=32M innodb_data_home_dir=/home/mysqld/mdmp/data/ innodb_log_group_home_dir=/home/mysqld/mdmp/data #innodb_data_file_path=innodbspace1.dbf:1073741824;innodbspace2.dbf:1073741824:a utoextend innodb_data_file_path…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…/mysql/data/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /usr/local/mysql/data/ #innodb_log_arch_dir = /usr/local/mysql/data/ innodb_data_home_dir = /db innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /db innodb_log_arch_dir…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…INNODB_CONCURRENCY_TICKETS | 500 | 5000 | | INNODB_PURGE_THREADS | 0 | 1 | | INNODB_OPEN_FILES | 300 | 2000 | | INNODB_DATA_FILE_PATH | ibdata1:10M:autoextend | ibdata1:12M:autoextend | | INNODB…
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…
Comment: Btw xtrabackup is not only backup..
February 13, 2010 By 13 Comments
… as followings. xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 5242880… or create data files. xtrabackup: If you tried to add new data files, and it failed here, xtrabackup: you should now edit innodb_data_file_path in my…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… values. 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 = 64M innodb_buffer_pool_size = 26G innodb_buffer…
Comment: How to calculate a good InnoDB log file size
June 1, 2010 By 38 Comments
… my settings: innodb_data_home_dir = /var/lib/mysql/ innodb_data_file_path = ibdata1:1000M;ibdata2:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/mysql/ innodb_buffer_pool_size = 2048M innodb…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… innodb_data_home_dir=/db/disk2/data innodb_data_file_path=ibdata1:10240M;ibdata2:10240M;ibdata3:10240M;ibdata4:10240M;ibdata5:10M:autoextend innodb_log_group_home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb…
