… performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is… you have system completely at your disposal. If you however need system to serve other users too you typically need to reduce concurrency to where it does not overload the system. Unless it…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…running MySQL in wild. I also wanted to share some troubleshooting techniques I use. Plot Memory Usage First I would like to see MySQL… allocating memory from operation system directly not from addition …MySQL, MariaDB or Drizzle bring improvements in this space allowing us to see directly for what…
Post: How We Got Here
April 9, 2012 By 6 Comments
… now, and what we have planned for the future. The annual April MySQL conference was a … MySQL conference, bar none. Attendees will hear from people who use MySQL in production systems and know how to operate… and thought leaders to meet and network with tomorrow’s. We will continue to run this and …
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… install bases are large enough to mention them separately. Running MySQL won’t be much different …manually run ‘dpkg –configure -a’ to correct the problem. While everyone should stop and check what …operating system. You will have to choose between RedHat or SuSE. Another such case can be related to…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
…MySQL upgrade – version change but in a lot of cases this will happen when settings are changed at the same time, operating system…system warming up. You need to compare apples to apples such as both systems after restart or even better both systems fully warmed up. To spot what…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… MySQL Upgrade to new version while sticking to very old operating system is important for you ? Finally I’d like to know What is the Oldest Platform/Operating system are you running MySQL on…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… to 10% of theoretical memory consumptions others only to 1%. So what…Operation System cache you would like MySQL to use for your table. Take this number add to it number of memory Operation System…to run MySQL server out of memory MyISAM buffers. MyISAM may allocate buffer which is large enough to…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… in the replication traffic (what updates are being replicated) are frequent cause of concern. Remember replication runs as a single thread and… going through the same operating system you should be able to see it by comparing IO MySQL is doing to IO going to devices from OS standpoint. If this is external and not recorded by operating system you often…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
…” MySQL the numbers are not that high – many what would be considered medium scale MySQL installations would get there. With MySQL we seems to prefer to run…, yet as MySQL is getting better and better handling large scale systems (both in terms of performance and operationally) and as MySQL is making…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…operation per second which takes 4ms which adds up pretty well. We can also see what…system which can run 1000 IOPs costs $500 to run per month (including leasing, power etc). Such system will be able to…
