… observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows replication down… session’s binary log in general. But if it’s left on, the replication logic only replicates that “command” across the slaves… is missing from the slave boxes, then the LOAD DATA command will fail silently, allowing replication to proceed as if nothing…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 A count command…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… – I have created a backup of my mysql database using the innobackupex-1.5.1 command. I have the innodb_file_per… configuration file. I have the backup folder which contains xtrabackup log files, xtrabackup checkpoint file and a folder for my database… restore using the copy-back command. I am able to get the database in my /var/lib/mysql folder. But I am…
Post: Logging your MySQL command line client sessions
July 8, 2008 By 9 Comments
… command line client. There is another one which falls into the same list – the –tee option. Specifying –tee=/path/to/file.log… tee=/logs/mysql.log in “mysql” section in my.cnf to have logging enabled automatically when you start the client. If you’re looking to log session beyond MySQL command…
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: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
… seen by the application server. There are several techniques for logging queries with their execution times. I will list three. One… log the queries is that it might not log everything, such as superfluous ‘ping’ commands. Another option is to make the client connector log… some quick shell commands, for example. But with mk-query-digest’s built-in ability to decode the MySQL wire protocol, it…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… portion of the load in the application by aggregating query log with mk-query-digest. When I filtered out only queries…_select,do_select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one_conn…_select,do_select,JOIN::exec,mysql_select,handle_select,execu te_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one_connection…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs for your disk… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S 1… ROWS_UPDATED: 0 TABLE_ROWS_READ: 610954 SELECT_COMMANDS: 181243 UPDATE_COMMANDS: 0 OTHER_COMMANDS: 0 COMMIT_TRANSACTIONS: 181243 ROLLBACK_TRANSACTIONS: 0 DENIED…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…:333) ==9090== by 0x6B66F3B: log_init (mem0mem.ic:443) ==9090== by 0x6BC63B0: innobase_start_or_create_for_mysql (srv0start.c:1339) ==9090…: the accesses are actually protected. log_write_low asserts that it holds the log system mutex, and log_get_lsn acquires it.. ==9090…*, TABLE_LIST*) (sql_parse.cc:5179) ==9090== by 0x6435EA: mysql_execute_command(THD*) (sql_parse.cc:2309) ==9090== by 0x782C6D: sp_instr…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
… this slave. This is relay relay log corruption and you can check details in the MySQL Error log file. The error message describes… will purge existing relay logs re-fetch all events which have not been executed yet. Doing this command make sure your master is operational and it still has all the logs needed to re-fetch…
