… user to lock records for edit/update, so the transaction is not interrupted until the transaction is finished/committed? A example of…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
…the very frequent cases with performance problems with MySQL is what they happen every…tuned system you have if you put too heavy of concurrent load on it the response times will increase…system to serve other users too you typically need to reduce concurrency to where it does not overload the system….
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
… off session binlog is the right strategy to go with. But can you explain why I’m witnessing the LOAD DATA INFILE command… the actual data would be transferred across the slaves via replication when LOAD DATA INFILE command is executed on master? (cuz that’s not what I’m seeing on our systems, with binlog left on at master when the command is issued)
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…the purpose of the tool. Q: When you say bail out, what does that mean? Does the…why ? without any replication filters or relevant args, the replication breaks reliably on the __tmp_x table why ? The…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… not properly indexed. Here’s a theory that seems to explain the performance you are seeing. The periodic performance variation corresponds to filling…the performance difference is basically that factor of 4. The variance is lower with only the primary key because the entire table fits in main memory…
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
…. The file that’s loaded on the master is actually inlined into the binary log, and the replica writes out a copy of the file into the directory indicated by slave_load_tmpdir. Then the LOAD…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…s the instance type with highest memory available, and memory is what really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory…performance, reducing the no. of secondary indexes or even going away with secondary indexes causes a write throughput increase…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… real system, it also does not allow effectively test caching solution, each row can be equally put into cache or removed. That’s why…, but it is hard to emulate high IO load. That’s why I was looking for alternatives, and Zipfian distribution seems decent… distribution has a parameter θ (theta), which defines how skewed the distribution is. A physical sense of this parameter, if to…
Comment: Testing Virident FlashMAX 1400
May 10, 2012 By 3 Comments
… of the separate variables. How does the new Cisco hardware effect of another well performing vendor? How much does “turbo” and “max performance” affect card performance? I realize they are a part of the total package, but it’s…
