… connected from one machine to another and configured with Linux network interface bonding in balance-rr mode; this is the only… the performance being all that fantastic, and I could see network latency wreaking havoc with MySQL’s internal understanding of what…” errors. I was able to get the server up with –skip-grant-tables and insert a few rows into an InnoDB…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…skip_log_warningsblogpercona.commanual skip_name_resolveblogpercona.commanual skip_networkingblogpercona.commanual skip_partitionblogpercona.commanual skip_safemallocblogpercona.commanual skip_show_databaseblogpercona.commanual skip_slave_startblogpercona.commanual skip_sslblogpercona.commanual skip…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… socket = /tmp/mysql.sock bind-address=10.234.94.71 skip-locking key_buffer_size = 2000M max_allowed_packet = 32M # table… # (via the “enable-named-pipe” option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… than this article can cover, and might wander into Apache, networking config, caching layers, etc. Wherever the problem is, we’ll…/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock… hardly any load. But for the application, it’s another network round trip. It is a “garbage” query that just adds…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… check this by running ‘mysqlbinlog’ on the relay log), a network problem, or a bug in the master’s or slave… could cause it – it could be network (especially if replicating over unreliable long distance networks), MySQL bugs on master or slave, hardware… recover “corrupted” event to be manually executed on the slaves. Skipping around event makes master and slave potentially inconsistent and you…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… MySQL crashes you will not get all data in the network packet you potentially could get due to buffering. So now… – typically if page directory is corrupted you would need to skip at least whole page. If page is corrupted at higher level in BTREE you may need to skip a lot of pages (whole subtree) to use this recovery…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… to compress backup ? Backup it to tape, FTP or any network backup software – it is easy as you just need to… need to synchronize binary log position with backup you can skip this step. 2) While holding connection open run: lvcreate -L16G… could have accomulated – especially if you use slave_skip_errors or sql_slave_skip_counter. Cloning master you’re starting from consistent…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… your backups are somewhere else! You lose a PSU or network switch in your datacenter and some or all of your… how fast you can transfer data over your network. If you have 1GB network and you have 1TB of data, it could… schema file, putting in the current charset mysqldump … -d -R –skip-triggers, out to the schema file create a schema-post…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
… will need to be inside the same security group for networking purposes and the help identify them. To create a security… be able to see both heartbeat processes chatting over the network root@monitor:~# tcpdump -i eth0 port 694 tcpdump: verbose output… manager MySQL, just the host running it. I’ll also skip the raid configuration of multiple EBS volumes since it is…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… writer VIP. This attribute allows the use of a private network for replication if needed. Next is the mysql primitive resource… writer vip are defined. Those are straightforward so I’ll skip detailed description. The next interesting element is the master-slave… many requirements regarding the MySQL configuration, Pacemaker will automatically add “skip-start-slave” for a saner behavior. One of the important…
