… work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight… many servers are where in wild which are running with default settings. Even though you can tune quite a lot of variables in MySQL Servers… normally leave per session variable tuning to second step after I can analyze workload. P.S Note MySQL distribution contains bunch of sample…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…MySQL Server code and various small static buffers. This is memory which you can consider used when you just start MySQL Server…tuned as buffers. Watch for these especially now with many storage engines being released for MySQL…consumption reacts to changing various variables. For example you may find…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…any level of tuning, from completely untuned… in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+…MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
…MySQL Variables Tuning This session takes practical approach to MySQL variable tuning. Instead of giving you theoretical guesses on what would be right variable…
Post: MySQL Sizing questions
June 23, 2006 By 4 Comments
…MySQL Consulting practice it would not be exception to have 1-2 orders of magnitude performance increase just by proper tuning…run their whole orders from single MySQL server. Of course not, because their application… number of items plus few more variables and very well estimate hardware requirements…
Post: MySQL Session variables and Hints
December 28, 2006 By 2 Comments
MySQL has two ways to find tune execution of particular query. First is MySQL Hints, such as SQL_BIG_RESULT,… are used much more frequently than setting session variables for given query execution even though it also …. It also requires more round trips to the server but it is not that critical as it …
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
… In other words, there will be a steady but variable “white noise” of incoming requests, and most requests …microseconds, maybe a bit longer. This is common in MySQL servers I work with when they’re running a …where we get some “static”, sort of like de-tuning the radio just a little bit (if you …
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… also get query_cache_ttl as session variable, which is very helpful for connections …external script which can have application-specific tunings to prioritize which queries are more … is whenever anyone from “MySQL Market Players” – Oracle, MariaDB, Drizzle, Percona Server, will allocate resources to…
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 17 Comments
… size to allow MySQL to handle spikes. Although MySQL connections are quite… be refused. What back_log variable specifies is second parameter to listen… understand your application workload and tune specifically to your needs. This… and potentially connecting to different server, but that can be fixed…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… moving the application. On reasonably tuned applications when further tunings are expensive you may well upgrade …you would just need another server a bit later. However if you have 100 MySQL servers to deal with …As project moves to the higher end another variable comes into the play – even if your …
