…single-server Innodb, we’d get: [On a single node Innodb server]…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…much faster. I see this tuning very frequently for “performance” …of times specified by this variable (default is 1 retry). This …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… 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 21 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 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…query: mysql [localhost] {msandbox} (test) > select var55.variable_name,left(var55.variable_value,40) value55, left(var56.variable_…for higher concurrency workloads. Makes sense as servers have a lot more cores available these …one of the component of purging fine tuning in MySQL 5.6 innodb_file_per_…
Post: New variable slave_max_allowed_packet for slave servers
July 24, 2012 By 2 Comments
…servers (IO Thread). Now on a slave server the maximum size of a packet is checked against this variable and not max_allowed_packet. The default value is 1GB and that means if we don’t tune the variable…. En Septiembre voy a impartir Formación de MySQL en Madrid (Sep 3-6). Está será …
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: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… will be doing fine tuning for our Percona Server for MySQL version 5.6 release. Another thing to remember about MySQL 5.6 is…. Granted I have not tuned MySQL 5.6 for best performance going with defaults outside of few variables MySQL Sandbox sets explicitly but yet this is likely course of action for many MySQL users out there…
