… statement. Lets look at what the problem is. As of MySQL 5.5 FLUSH TABLES WITH READ LOCK …by mysql client, so you might get a feel you can’t connect to the database at all (use mysql -… option. This option can be especially helpful when backing up data from the slave with –safe-slave-backup option…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… to recover changes that happend after taking a backup. The problem with this approach was that you had to do periodic… the interval you back them up. Recently in MySQL 5.6, mysqlbinlog got a new feature addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…connected or Threads_running. That’s a good place to start for finding a symptom that can trigger the problem… on Linux that we end up scripting mostly Linux-centric things,… line every 30 seconds. Come back later and see what it …that can cause a stall in MySQL, and they usually begin microscopically …
Post: MySQL Connection Timeouts
April 19, 2011 By 2 Comments
…connection. I’ll explain the math below. Second – is MySQL parameter back…problem and do some Math. First lets look into how MySQL accepts connection. There is single main thread which is accepting connections…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… bug fixes each of these releases contain. Using xtrabackup to back up older MySQL or Percona Server releases is still supported. This release… a large wait_timeout for the MySQL connection, innobackupex will regularly poll the server, keeping the connection alive while the backup is taking… –slave-save-info. This bug fix simplifies the connection code so that such problems are harder to create in the future along…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… to ensure your backup is consistent. Backing up database which was already corrupted is very nasty problem you want to avoid. Let’s… do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH… you want to let MySQL Server to continue, which is done by running UNLOCK TABLES or simply closing connection. 5) Mount backup…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…people to work as MySQL DBAs or be involved with MySQL Performance in … if you do not have Battery backed up cache. Many applications, especially those …problem. 1024 is good value for applications with couple hundreds tables (remember each connection needs its own entry) if you have many connections…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
Backing up MySQL Database most people compress them – which can make…100GB in size compression performance is usually not the problem (though backup impact on server performance may well be…compression will not speed things up on the standard point to point 1Gbit network connection. If we try gzip -1…
Post: Sharing an auto_increment value across multiple MySQL tables
October 4, 2010 By 9 Comments
…get the value: INSERT INTO option1 VALUES (NULL); # $connection->insert_id(); Option #2: Use a table …can see a potential for many other transactions to back up waiting on a lock (more on that … for x10000 iterations. Alright – option1 seems quicker. The problem is that to be like most applications, …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… all-important battery-backed write cache, how…MySQL is probably a good place to look for performance problems. Everything I’ve done up…_name | Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0…
