… Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang when binary log is enabled. Bug… Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed… (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…(about 23GB). So it makes sense to check if the dataset size makes any difference….innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 … –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
…log coordinates and GTID information. That information is also printed by innobackupex after backup is taken: innobackupex: MySQL binlog position: filename ‘mysql…”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check the replication status: slave1 > show slave status\G [...] Slave_…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows parallel processing … Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client…cause SST to fail. Fixed by fix checking if xtrabackup_pid file exists once innobackupex…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
April 8, 2013 By 63 Comments
check the innobackup.backup.log in the /var/lib/mysql you might see some errors?
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…), and actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly… timeouts, applications often don’t handle or log this error appropriately. The pmp-check-mysql-status plugin can be configured to alert when…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… logs. General Query Log The first option is the General Query Log. Let’s see an example: Enable the log: general_log_file = /var/log/mysql/mysql.log general_log… the error log. We just need to enable log_warnings with a value greater than 1: log_warnings = 2 Then check the error log: 121227…
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
… you start MySQL and Innodb storage engine fails to initialize (ie you resized log file but forgot to delete old ones) MySQL Server simply would not start. In recent MySQL 5.0 series… you got use to old behavior and do not check MySQL logs but simply check it is started. It especially hurts if you have…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…/sbin/mysqld: ready for connections. Version: ’5.5.24-log‘ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Percona XtraDB Cluster (GPL), wsrep… CSV version is good for trending and alerting). Here MySQL is checked via HTTP checks. MySQL won’t serve these requests. As part of… able to use check MySQL via HTTP. The clustercheck script is a simple shell script, which accepts HTTP requests, and checks MySQL on incoming…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… Locking behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5.3… query cache lock | 0.000003 | | checking query cache for query | 0.000007 | | checking privileges on cached | 0.000003 | | checking permissions | 0.000005 | | sending cached result to clien | 0.000011 | | logging slow query | 0…
