… MySQL database administration challenges, such as: Selecting which queries you should try to optimize to get better response times How to efficiently purge data from a huge table without putting too much load on your server How to check which tables…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… and how it works internally because there are many documents about that: http://dev.mysql.com/…data from binary log: ‘The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged… you can run the pt-table-checksum and pt-table-sync. How to restore a slave in a …
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…MySQL 5.1 and newer with the InnoDB plugin, it’s easy to figure out which transaction is blocking others. There are some INFORMATION_SCHEMA tables that make this simple. Just query the tables… Notice that it self-purges its own data, and it won’… am still stumped as to how a SELECT-only transaction …
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…TABLE in 10k row chunks, by the way; I chose 1M because the rows were small). But how to…mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…data processing in MySQL, you’re going to end up heavily I/O bound. Listen to any of the talks at past MySQL… you still have to think about how to avoid enormous tables that are hard to maintain, back …purging and archiving data can be dramatic. Take It Easy On Replication Building aggregated tables…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
…To stop write activity we can either stop application or lock tables: mysql> flush tables…purge thread. It should purge all transactions up to very last ———— TRANSACTIONS ———— Trx id counter 0 16644 Purge…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…data for each of them using mysql_stmt_send_long_data call – Server buffers such data until you have executed prepared statement. Innodb Table…to do updates – Innodb only can purge data…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… recovery after MySQL crashes to make sure indexes are not corrupted. So we looked at how to get your data back from simple Innodb Table Corruption. In more complex cases you may need to use higher innodb_force_recovery modes to block purging…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… interesting information about how Shard-Query will perform on each database. To do the size…Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_…open-files=1000 innodb_fast_checksum innodb-purge-threads=1 innodb-read-ahead=linear …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… to see some stats about compressed tables, such as what is the average size pages were compressed to for data and for various indexes. How… of concurrent inserts happening to the same table. This was born same as bunch of others due to statement level MySQL Replication which among… to port some of them to MySQL 5.0+ Heikki also mentioned there are more things inside Innodb to unleash performance such as multiple purge…
