… not big fan on flow control functions like IF or CASE used in MySQL Queries as they are often abused used to create queries… by MySQL Optimizer. One way I find IF statement very useful is computing multiple aggregates over different set of rows in… otherwise you will not catch important but may be less used functions performance problems. Another thing you may notice I look…
Comment: Using flow control functions for performance monitoring queries
May 28, 2008 By 12 Comments
… not big fan on flow control functions like IF or CASE used in MySQL Queries as they are often abused used to create queries… in such way that will handle well those if/case control functions. It’s time for MySQL RDBMS to evolve.
Comment: Using flow control functions for performance monitoring queries
May 24, 2008 By 12 Comments
The flow control technique to control the monitor seems to be cool. I will surely learn to operate the monitor using this technique.
Post: MySQL net_write_timeout vs wait_timeout and protocol notes
July 8, 2007 By 1 Comment
… however comes back in multiple pieces and if you’re using mysql_use_result you can do any work between fetches, which… idea. This for example typical cause of aborted connections while using Sphinx with large data sets and large buffers. While indexing… side. You could ask why server does not do any flow control and can’t find out client just is just busy…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…’ s have a look first at the normal flow: Replication flow: [1] When you setup MySQL replication, …can cause failover if you stop replication # mmm_control @production set_passive (to avoid automatic failover) 2…all the statements that were in the loop using mysqlbinlog. For example what was the loop …
Post: MySQL Releases first real Community Release
March 18, 2007 By 2 Comments
…but I hope the patches will be continue to flow in. In fact we have submitted our slow …be accepted for inclusion. How good will be quality control This is another scary thing for me. For … may be organized. Another good thing – unless you used some specific community features you should be good …
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… much harder task than it seems. But that’s under control. Fortunately, we have three great people here at Percona working… do super-advanced and extreme things with MySQL, how to use MySQL for a Ruby on Rails application with MongoDB and… get your creative juices flowing, and submit those session and tutorial proposals on DRBD, partitioning, community toolkits, security, using MySQL with NoSQL…
