…that are caused by the log records in the transactional log being overwritten before they …abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer satisfied mysql dependency…innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to fail. …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and variable…log_binblogpercona.commanual log_binblogpercona.commanual log_bin_indexblogpercona.commanual log_bin_trust_function_creatorsblogpercona.commanual log_errorblogpercona.commanual log_isamblogpercona.commanual log_outputblogpercona.commanual log…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… mysqld (i.e. shutdown, mv mysqld mysqld.old, cp /debug_bin_path/mysqld ./mysqld, startup). If you have (through download or from…,744B) 0x728DAA: Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql-5.5…,096B) 0x728DAA: Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql-5.5…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc_…config: The path of the my.cnf file. Remember that Pacemaker will start MySQL, not …(default value). In some cases, if slaves are logging replication updates, it may cause failover issues…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… old working code path if XA is disabled ? Many customers do not flush binary log anyway and use …have innodb_flush_logs_at_trx_commit=1 so transactions are truly durable. You have to have log-bin enabled … on MySQL 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…-port = # # binary logging – not required for slaves, but recommended #log-bin # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname tmpdir =/mysql_tmp/:/tmp/ # Uncomment…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M binlog_format=MIXED log-slave-updates log-bin… innodb_data_file_path=innodbspace1.dbf:1073741824;…log_buffer_size = 32M innodb_log_file_size = 512M innodb_open_files=2048 #Replication-skip replicate-ignore-table=mysql…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… thread initialized, starting replication in log ‘bin.000025′ at position 12410321, relay log ‘/var/log/mysql/relay.000086′ position: 4837623 080625…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: table_cache negative scalability
April 14, 2010 By 23 Comments
…logs/ibdlogs/dbtmp pid-file = /db/mysql.pid log-error = /db/mysql.err log-slow-queries = /db/slow-queries.log log-bin = /db-logs/bin-logs/mysql-logs/mysql-bin expire_logs_days = 30 # Expire logs…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…logs/ibdlogs/dbtmp pid-file = /db/mysql.pid log-error = /db/mysql.err log-slow-queries = /db/slow-queries.log log-bin = /db-logs/bin-logs/mysql-logs/mysql-bin expire_logs_days = 30 # Expire logs…
