… tested only READ queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb… reach InnoDB results, but I hope PBXT team will improve performance to make the difference a bit better. Unfortunately InnoDB shows… plans about. It is also interesting to check PBXT performance on INSERT/UPDATE queries taking into account PBXT way to handle such queries…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… successive queries. Q: Is RBR faster replicating vs SBR replication? RBR is faster than statement based,… a high performance cost? A: Connecting to a MySQL database isn’t a great performance cost, …look forward to. Q: What about write splitting (updates,inserts) on multiple MySQL servers? Or is it …
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… several Full Text Search solutions and compare their performance. Even if you missed the webinar, you can…, do indexes stay up to date with changes (inserts, updates and deletes)? That’s a good question, because… where I announced the webinar: We evaluated MySQL vs Solr. I was able to index all the…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… of the article lets comment on IO vs Disk question. If you look at Disk …update queries (from replication thread for example). When update is performed first problem is actually reading the data. If you’re updating…re to modify) – even if you’re doing INSERT you will need to fetch clustered index …
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
… and bulk performances, but also about arbitrating resources usage among consumers and making decisions about avg vs. worst case latencies vs. throughput, which… layout) or is it more of a “plain sequential bulk insert/update on a very few tables” thing? Seekwatcher (http://oss.oracle…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…way we’d see a 3x performance boost and it would write at 100MBps vs 33MBps. Any plans to …benefit if you’re performing INSERT with multiple values? We build up INSERTS on our clients and insert values 50 or … you to answer second portion of the questions. UPDATE: Second Part of the answers is now…
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
…32 bytes vs 4 bytes for key value – if you would use integer key and insert data in… storage engine which usually considered best for parallel insert/updates) has pretty much table level locks when it… this little case we have about 200 times performance difference which is worth to consider Can UUID…
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… no REPLACE, and there is no INSERT/ON DUPLICATE KEY UPDATE.) I didn’t try the XQuery interface…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… alone (2600Mhz vs 2800Mhz) and it well may be more in terms of performance due to … be getting at least 800 JOPS on updated software and hardware configuration, so I would …. MySQL performance gains usually come from MySQL unique features – non transactional MyISAM, Multi Value inserts, Query Cache…
Comment: Edge-case behavior of INSERT...ODKU
October 30, 2012 By 6 Comments
…versus just going with a traditional INSERT ODKU? I’d be curious as… I’m also curious about your “update case statement” … seems to me that…SQL parser to would noticeably impede performance; we know from HandlerSocket that being…way to improve it. Marcus – Signed vs. unsigned is always good for some …
