One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. … are overloading the system causing user experience to degrade. The first thing you need to know it is not MySQL problem, might…. This is true if you have system completely at your disposal. If you however need system to serve other users too you…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… what hardware and operating system I’m working with. System performance Next I investigate what the system is doing, in terms of performance. There are two…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…good” change as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the…lag. Same may happen with operating system and other system software involved. In could be even system which queries mysql. I’ve seen monitoring updates…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
…these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and …onto the local disks, for example — the more operational complexity and cost you have, so that’…LVM snapshots, in terms of impact to the system‘s performance and ability to mount them on other…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… used. All use common Linux kernel – the heart of Linux operating system – which in principle will behave the same way in all… may carry new features or slight performance improvements, however these days it is rarely important to MySQL users. If it is to…, is for example a requirement for commercial support for the operating system. You will have to choose between RedHat or SuSE. Another…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… instead of expected performance improvement you see your performance being worse. What should you do ? First if you followed MySQL upgrade best practices… MySQL upgrade – version change but in a lot of cases this will happen when settings are changed at the same time, operating system…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… when you see old MySQL versions are used is typically when application is not overly demanding so performance improvements in recent releases… an option to upgrade operating system as well Or is MySQL Upgrade to new version while sticking to very old operating system is important for…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important part in your system performance or it… RAID1 volume for Operating system and another one for Transactional Logs you will often wast 4 hard drives from performance standpoint without a…
Post: MySQL Performance Engineer opening
May 13, 2008 By Leave a Comment
…we love to analyze performance of various MySQL features, benchmark, compare, analyze things and post our findings on MySQL Performance Blog. However recently …an “X-Ray vision” understanding what happens on all layers (MySQL, Operation System, Hardware) when for example row is being inserted into …
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… to /var/lib/mysql (datadir) on my system (Ubuntu). You might be lucky and it might work in your system. I also enable… same operating system. This is important. There have been many changes to core file handling on Linux and what worked on one system… if you expect to do any MySQL profiling or dealing with crashes. It does not slow MySQL performance yet it is very helpful…
