… were a lot of custom technologies created for caching or scalability issues MySQL could not solve well. There are inhouse and opensource solutions… all those issues. And I’m not speaking about just database here, but rather whole stack to allow to build scalable web… and running fast and Scalability on the scale of Big Table with Map Reduce. Indeed I think MySQL Replication usage will reduce…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
As we can see, MySQL 5.5.8 comes with great improvements and scalability fixes. Adding up all the new features, you… that are supposed to fix the buffer pool scalability issue. Let’s see how MySQL performance changes for the last workload if we… pool scalability in a different way. UPDATE By request from commenter I put also results with different innodb_io_capacity for MySQL…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… negatively affected. In general even minor MySQL version upgrade can have both of these issues. It gets larger as you have a… both MySQL does not crash under your load as well s it scales well. There have been number of scalability bugs in MySQL history when issues would only happen at high load. You can…
Post: InnoDB auto-inc scalability fixed
September 26, 2007 By 18 Comments
There was long played scalability issue with InnoDB auto-increment field. For details check Bug 16979. …-level locks. With many concurrent inserted threads this causes serious scalability problems, and in our consulting practice we had a lot… tables with autoinc. I do not want to copy-paste MySQL documentation, the very good and informative description of the problem…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… to architecture optimizations. The other big issue is using MySQL 5.0.27 which has Innodb scalability issues, which were a lot improved in… published SpecJAppServer benchmark while still working for MySQL I remember we spot number of issues in MySQL exposed by this benchmark with only…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 20 Comments
… with many customers having large number of connections opened in MySQL and although I told them this was not optimal, I… an influence, because those idle threads are presents in internal MySQL list objects that need to be scanned and also the…. I am afraid the same scalability issues affects actives connections although these are also affected by concurrency issues. With new servers having 24…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…. Is it the current performance, future performance, scalability, ability to recover from disasters? We also …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… that we refer back to the previous issue‘s findings, so that we don’t…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… architecture? Is there a way to get more scalability out of your database? Is the database even…Using this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions like… may not work (like the Godfather 3). The issue is people assume that data storage has to…
Page: Presentations
May 3, 2006 By
… This presentation covers some real world scalability performance problems we’ve discovered in MySQL Server, how did we found what… Scaling and Performance Issues in MySQL MiracleAS Database Forum 2003, Denmark Presentation speaks about benchmarking issues and MySQL performance issues and settings. …
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… production, that’s why we did not escalate MyISAM scalability question. This time working on the customer system we…fully fixed by changes done in MySQL 4.1 As Monty explained us in MySQL 4.1 the change to… I’ve created bug, for MyISAM key cache contention issue and lets see if there are any plans to…
