I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show … are used by one user to lock records for edit/update, so the transaction is not interrupted until the transaction is finished/committed…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… all let me describe the EC2 instance type that I used. EC2 Configuration I chose m2.4xlarge instance as that’s the instance type… 56G while the size of the table with secondary indexes is 181G. Now let’s come down to the interesting part. Results With the table purchases… and checkpointing activity. This caused spikes in write activity to the point that the insert rate was decreased. Conclusion As we all now…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… made the decision not to support MySQL for IBM i any longer. This is certainly understandable. However, there are still users who want to… no-lock-in solution. If you want to leave the IBM i platform and switch to Oracle’s MySQL on another platform, it will… on the IBM i platform. We think that Zend DBi will be a great service to IBM i MySQL users who want to remain…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… properly indexed. Here’s a theory that seems to explain the performance you are seeing. The periodic performance variation corresponds to filling up a partition… when the iiBench project started, today the challenge would be to index 10B rows, not 1B rows. And it’s still a good challenge. The…
Comment: Testing Fusion-io ioDrive2 Duo
May 14, 2012 By 12 Comments
I think the $7-$8 per GB price is for the R4′s. The ones quoted from Fusion-io seem to run $12-$16 per GB.
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
… that the insights to the binlog would likely show what you’ve said and I do agree that turning off session binlog is the right strategy to…? (cuz that’s not what I’m seeing on our systems, with binlog left on at master when the command is issued…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… agree the command will take a long time to run at the source and it’s probably a good idea to turn off the session’s binary log in general. But if it’s left on, the… the slave(s) first and then run it on master (BEWARE: you should make sure to delete the INFILE from the slave’s filesystem). e.g. To…
Comment: Testing Intel SSD 520
May 3, 2012 By 7 Comments
Vadim, “End-to-End Data Protection” means it uses checksums when retrieving the data from flash chips. Compression is used, because in 520 Intel uses the SandForce controller and not their own controller like in 320. Good point that it’s the fact, that may spoil the results!
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… seem to be able to able to change the logfile size in a 5.0.95 MySQL database running on RHEL 5. I add the following line to… posted this in a few other forums (i think that’s frowned up) but will update with any resolution. I can…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… i have set files_per_table variable. i executed the following query to know the fragmentation SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND…=’abc’ and Data_free > 0 limit 10; and it returned the following result xyz abc 1.52MB 4.00MB(free space…; still the free space remains the same. that means that table could not be defragmented. is there any other way to defragment innodb…
