…MariaDB as compared to MySQL? A lot of things. Here are some of the highlights: Pluggable authentication…tables in joins Thread pooling and a segmented key cache for improved scalability That’s really … now have more choice than ever — there are three great versions of MySQL that suit different needs…
Post: Three key things to know about moving MySQL into the cloud.
July 13, 2009 By 11 Comments
… technical perspective there isn’t much that changes. The biggest thing that changes is just how you pay your bill. Having… battery backed write cache. If you can live with these three things, then hopefully your migration should work smoothly. If you…
Post: EXPLAIN EXTENDED can tell you all kinds of interesting things
June 15, 2010 By 7 Comments
…EXTENDED, I’ll start with three empty tables. It is … | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +—-+————-+——-+——–+—————+——+———+——+——+——-+ … set (0.00 sec) The most important thing to notice is the WHERE …
Post: Three ways that the poor man's profiler can hurt MySQL
December 2, 2011 By 19 Comments
… technique of using GDB as a profiler has become a key tool in helping us analyze MySQL when customers are having… go well. Getting GDB backtraces is pretty intrusive. Here are three things that I’ve witnessed: The server freezes for the duration…
Post: Announcing Percona Live MySQL Conference and Expo 2012
August 9, 2011 By 11 Comments
… their conferences. The key things they did to involve the community, such as creating a speaker committee, are things we’ll be doing too. I was on that committee three times myself. We’ll have…, and so on. This isn’t just a feel-good thing — it is what made the MySQL conference such a vibrant…
Post: Give me 8 hours, and I'll help you build a better application
August 29, 2009 By 4 Comments
… ways. If you are not doing any of the following three simple things, you probably should. These are essential practices for building… Everybody should have an automated monitoring system that is watching key elements of their systems. This can be very simple, even… something really does go wrong. Keep it simple and monitor things that matter to your business: does the website load in…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…at “real-time.” None of the big three (Google, Yahoo, MSN) provides real-time reporting … There are already inconvenient limitations on some key parts of partitioning, such as maintenance and repair… Don’t get fooled into calculating the wrong thing. Be Creative With Table Structures Suppose you …
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… default tuning, out of the box, for all three databases. The first thing I tried doing was loading the data with SQL… bhloader. This bhloader program was the only thing doing anything; mysqld wasn’t doing a thing. LOAD DATA INFILE in Infobright isn… is no REPLACE, and there is no INSERT/ON DUPLICATE KEY UPDATE.) I didn’t try the XQuery interface. Although I…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…) From this, I can see a couple of important things. One thing is that I’m looking at a 64-bit OS… be other ways to get this information, too. The last three commands are for giving me information about LVM devices, volume… of other things I’ll look at, including checking for default users in the mysql.* tables, running mk-duplicate-key-checker to…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… and conclusively with no guesswork. The key is to use a logical approach and…part of the Aspersa toolkit. There are three primary tools for troubleshooting intermittent problems: stalk,… tolerate. THRESHOLD=${THRESHOLD:-100} # This is the thing to check for. VARIABLE=${VARIABLE:-Threads_connected…
