…. Bugs Fixed: Using Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client introduced a regression… detection did not work correctly for latest Percona Server and MySQL 5.1 releases which could cause innobackupex to fail. Bugs… with a diagnostic message about innobackupex –slave-info being ignored in such a case. Bug fixed #1180662. Low values for wait_timeout…
Post: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
After nearly every recovery case the same question arises: How many MySQL records were recovered and how many were lost. Until now… it will print “Leaf page: NO” and it can be ignored.
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 8 Comments
… MySQL version 5.1.22 or newer? If so, you probably have gaps in your auto-increment columns. A simple INSERT IGNORE query creates gaps for every ignored insert, but this is undocumented behaviour. This… by Michael Rikmas when we were working on a Consulting case for a customer. So, if this saves you from doing…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and variable…updatesblogpercona.commanual lower_case_file_systemblogpercona.commanual lower_case_table_namesblogpercona.commanual…_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid…” \ no-quorum-policy=”ignore” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc… setting is “log_slave_updates = OFF” (default value). In some cases, if slaves are logging replication updates, it may cause failover…
Post: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
March 20, 2013 By 2 Comments
… a large increase in disk usage in cases when there are many small InnoDB tablespaces. … corresponding to inaccessible datadir subdirectories to be ignored by XtraBackup without warning or error messages….. Bug fixed #1085099 (Alexey Kopytov). XtraBackup for MySQL 5.6 has improved the error reporting…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… of the system as concurrency growths. In many cases however we’re facing a need to answer …or memory to store temporary table, but let us ignore them for a moment. The amount of resources …You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld…
Post: Edge-case behavior of INSERT...ODKU
October 27, 2012 By 6 Comments
…considered as being defined first. So, MySQL checks our INSERT, sees that …. Unfortunately, this isn’t the case. (root@localhost) [test]> select * from update_test; +————+———-+———+———————+ | …is, for all intents and purposes, ignored. For the customer whose database …
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
or… “the case of Stewart recognizing parameters to the read() system call in … engine it is. We can ignore the upper limit on number of storage engines for MySQL and understanding the relationship between the… InnoDB itself and in the table_definition_cache). Further reading: MySQL Forge Internals document on the FRM file format Stewart’s…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… test to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is… two options referring to that: – pc.ignore_quorum: Completely ignore quorum calculations. E.g. in case master splits from several slaves it still… to master in this case. – pc.ignore_sb : Should we allow nodes to process updates even in the case of split brain? This…
