I am considering changing web-applications from VB6 to PhP/MySQL/… is worth a 1000 instructions. Please do this for us. I am sure there are many in this situation.
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
…? Or is it more complex than that? I‘m new to Fusion-IO and I am going to do some testing with a…
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
Post: Training in London next week
May 16, 2012 By Leave a Comment
I‘m going to deliver MySQL Training next week (May 21-24) in London. This is a rare opportunity as I do not…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…. Configuration First of all let me describe the EC2 instance type that I used. EC2 Configuration I chose m2.4xlarge instance as that…, which can cause downward spikes in performance. Other then that, I have also disabled query cache to avoid contention caused by… = InnoDB, PARTITION p10 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */ Also, I ran 5 instances of iiBench simultaneously to simulate 5 concurrent…
Comment: How to track down the source of Aborted_connects
May 15, 2012 By 17 Comments
I know this is an old post, but I‘m hoping it’s still monitored. Do you have any suggestions on how to accomplish something similar but with a socket rather than TCP?
Comment: Testing Fusion-io ioDrive2 Duo
May 12, 2012 By 12 Comments
Joseph, Actually I could not find contacts in OCZ that would send me a test unit. So if you know someone – please let me know.
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
Statement-based replication transfers the file too. It has worked the way I‘m describing for a very long time, since at least MySQL 4.1.
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 10, 2012 By 28 Comments
… right strategy to go with. But can you explain why I‘m witnessing the LOAD DATA INFILE command being replicated in verbatim… command is executed on master? (cuz that’s not what I‘m seeing on our systems, with binlog left on at master…
