…one of them wanted to evaluate RDS as a replacement. It is built on the same technologies, but… threshold, as famously happens in B-Tree inserts (see InnoDB vs TokuDB for example). This doesn’t mean… in-memory bottleneck to solely on-disk. The insert performance is quite variable, more so than I would…
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
… performance for the application and I was replacing single value UPDATE with multiple value REPLACE (though I also saw the same problem with INSERT ON DUPLICATE KEY UPDATE) As I went from 1 value to 3 or 10 in the batch performance improved… completed in 12 seconds for 1000 rows in a batch vs 40 seconds for single row statements. So with single statement…
Comment: Can MySQL temporary tables be made safe for statement-based replication?
May 28, 2008 By 8 Comments
… (there are more reasons also) because we want to replace multiple inserts with one bulk in the main table. Now if I… concerned. I’m in a complete deadlock situation of Reliability vs Performance. And to top it all, I want both.
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… killing server performance overtaking buffer pool. Though full table scan is only one of replacement policy …we’d see a 3x performance boost and it would write at 100MBps vs 33MBps. Any plans… you’re performing INSERT with multiple values? We build up INSERTS on our clients and insert values 50 …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…I should note MySQL 5.0 vs 4.1 has a lot of performance differences and not all …to Reads because Flash requires “erase” cycle to replace the data plus this erase can only …, concurrent inserts, instrumentation, etc.). Rather than treat each defect as an individual case, is there any performance …
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… one Peter wrote about recently). The client’s performance is suffering in part because of the … wanted to see how fast MyISAM vs. MonetDB would interpret really large INSERT statements, the kind produced by… recursive ones. (No, there is no REPLACE, and there is no INSERT/ON DUPLICATE KEY UPDATE.) I …
Post: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 18, 2010 By 15 Comments
…, randwr rows) 3. For cards connected in hardware raids, DEADLINE performs much worse than CFQ. Sequential reads: – For sequential reads you… sequential reads. I think it is competitive vs FusionIO if we look into price/performance analysis (remember FusionIO is twice as expensive… “hot”remove and insert cards, while for FusionIO, which put into PCI-E bus, you need to shutdown server to replace it
