… 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…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… (such as memory). With MySQL common sense however does not always works – we’ve seen performance issues with large query_cache_size… expect such a table_cache issue – the LRU for cache management is classics and there are scalable algorithms to deal with it… problem is not fixed in MySQL 5.1, lets see how MySQL 5.4 behaves. MySQL 5.4.2 MySQL 5.4.2 has…
Post: Announce: Front End Performance Optimization
October 10, 2008 By 8 Comments
… customers with performance, scalability, high availability as the whole, not just MySQL related issues. Indeed if you look at MySQL driven web site its… – being scalable, efficient, highly available, secure and fault tolerant. Caching in particular as memcache plays important role here besides MySQL though quite…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… stats from MySQL and it would be great if we could write these as plugins instead of patches. 2. Be Scalable I’d like to see MySQL Scaling to large amount of CPUs for all… least it should happen for most common cases. Innodb scaling issues are the most common problem (and patches currently available only…
Post: Why you don't want to shard.
August 6, 2009 By 34 Comments
… all workloads. (Yes, I am simplifying some of the scalability issues with MySQL on big machines, but I have faith that Yasufumi is… few very busy tables, and move them onto their own MySQL server. Partition-by-function keeps the architecture still simple… this users data exist on?”. It’s a highly scalable architecture, and once you write scripts to be able to…
Page: Consulting for MySQL
July 31, 2006 By
… you with performance and scalability you’re looking for. Remote DBA Services for MySQL We act as your remote MySQL DBA – manage users… advice and support for MySQL Need choosing Hardware and OS for MySQL ? Performing configuration and troubleshooting platform related issues ? We can help you…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… than MySQL 5.0 with two cores and just 2% slower with 8 cores, thus showing a bit better scalability. MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores… and has less performance – this usually shows synchronization is the issue. Barracuda format uses more CPU while delivering better performance so…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
… global mutex on the KeyCache. Table Locks are not the issue for Read Only workload and write intensive workloads can be…. If you aware of MySQL history you may think Key Cache scalability was fixed with new Key Cache in MySQL 4.1, and… accurate information about table usage I will use Percona Patches: mysql> select * from information_schema.table_statistics where table_schema=’test…
