What Privileges Does EXPLAIN Require in MySQL?
07/28/14 Here’s a simple question that I wasn’t able to solve with Google or the MySQL documentation (which is normally excellent). Perhaps it’s mentioned somewhere, but I can’t fi…
07/28/14 Here’s a simple question that I wasn’t able to solve with Google or the MySQL documentation (which is normally excellent). Perhaps it’s mentioned somewhere, but I can’t fi…
07/25/14 One of our most useful features is Top Queries, which allows users to examine various metrics for families of similar queries. Once a query family is selected, we can dril…
07/21/14 When you send a query to MySQL, you usually don’t need to think explicitly about the types of the expressions in your query. If you compare this to a lot of programming la…
07/10/14 While writing our TCP stream reassembly and MySQL protocol reverse-engineering algorithms, a few finer points of the MySQL protocol and internals came up. None of this is …
07/01/14 Looking back, I find object-oriented programming in languages like Java and C++ to be incredibly confusing. There are so many special rules and things to know. By contrast…
06/23/14 The MySQL wire protocol includes useful result data and metadata, such as warnings and errors raised by the query. These often indicate bugs that will cause problems you m…
04/24/14 We get a lot of questions about what our Adaptive Fault Detection algorithm really is and how it works. Although I can’t tell you exact details, I want to explain a few th…
04/24/14 We’re Hiring! VividCortex has several open positions, both technical and non-technical. All of these positions are fulltime, based in Charlottesville, VA or Montevideo, Ur…
04/16/14 We use Google Hangout all the time to conduct calls with employees, service providers, customers and pretty much anyone. It’s a great tool, and in our opinion more friendl…
03/26/14 When it comes to disk configuration options for virtualized servers running on VMware, you have two options: VMFS virtual file-based disk (VMDK) or a raw device mapping (R…
03/17/14 For years, people lamented that MySQL’s replication was single-threaded. Peter, Vadim, and I griped about this in High Performance MySQL for two whole editions, as well as…
02/25/14 Peter Zaitsev posted Percona’s answer to the question, “why use the slow query log instead of the PERFORMANCESCHEMA tables to gather information about query execution and …