….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_pool_size = 2M innodb_log_file…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
…. 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 = 3 xtrabackup: innodb_log_file_size…. 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 = 1 xtrabackup: innodb_log_file_size…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… innodb_buffer_pool_size=6G 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: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
…: 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…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… 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…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
… innodb_buffer_pool_size=26G 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…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… using InnoDB tables #innodb_data_home_dir = /usr/local/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…
Comment: Btw xtrabackup is not only backup..
February 13, 2010 By 12 Comments
…. 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… 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…
Comment: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
January 13, 2010 By 20 Comments
…/mysqld.sock \ –innodb_log_file_size=20M \ –innodb_data_file_path=ibdata1:10M:autoextend \ –innodb_log_group_home_dir=/data/comdb-slave/mysql/datafiles/ \ –innodb_data_home_dir = /data/comdb-slave/mysql/datafiles/ \ –target-dir=/data/mysql…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual 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…
