… in balance-rr mode; this is the only NIC bonding mode which will allow … or useful for point-in-time recovery. Generally if you’re considering the …the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If …and insert a few rows into an InnoDB table, but trying to run a …
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… variable – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb does… value of innodb_max_files_open in InnoDB: my.cnf So we can see Innodb may with to have so many open files during recovery stage…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…s configure PXC first. On the first node, my.cnf should look something like this on a …_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_log_…:19 [Note] Starting crash recovery… 120619 13:21:19 [Note] Crash recovery finished. 120619 13:21:19 …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…innodb-read-ahead-threshold=8 innodb-read-io-threads=16 innodb-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout innodb-rollback-segments=16 innodb…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…defaults-file=/etc/my.reg.cnf –prepare…InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Doing recovery: scanned up to log sequence number 3 768598528 (6 %) …. InnoDB: Doing recovery…innodb_expand_import=1; to put XtraDB into extended import mode…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…yet: Would this be related to long INNODB recovery time, to the point it will …00 sec) *** All db in replicated mode are using INNODB OS (all): Linux 2.6….my.cnf) were all disabled from 20 servers: # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… /etc/my.cnf,i add wsrep_cluster_address=gcomm:// to fill it ,the mysql server will not running [root@mysql1 ~]# vi /etc/my.cnf… innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 the wrong infomaton : 130221 17:59:00 mysqld_safe WSREP: Running position recovery… wrong… stack_bottom = 0 thread_stack 0×30000 /usr/sbin/mysqld(my_print_stacktrace+0×33)[0x8415893] /usr/sbin/mysqld(handle_fatal_signal…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation = READ-COMMITTED max… for operations. innodb_log_file_size = 1600M – another Benchmark optimization. Such large logs typically will cause too long recovery time in case…
