…log_long_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db-logs/ibdlogs innodb_data_file_path = ibdata1:10M:autoextend innodb…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…log_long_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db-logs/ibdlogs innodb_data_file_path = ibdata1:10M:autoextend innodb…
Comment: Btw xtrabackup is not only backup..
February 13, 2010 By 13 Comments
…/lib/mysql xtrabackup: Target instance is assumed 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…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /var/lib/mysql/ #innodb_log_arch_dir = /var/lib/mysql…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 75 Comments
…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…Table where REQUEST_TIME >= ’2012-03-26′ group by field1; 14 rows in set (15 min 54.29 sec) …
Comment: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
January 13, 2010 By 20 Comments
…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…
Comment: FreeBSD tests
August 4, 2006 By 15 Comments
… –port=3306 \ –socket=/tmp/mysql.sock \ –user=root $LOGERR \ –datadir=$FSPATH…innodb_log_group_home_dir=$FSPATH \ –innodb_buffer_pool_size=256M \ –innodb_additional_mem_pool_size=20M \ –innodb_log_file_size=900M \ –innodb_log_files_in_group=2 \ –innodb_log_buffer_size=8M \ –innodb_flush_log…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…). Well I think my server can’t load all indexes in memory and this is slowing it down. I can tell… buffer pool size innodb_log_group_home_dir = /mnt/log_mysql innodb_log_file_size=1G innodb_log_buffer_size=64M innodb_flush_log_at_trx_commit=2 [mysql.server] user=mysql basedir=/var/lib…
