…virtual-machine approach, but for the optimal production deployment you want two identical… over the manual’s description of how replication filtering rules are processed. …if you see a large number of long-running queries in the output of… insert a few rows into an InnoDB table, but trying to run a…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… Also, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or… is still in development while we determine the optimal JSON structure. Version check is on by … so specify –iterations or –run-time to limit how long they run. There are more changes in addition…
Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)
December 22, 2011 By 5 Comments
… tables every second which means we’d take a very long time to create 30,000. After a bit of time… setting a higher innodb-autoextend-increment and a larger initial size. This also did not help. So how fast is InnoDB under all of this? Am I hitting a fundamental limitation in InnoDB? Well…. I went…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…to predict. A customer may call and ask “how long to debug server lockups?” It could be ten… there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (… big gains. Schema, query, and index optimization Analyzing and optimizing a server’s table and index structures…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… bit slow it down. Plus there were bunch of micro optimizations in Innodb in 5.0 series. Also note the “Auto Increment… to figure our what the problem is. We can OPTIMIZE the table, but how long will this take? Is there a facility we… too long for your 150 GB table! If you have inserted in an ascending order of the PRIMARY KEY, then InnoDB should…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… major part of recovery time. It is worth to note Innodb optimizes log recovery by reading portions of log records and sorting… systems with large number of hard drives. So how do you estimate how long it takes Innodb to Recover ? Now you know there are… you expect system to handle and crash Innodb few times to see how long it takes Innodb to recover. I’d recommend to crash…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… thread will have to clean these up. This is how you make InnoDB behave like PostgreSQL 
If the undo log space grows… roll back, it will take a Very Long Time to do — I hate to think how long. I’m sure it would be…, which takes about 10 or 12 hours. InnoDB is not optimized for rollbacks, it’s optimized for transactions that succeed and commit. Rollback…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… power failure it may take long time before MySQL Server is operational again. So how to find the optimal combination ? First let me explain what happens on recovery and why large innodb_log_file_size…. Doing this several times you should be able to estimate how long recovery time take and adjust your logs apropriately. The good…
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
…load data in primary key order into Innodb tables for optimal performance, but effect does not end here…how much data is loaded per hour (assuming your Innodb tablespace did not have free space or you’re using innodb… in parallel and our rows were relatively long. In most cases I would expect load …
Post: How expensive is a WHERE clause in MySQL?
October 31, 2008 By 17 Comments
… How much overhead does a trivial WHERE clause add to a MySQL query? To find out, I set my InnoDB buffer… in memory: CREATE TABLE `t` ( `a` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; insert into t(a) values(current_date…. I then optimized the table and restarted MySQL. The table ended up at 237MB. Now let’s see how long a table scan…
