…MySQL server or causing all the connections to get depleted. There are some other interesting consequences as well for application that use MySQL…
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
… be replaced/overwritten during an update by simply keeping package folders on unique directories. Lastly, running your MySQL server from pre-built binaries… for when troubleshooting for problems and not spend too much time on switching, rather focus on the problem. While some of… provided a perspective. Now, how do you prefer your MySQL server installed? UPDATE: Peter and Sergei suggested on the comments that 3rd party…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight…. Check however if all of key_buffer is used over time – it is not rare to see key_buffer being set… updates. Value 0 is a bit faster but is a bit less secure as you can lose transactions even in case MySQL Server…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… which runs this query concurrently many times or even workload consisting of several query…server” where you can analyze it without side load. Setting up 2 MySQL Servers side by side (for example with MySQL…plan from optimizer standpoint and updating stats may cause old MySQL Version to get slower …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… Percona Server. Another great thing about Percona Server is the ability to enable logging atomically, not just for new connections as in MySQL… were using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02:26….1956 2.4% 89 0.0022 1.00 0.01 UPDATE wp_options # 7 0x7AEDF19FDD3A33F1 0.1381 1.7% 909 0…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
MySQL Server has tons of variables which may be adjusted…) of tables after query is complete or every flush_time seconds. This is technically variable which affects all …this feature. low_priority_updates If enabled selects will get higher priority than updates and waiting update will not stall all…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… and we change it in run time we can’t detect such change easily because MySQL Server does not seems to have an easy way to check what was the default value for given Server Variable…-size 8192 transaction-isolation REPEATABLE-READ transaction-prealloc-size 4096 updatable-views-with-limit YES userstat FALSE verbose TRUE wait-timeout…
Post: Percona response to recent MySQL security bugs
December 6, 2012 By 2 Comments
… Percona Server. Usually we have inherited security fixes from MySQL when we have updated Percona Server to be based off a new Oracle MySQL release… mailing list threads Open Query blog post on MariaDB updates Sergei Golubchik (long time MySQL developer, current MariaDB developer) responds on oss-sec…
Post: CVE-2012-4414 strikes back in MySQL 5.5.29 (and what we're doing in Percona Server 5.5.29)
January 13, 2013 By 4 Comments
…important, it means that anyone can verify if their MySQL server is vulnerable, after all, many people run their … fixes is really just a waste of Oracle time and money rather than anybody else’s. However, … test case against my branch that updated Percona Server to be based on MySQL 5.5.29 and I …
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… running MySQL from early beta (if not alpha) and update MySQL the same date as release would hit the web. Since that time I matured and so did MySQL ecosystem. MySQL is powering… estimate more people running on MySQL or Percona Server 5.1 than 5.5 Facebook also sticks with MySQL 5.1 even though…
