… with balancing – allocating resources to different storage engines and performance tuning becomes more complicated. Now what is interesting for probably 95… what we could have if we have a version of MySQL Server which drops everything but Innodb Storage engine (it could be… WITH READLOCK” and hoping nobody is touching “mysql” database any more. Single Storage Engine server would be also a lot easier to…
Post: Announcing Percona Server for MySQL 5.1.68 -14.5
March 15, 2013 By Leave a Comment
… solution, Percona Server for MySQL is an enhanced drop-in replacement for MySQL, offering breakthrough performance, scalability, features, and instrumentation. Self-tuning algorithms and… demand excellent performance and reliability from their MySQL database server. Compare Percona Server to MySQL. Performance Percona Server‘s performance is exceptional. Not only is…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
…,513 NOTPM, Percona Server – 30,436 NOTPM, advantage: 1.29x 52GB: MySQL 5.5.8 – 71,774 NOTPM, Percona Server – 88,792 NOTPM, advantage: 1.23x 144GB: MySQL 5.5.8 – 78,091 NOTPM, Percona Server – 109,631 NOTPM… choice for if you are looking for high MySQL performance, and we tune Percona Server to get the most from such hardware. Actually…
Post: Announcing Percona Playback 0.5
November 26, 2012 By
… database server to another. Currently it can read queries from MySQL query-log and tcpdump files and run them on other MySQL server. With Percona Playback you can measure how a server or… can use this information to decide if the test server needs further tuning or how it will be able to sustain production…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… server during its lifetime comes down to this rather boring process – install, configure, tune, start/stop MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL… start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL version might just be the most critical operations you ever do once server is moved…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… meta data to be lost. Not good for system running mySQL Server. As far as I understand this problem is limited to… to MySQL/Innodb it will assert and restart. Now lets look at couple of other options you might want to tune with… is probably not needed for partition you store MySQL data on, as chances are MySQL server is only one doing writes on this…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
… 50 microseconds, maybe a bit longer. This is common in MySQL servers I work with when they’re running a simple read… off sharply, because all the application servers that would normally be sending queries to the server would be stopped, waiting for existing… place where we get some “static”, sort of like de-tuning the radio just a little bit (if you remember analog…
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
… compare it to technologies in MySQL space. First I think MongoDB is best compared no to MySQL Server but MySQL Cluster, especially in newer… node failure and at least 3 servers is recommended, where you can have some voting servers only cast their votes and hold… set of server not one of them and if one server fails driver fails over to different master. Things are again tuned to…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
… will see in MySQL performance in this scenario? Let me share a conclusion first: If you have a server with more than… the query processing. I believe that both allocators can be tuned to handle such cases better – for instance allocate more arenas… should try/evaluate alternative allocators; it can notably boost your MySQL server at no cost. Also, an alternative allocator must be used…
Post: MySQL Sizing questions
June 23, 2006 By 4 Comments
… lines of “how many transactions per second MySQL can do” or “how many servers I need to handle 100.000 users” or… in MySQL Consulting practice it would not be exception to have 1-2 orders of magnitude performance increase just by proper tuning… they be able to run their whole orders from single MySQL server. Of course not, because their application is a lot different…
