…by Percona Toolkit. The MySQL server, of course, cannot risk to block directly all cases. A set of MySQL utilities were introduced by Oracle… 0 Duplicates: 0 Warnings: 0 $ mysqlindexcheck –server=user:pass@localhost test.test # Source on localhost: … connected. $ pt-duplicate-key-checker –tables …
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… upgrade, you cannot apply any …mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2 ] Now we can upgrade all servers…connection: Connection refused (111) Connection to cluster failed: Transport endpoint is not connected… …but MySQL…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… scenarios: For these tests, all servers are running on 127…., s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave…cannot totally forget old-style replication positioning. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… that were opened by the transaction, hence any DDL operation cannot commence till all the transactions that accessed that table are… the MySQL server or causing all the connections to get depleted. There are some other interesting consequences as well for application that use MySQL…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…the MySQL server development: there is support for it in the MySQL Test Framework, DBQP, and the server…loads are technically atomic, i.e. you cannot observe any intermediate state, it is … is possible when one connection issues SHOW VARIABLES or equivalent while another connection is just starting …
Post: Announcing Percona Server 5.5.25a-27.1
July 21, 2012 By Leave a Comment
… with the following error: “The MySQL server is running with the –secure-file-priv option so it cannot execute this statement”. LOAD DATA…: Percona Server would crash if userstats were enabled with any replication configured. This was a regression introduced with ssl connections count in statistics tables in Percona Server 5.5.24-26.0. Bug fixed…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…service’ Start Percona Server [root@alarmpi ~]# systemctl start mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands…another partition using fdisk & mkfs.ext4 (comment below if you cannot work out how, and I can post some additional …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…_name | Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | …for last. You cannot consider any one of …MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server…
Post: How to track down the source of Aborted_connects
August 23, 2008 By 19 Comments
… does not indicate that an active connection is closed at all. Rather, it shows that a connection cannot be made for some reason… the packets: [percona@server ~]$ strings tcpdump.out Host ‘XXX.XX.XX.XXX’ is not allowed to connect to this MySQL server I’ve anonymized the offending IP address. However, I checked the server‘s grant tables and…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 24 Comments
… have also committed successfully. In MySQL‘s semi-synchronous replication, the …replicas. Therefore, by definition the transaction cannot have committed on any of the…will not become delayed. The client connection is forced to wait until …guaranteed when at least one other server must have a copy of …
