…_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave…_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave… log file on the master, which is probably not what you want. So never set master-xxx variables in my.cnf! From MySQL…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6…tried to increase innodb_lru_scan_depth variable to 8k,16k,32k but that…DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx… to run test for 10x dataset: ./bin/linkbench -D requesters=64 -D dbid=…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…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: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
…log events: master [localhost] {msandbox} ((none)) > show global variables like ‘binlog_checksum’; +—————–+——-+ | Variable_…Log_File and Exec_Master_Log_Pos from SHOW SLAVE STATUS slave1 [localhost] {msandbox} ((none)) > change master to master_log_file=’mysql-bin.000001′, master_log…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…ROW log_bin=mysql-bin wsrep_cluster_address=gcomm:// wsrep_provider=/usr/lib/libgalera_smm.so datadir=/var/lib/mysql …have a 3 node cluster. mysql> show global status like ‘wsrep_cluster_size’; +——————–+——-+ | Variable_name | Value | +——————–+——-+ | wsrep_cluster_…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… status\G *************************** 1. row *************************** Master_Log_File: mysql-bin.000007 …. omitted …….. Exec_Master_Log_Pos: 207 slave1 > show status like ‘%temp%’; +————————+——-+ | Variable_name | Value | +————————+——-+ | Slave_open…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… thing to check for. VARIABLE=${VARIABLE:-Threads_connected} You need to change the threshold to 15, and the variable to Threads_running. Check… can log into MySQL (if necessary, put a password into .my.cnf, or in the MYSQLOPTIONS variable). Now you can simply start running bin…. There are many things that can cause a stall in MySQL, and they usually begin microscopically and get worse over time…
Post: Win a free ticket to RailsConf!
May 15, 2011 By 10 Comments
…# by setting the variable “err-log” # in the [safe_mysqld] section as follows: # # [safe_mysqld] # err-log=/var/lib/mysql/mysqld.log # # If the root…mysql/mysqld.log { create 600 mysql mysql notifempty daily rotate 3 missingok compress postrotate # just if mysqld is really running if test -x /usr/bin…
Post: Debugging MySQL SSL problems
November 8, 2012 By Leave a Comment
…mysqld error log (clean as a whistle!) Trying to find an option for the mysql cli that will output the actual SSL error (nary to be found!) Running: SHOW VARIABLES LIKE ‘%ssl%’ (mysql…the/root /usr/bin/openssl s_server -cert /etc/mysql/ssl/server-cert.pem -key /etc/mysql/ssl/server-key…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…show_storage_engines’, ’0′ ‘Com_show_tables’, ’2842′ ‘Com_show_variables‘, ’176825′ ‘Com_show_warnings’, ’8′ ‘Com_slave_start’, ’0′ ‘…socket=/tmp/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_…
