… (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows replication down. If the load takes 4 hours… good idea to turn off the session’s binary log in general. But if it’s left on, the replication logic only replicates… should make sure to delete the INFILE from the slave’s filesystem). e.g. To reiterate this, make sure ‘/tmp/data…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… still the tool serves well for benchmark purposes. OK, let’s start off with the configuration details. Configuration First of all… of traditional InnoDB log flushing, which can cause downward spikes in performance. Other then that, I have also disabled query cache to… pool mutexes, using “estimate” checkpoint method to reduce chances of log flush storms and disabling the query cache.
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help in many… too much in this case throttling by having relatively short queries and introducing “sleeps” between them can be a good idea…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
@Time Callaghan, I did not test with innodb_flush_log_at_trx_commit=1 because the durability requirements are not that stringent. And following is how I invoked iiBench: iibench -T $tbl_name -D iiBench -r 200000000 -M 1 -s 1000000 -t 100000 -I 1 -a -S
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… only a few GB of main memory). The cost of querying this database will be 10 times higher with this partitioning… 100 disk seeks to answer a random query, assuming you can get each index query down to one disk seek.) I claim that this schema is not properly indexed. Here’s a theory…
Comment: Joining many tables in MySQL - optimizer_search_depth
May 12, 2012 By 6 Comments
… hints surely help pushing the performance in case of particular queries but surely cannot be an all-around answer to inefficiencies…. In addition, hints need to be built into the (application’s) logic which is simply a nightmare for developers in case…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
I’m not suggesting to turn off the binary log. I think you have some assumptions that you may not have validated. The file that’s loaded on the master IS transmitted to replicas, in a number of special binary log events (of type “Load_file” if I recall correctly).
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… replicated verbatim. The file that’s loaded on the master is actually inlined into the binary log, and the replica writes out…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… basically a renamed build of MySQL for IBM i. It’s a 100% compatible drop-in replacement. Everything works on Zend…, management scripts, or anything else. There is no difference in query syntax, client-server protocol, or data storage on disk. Anything… to leave the IBM i platform and switch to Oracle’s MySQL on another platform, it will work seamlessly. Why is…
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
… follow: Transaction1: root@localhost:test 14:33:38>start transaction; Query OK, 0 rows affected (0.00 sec) root@localhost:test…:40> Transaction2: root@localhost:test 14:35:50>start transaction; Query OK, 0 rows affected (0.00 sec) root@localhost:test… LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) MySQL thread id 31929, query id 484616 localhost root update…
