… 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… mysql> insert into percona values (0,’percona2′,’jay’); Query OK, 1 row affected (0.02 sec) The wsrep status variables are like…
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… problems are even worse with long running queries like INSERT INTO table1 … SELECT … FROM table2. In … when we were working on a Consulting case for a customer. So, if this saves …
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…policy=”ignore” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin…slave_updates = OFF” (default value). In some cases, if slaves are logging replication updates,… SUPER privilege which overrides read_only. Like I mentioned above, this project is …
Post: Edge-case behavior of INSERT...ODKU
October 27, 2012 By 6 Comments
…to be considered as being defined first. So, MySQL checks our INSERT, sees that the next auto…on username is, for all intents and purposes, ignored. For the customer whose database served as the… half of the column’s available range. Intuition, like the laws of physics, often breaks down in edge case…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… system as concurrency growths. In many cases however we’re facing a need…I get into further details I’d like to look at basics – what resources… store temporary table, but let us ignore them for a moment. The amount… a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat …
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…of filtered or partial MySQL Replication (as of version MySQL 5.0) – there … backup. There are however some cases when you really do not …table, replicate-ignore-table, replicate-wild-do-table and replicate-wild-ignore-table options… replicating over long distance and would like to save on traffic or …
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… randomly positioned, which is a worst-case scenario for spinning disks. This is …. I know what I’d like: I’d like to ask the disk itself …, and told you to ignore the ratio and in fact, ignore Key_read_requests altogether… to your IO system’s capabilities. MySQL doesn’t have good instrumentation for …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852 26909 0 19:08 pts/2 00:00:00 grep mysqld In this case, yes it… to just ignore. The above process may look like a static recipe that you can just mechanically execute, and in some cases that…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… figure out which files it can ignore. What we’re doing here starts to look like a hillbilly version of Infobright… you should use traditional DW methods, like star schemas. The problem is that MySQL doesn’t tend to perform well on… the gains are simply limited by some of MySQL‘s weaknesses in some cases. Not only that, but star schemas are not…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1+ it is also possible to fix this problem for cases when… where already which may come in MySQL 5.2 or even MySQL 5.1. I surely would like to see it sooner at… in many cases can be removed for READ-COMMITED isolation mode which will start offering more performance benefits in MySQL 5.1…
