… 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…
Post: Percona Server and XtraBackup weekly news, March 28th
March 27, 2011 By Leave a Comment
… shortly. For Percona Server, We worked on Solaris builds for the server. Peter proposed a feature for the server to enable more efficient… Nickolay continued investigating alternative methods of implementing flush in Percona Server. (I am involved, but not as deeply.) The task is… ideas about how we could make the flushing algorithm self-tuning in more cases. We will keep you posted. In XtraBackup…
Post: New variable slave_max_allowed_packet for slave servers
July 24, 2012 By 2 Comments
…the max_allowed_packet for the slave servers (IO Thread). Now on a slave server the maximum size of a packet … is 1GB and that means if we don’t tune the variable our I/O thread can read up … more information. En Septiembre voy a impartir Formación de MySQL en Madrid (Sep 3-6). Está será la primera …
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… be done by external script which can have application-specific tunings to prioritize which queries are more important to refresh for… again. The question is whenever anyone from “MySQL Market Players” – Oracle, MariaDB, Drizzle, Percona Server, will allocate resources to implement at least…
