… to upgrade or make any configuration change on your MySQL database the first advice usually is: – Benchmark! How… to enable the slow query log on the PROD server. We should have it enabled during the peak time to… We also see that some queries had errors. Those error are shown on the stderr so you …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…log = 50 max_connections = 2500 max_connect_errors…to IO alignment yourself. In this case offset is correct, but file system is unaware how to…to 33x in single-threaded workload. File system IO alignment seems to have made a difference – up to 15% with write-back cache enabled…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…how to read these, there’s a full explanation in our book, High Performance MySQL…error log. The error log shows all sorts of interesting things. Basically, anything but silence in the error log is interesting and needs to…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… with an overview of how to install and run FlexCDC,…Log is the MySQL log which records changes to tables in the database. FlexCDC reads the binary log to…logging not being enabled) it will exit with an error. It will exit with a message “setup completed” otherwise. Verify installation The binary log…
Post: How to know if you're updating Slave you should not ?
April 11, 2010 By 8 Comments
… to have binary log on the slave if you do not need it for anything else. By default MySQL … In many cases however log_slave_updates is enabled which makes slave to write all updates to binary logs – the ones executed … server id 101 end_log_pos 1007 Query thread_id=5 exec_time=0 error_code=0 SET …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… max_connections=300 max_connect_errors=100 table_cache = 6000 read_…log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql…size = 32k – It is interested how much this was really investigated…I believe there was attempt to enable it and it did not…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…to clear the current input statement. percona1 mysql> use test ERROR 1047 (08S01): Unknown command If you try to… thing, this is how it needs to work and you… see it in the log file: 120724 10:58:09…enabled. And if the local state seqno is greater than group seqno it fails to restart. You need again to…
Post: Add an option to Fail on Innodb Initialize failure, Please ?
October 11, 2007 By 9 Comments
… is no option to only start MySQL if all enabled storage engines could be initialized. It should be pretty trivial to add one I… MySQL server Error Logs but the error message accessing Innodb tables is also very obfuscated: error : Incorrect information in file: ‘./prod/user.frm’ How this supposed to…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…bin logs –compress …to the schema file create a schema-post file that has the triggers # mysqldump … -d -t How to…enabled by default. The time needed to…error and are aborted, we send a critical alert immediately to be investigated The number one cause of backup alerts are due to… for MySQL in…
Post: read_buffer_size can break your replication
June 6, 2012 By 12 Comments
… going to talk about read_buffer_size and how this…error on max_allowed_packet. The next step is to check the binary logs of both masters. MasterA: masterA> mysqlbinlog data/mysql…log from MasterB and the replication breaks because packets are too large. No, the replicate_same_server_id is not enabled…
