June 19, 2013

Post: Using flow control functions for performance monitoring queries

I’m not big fan on flow control functions like IF or CASE used in MySQL Queries as they … such grouping by user functions because otherwise you will not catch important but may be less used functions performance problems. Another thing…

Comment: Using flow control functions for performance monitoring queries

… example a retrograde thinking: “I’m not big fan on flow control functions like IF or CASE used in MySQL Queries as they… in such way that will handle well those if/case control functions. It’s time for MySQL RDBMS to evolve.

Post: An update on Percona Live MySQL Conference & Expo 2012

… much harder task than it seems. But that’s under control. Fortunately, we have three great people here at Percona working… juices flowing, and submit those session and tutorial proposals on DRBD, partitioning, community toolkits, security, using MySQL with NoSQL, geospatial functionality, cloud…

Comment: Using flow control functions for performance monitoring queries

… be optimized as well as equivalent set of queries without flow control functions.

Comment: Using flow control functions for performance monitoring queries

IF(cond, 1, 0) is the same as (cond) in MySQL so flow control functions are not necessary in this article :-) .