One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. … you need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing… will suffer. So what you can do to prevent this problem from happening ? The answer is easy. Throttle the side load…
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By Leave a Comment
… research to be frequent, severe, or subtle causes of problems in MySQL systems. They are intentionally not generic because I wanted to…, and I believe it should help avoid some of the common problems such as spammy alerts. There is one “generic, flexible” plugin… of status counters and variables. This is the pmp-check-mysql-status plugin, which can perform computations on status variables. By…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… painful troubleshooting tasks with MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use reasonable global… MySQL takes much more memory than you would expect, causing swapping or other problems. This simple problem on the surface becomes challenge with MySQL… grow even if you close connections and tables regularly. Another common thing about memory leaks is because it is memory which…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… isolation level (considering only the two most common isolation levels, REPEATABLE READ and READ COMMITTED). …(non repeatable reads) so in order to prevent problems with the replication you should change the ….1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation …
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… would say MariaDB is seriously underrepresented on places like planet mysql. (Ie possibly real MariaDB usage must be higher than what… is closing MySQL source code.) Personally I don’t see the problem distros have with the MySQL model. Contrary to common belief MySQL maintenance releases…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…-running transactions, or other problems. The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as… and a couple other types of common problems, too. Missing PID file. A variety of problems can delete MySQL‘s PID file, such as… to monitor more types of problems, but the current plugins already cover some of the most common and severe conditions that we…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… them separately. Running MySQL won’t be much different whether one or another distribution is used. All use common Linux kernel – the… are so common that it’s just beyond simple negligence. The packaging system is just not robust enough. Another problem is that… problem – chances are that fixing this with ‘dpkg –configure -a’ would cause MySQL to shut down. The MySQL package scripts for Debian force MySQL…
Post: Stripped MySQL builds, the optimization that isn't
December 7, 2010 By 7 Comments
I usually tell people to use official MySQL builds from MySQL, or from their operating system distribution if they don’t … idea. Most “optimized” builds really aren’t. One of the common problems I see is that a lot of them, including sometimes…, it’s far too easy to subtly mess up a MySQL build and really end up with a problem.
Post: A common problem when optimizing COUNT()
September 20, 2008 By 18 Comments
… do with COUNT(). This is database-agnostic, not related to MySQL. The problem is when the COUNT() contains a column name, like… result is the same as the number of rows. The problem with that is that you don’t know by looking…
Post: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
… servers, whose cnf’s were put together by highly trained mysql certified dba’s. So what’s changed in the new… lot of sanity/safety options to prevent common problems MySQL users run into because of too-permissive MySQL behaviors. These are the kinds of… that Drizzle fixes — and should be fixed by default in MySQL — but never will be because they might break applications that…
