…run a few slave instances each of production database servers and will perform the backups. The write… script” you’ll many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll… on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… obvious how they will affect your database workload. For example: Transaction commit takes … count + 1 where achievement = ‘killed_troll’; How many players might accomplish this achievement at the…we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not …
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…MySQL buffer pools or anything else that’s on your mind! There are numerous solutions for MySQL high availability. Many rely on MySQL… issue. At Groupon, our standard MySQL database configuration follows this active/passive …line option, we set the option innodb_fake_changes to prevent INSERTs, …
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
…name. Back in 1979, Monty developed an in-house database named UNIREG. UNIREG was a text-based program … || int_count > 255) { my_message(ER_TOO_MANY_FIELDS, ER(ER_TOO_MANY_FIELDS), MYF(0)); DBUG_RETURN(1); } …right folks, in MySQL 5.6 you can create a table with a few more columns in InnoDB! This …
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… (`NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 `NAME` is a human readable table name in form database_name/…find InnoDB pages which belong to the table’s index. Which one? A table can have many secondary…zero. If you know how InnoDB uses `PREC` please let me know. mysql> select * from SYS_COLUMNS …
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… converted databases from MyISAM to InnoDB, mysql tunning script gives below results for temp table , server has 4G ram, which almost uses, as many…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… with many server installations) or a system administration mistake to delete one of MySQL‘s log or data files from disk. The database… other problems. The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention that crosses…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
…, work on the Innodb Full Text Search project was started over 6 years ago, in addition with many optimizer and replication features… testing questions, we have customers backing up and restoring MySQL 5.6 databases in standard configuration successfully with the current version. The…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1; total records:…Concurrent growth of many tables causes data fragmentation and affects table scan performance nadly – MyISAM suffers worse than Innodb – Innodb extent allocation…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use reasonable global buffers, such as innodb… no comparable variables of how many user variables are allocated (and… Free buffers 1 Database pages 8252672 Old database pages 3046376 Modified db…
