…MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t always great in comparison… the local disks, for example — the more operational complexity and cost you have, so that’…LVM snapshots, in terms of impact to the system‘s performance and ability to mount them on other…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… compares MySQL Performance with different CPUs, Operation systems, RAID Configuration, File Systems to assist you with your choices next time you select platform for MySQL. Performance comparison of MySQL 5.0, MySQL 5…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…benchmarks there is no direct comparison available. The configuration Tom … The MySQL Settings are probably what is the most interesting: MySQL 5…lless of performance. innodb_thread_concurrency = 0 Good! So Innodb performed … we have patches for this) Operating System Notes from database server: UFS…
Page: Presentations
May 3, 2006 By
…- Mercurial Egypt, December 2007 Talk about Mercurial version systems, comparison with similar tools and basic usage patterns …places. MySQL Performance Landscape MySQL Users Conference 2006, Santa Clara, CA MySQL was benchmarked on different platforms – hardware operation systems, file systems etc….
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… best performance, there should be an even data distribution in the system. …-Query will perform on each database. To do the size comparison, I used… 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘… hash joins and other background operations. This will have a direct …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…this is not the point of comparison. “Failback could destroy the original …degraded performance. In the large databases I run in production relaying on MySQL …operation to work. This is not to mention other things you can do with MySQL… – some people mainly deal with systems which can’t accept any …
Post: What did we want Interns to do
October 5, 2007 By 1 Comment
…operation systems, file systems, mysql storage engines, settings, MySQL versions, etc MySQL Patches – there are a lot of little cool things you can do to improve performance… Full Text Search Benchmark – we would like to get comparison for MySQL build in full text search, Sphinx, Lucene, PostgreSQL …
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
…and this is valid comparison for good and for bad…performance effect of it is yet unknown – how transactional system implements logging and dirty buffers flushing has serious impact on performance… It is too bad MySQL Users Conference only …it needs special compaction operations to keep data files…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM… Foreign Key and has an operational overhead. As you will …MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql… think the reason is pread system call MyISAM uses to …
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
… for this analysis. We are working on operating MySQL on Amazon and should be doing some performance analysis of Elastic Block Store (EBS… sysbench cases. In this case our comparison would need to be EBS vs. local file systems, which so far as I know are not SAN-based and should provide a reasonable reference for comparison.
