… and discuss in detail a common problem or idea. Sessions will be selected by the Percona Live MySQL Conference and Expo Conference Committee…, and projects that are part of the MySQL ecosystem. Located in the Percona Live MySQL Conference Exhibitor Hall, the DotOrg pavilion will… presentation on the state of the MySQL ecosystem. Be sure to visit the Percona Live MySQL Conference and Expo 2013 website regularly…
Post: Deadline Near for BOFs and Lightning Talk Submissions for Percona Live MySQL Conference
February 7, 2013 By Leave a Comment
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…
Post: What Causes Downtime in MySQL?
March 21, 2011 By 10 Comments
… contradict the urban myth that bad SQL is the most common problem in databases. There are a number of surprises in other… my earlier white paper suggesting ways to prevent emergencies in MySQL. It is a re-published and re-edited version of… SELECT magazine. You can download it for free from the MySQL white papers page on the Percona web site.
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… could be one common example. Sometimes it is not fault per say but operating mode change may cause the problem. Many RAID…” change as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most… Master-Master setup is often cause of the problem for similar reason as MySQL Restart – the traffic on different boxes might be…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… at least it should happen for most common cases. Innodb scaling issues are the most common problem (and patches currently available only fix part of it) but far from being only problem. There are fair… One of the most common buzzwords used together with MySQL is Scale Out, but to say the truth MySQL does not provide much…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… used very wastefully compared to its potential. The first glaring problem is single-threaded replication. It is severe and getting much… a few I’ve seen: Use DRBD replication instead of MySQL replication. Problem: you end up with an idle standby server, which… work well in some cases, such as when deadlocks are common; but it is overall the least disruptive or different from…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… will most likely able to repeat the problem by running query on old and new MySQL Server version and observing the difference… are the same. Changing Query Execution plans is the most common regression problem. If plan has changed check if you can get… or report the problem through MySQL support channel if often helps to know whenever it is the problem in stick MySQL changes between versions…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 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: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
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: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
The performance problems caused by battery auto learning go many years back. We wrote about it, other people from MySQL Community too… dramatically affected by this setting. First I should wonder how common this problem is outside of Dell product line ? (Which is using… done without server restart with Innodb Plugin, Percona Server and MySQL 5.5. Note it might also be good to increase…
