… or Operations of growing application sooner or later have to decide on couple few questions on how to tackle application performance. These… have 100 MySQL servers to deal with even modest 10% can save you $100K in hardware cost and $2000 a month in operating costs… – even if your local resources have created the system which performing well getting experts which may have ideas how to optimize…
Page: Consulting for MySQL
July 31, 2006 By
…MySQL Performance Optimization and Scaling – All aspects of MySQL Performance Optimization and Scaling Consulting – Hardware and OS configuration, MySQL…
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
With Performance Schema improvements in MySQL 5.6 I think we’re in the good shape with insight on what is causing performance bottlenecks as… very hard to ensure the memory consumption by various database operations is reasonable. For example if some INFORMATION_SCHEMA query were… after operation is completed. What I would like to see is similar to Performance Schema “wait names” we could get something similar in…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
…reason… with essentially zero impact to the end user. The performance problems are also handled different way – the load balancer …operational state. Conclusion: If you’re looking for setting up HA solution for MySQL check out synchronous replication based solutions in additionally to MySQL…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…how should they estimate memory consumption by MySQL Server in given configuration. What is the formula… configure MySQL Server so it uses too small amount of memory it will likey perform suboptimally….for given thread, however if table will perform complex operations such as full table scans, sorts,…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… they explore many less tested code paths in MySQL and so problem potential is larger. So … care of or which may seriously affect MySQL Performance. MyISAM Corruption – If you’re writting to … happen, not to mention such potentially multiple operation DDL statements as RENAME TABLE – these are most…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… in MySQL < 5.5.23 used to work. When dropping the table, a mutex on bufferpool would be held for the entire operation… corresponding to the table being dropped. Following are the steps performed in this function: Take a mutex on the LRU list of… meaning that only the entries in the flush_list should be removed. Following are the steps performed in this function: Loop while all…
Post: Tutorial Insights for Percona Live, London
August 24, 2011 By Leave a Comment
… picked number of them after seeing outstanding speaker Performance in other Places. Let me tell in little bit more details about people we…familiar with very in-depth engine operation and when moving to consulting and having lots of practical experience deploying and operating MySQL Cluster, finally…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… should expect from the system. What I usually look for MySQL is performance in random reads and random writes. Sequential reads and writes… random read test Threads started! Time limit exceeded, exiting… Done. Operations performed: 773835 Read, 0 Write, 0 Other = 773835 Total Read 11…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… typical operations patterns used in Social Networking web applications and analyzing how to implement them most efficiently with MySQL. MySQL Performance Landscape This presentation compares MySQL Performance with different CPUs, Operation…
