MySQL 5.5 and Percona Server 5.5 do not solve all scalability problems even… which do not scale that well. This is why it is important to test performance and scalability for … something like this: SELECT * FROM table WHERE deleted = 0 AND group_id IN (62715996, 62716592, 62717660, 62717716, 62717722…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…5 5 iostat -dx 5 5 If you don’t know how to read these, there’s a full explanation in our book, High Performance MySQL… | | Com_admin_commands | 255868807 | 11893 | | Com_alter_db | 0 | 0 | …snip This output is very useful … a question of where they fall on the scale. Now I analyze these one at a…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the…star schemas. The problem is that MySQL doesn’t tend to perform well on a data warehousing workload…. never seen this approach scale well. Use The Best Technologies You Can MySQL is not the end-all…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…being from the future. The 0.3 – 0.4 second delay seems…latency on commit will be 5 ms each time. Q: …replication, galera and built-in mysql replication are independent from each other…performance scale with an increasing number of nodes? A: Since all the nodes has to do all the writes, you can’t scale…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…: InnoDB Flushing theory and solutions MySQL 5.5.8 in search of …0, flush list 105, single page 0 First, Pending writes “flush list” > 0 says that InnoDB does perform… I would recommend it. Vanilla MySQL performs equally bad on SSD and … keep Y scale as first graph to show impact on performance by …
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… for MySQL. Performance comparison of MySQL 5.0, MySQL 5.1 and MySQL 6.0 Come to see how performance of MySQL 5.1 and forthcoming MySQL 6.0 are different from MySQL 5.0 – … of documents with MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and Sphinx. This …
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
…MySQL 5.5 MySQL 5.6 All versions are vanilla MySQL, not Percona Server. The results are there: There is nothing unexpected, staring with InnoDB-plugin, MySQL scale…. Profiling MySQL 5.0 vs MySQL 4.1 couple years ago, I have seen biggest performance hit comes from query parser. In MySQL 5.0 grammar …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… subsystems. These are for MySQL 4.0 at this point but we hope to port some of them to MySQL 5.0+ Heikki also mentioned there are more things inside Innodb to unleash performance such as multiple purge… IO Tuning I should also mention Paul Tuckfield Keynote about Scaling Innodb at YouTube. There were many other interesting points in…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… fix for this scalability problem and it is merged into MySQL 5.0.30 “Enterprise” but according to the tests I’ve done… comparison in this test. Woodcrest has best performance in this test (and in many other MySQL tests), Opteron comes second and older… see MySQL 4.1 actually scaled pretty well with Niagra, suffering slow regression with increased concurrency rather than quick drop. In MySQL 5.0 it…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… be more in terms of performance due to architecture optimizations. The other big issue is using MySQL 5.0.27 which has Innodb scalability…% close in terms of performance is close enough for most applications for other properties such as scaling maintenance to become more important… databases) is not where most of MySQL sweet spots come from. MySQL performance gains usually come from MySQL unique features – non transactional MyISAM, Multi…
