… set however comes back in multiple pieces and if you’re using mysql_use_result you can do any work between fetches… side. You could ask why server does not do any flow control and can’t find out client just is just… you’re fetching data because there is buffering happening inside MySQL client library so you never know when real network read…
Comment: Using flow control functions for performance monitoring queries
May 26, 2008 By 12 Comments
IF(cond, 1, 0) is the same as (cond) in MySQL so flow control functions are not necessary in this article 
.
Comment: Why MySQL's binlog-do-db option is dangerous
July 24, 2012 By 15 Comments
Erik – there are flow charts at http://dev.mysql.com/doc/refman/5.1/en/replication-rules-db-options.html – so if it’s not following the rules of that flow chart (it seems not to be following those rules) then you should file a bug at http://bugs.mysql.com.
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
… software development. (Thanks to you, too!) If you would like Percona to create custom MySQL features or builds for you, please contact… example: wouldn’t it be great if there were a built-in type in MySQL that could store date and time with… a reality. Where It All Begins Our open-source efforts flow from our company values. We believe that software and information…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 15 Comments
… Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was impressed as I personally always wanted… after PPC 2009 there was available version mysql-galera-0.6, which had serious flow, to setup a new node you had… you write to, your transaction rollback rate may increase, especially if you working on the same dataset. You can find some…
Comment: Apache PHP MySQL and Runaway Scripts
May 21, 2008 By 20 Comments
… is quite close to MySQL case – if client is gone SELECT * FROM tbl; will be aborted virtually instantly while if temporary table or… normal flow. Also note there is RST packet sent by the browser if user clicks STOP. It should be possible to check if… do it – which is good thing to keep in mind. MySQL SLEEP() function is indeed great for bringing down sites with…
Comment: Using flow control functions for performance monitoring queries
May 28, 2008 By 12 Comments
…: “I’m not big fan on flow control functions like IF or CASE used in MySQL Queries as they are often abused used… can hardly be optimized well by MySQL Optimizer.” Well, in this case, how about convincing MySQL AB/Sun to write a real… Query Optimizer in such way that will handle well those if/case control functions. It’s time for MySQL RDBMS to evolve.
Comment: Resyncing table on MySQL Slave
July 1, 2008 By 11 Comments
… MySQLHotCopy however this makes the process much more elaborate if you have traffic flowing as you need to ensure the table is… it is not always installed. If you just want to do things once using Stock MySQL tools that is what I mainly…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…evaluated switching to InnoDB. Performance vs. MySQL was horrible, even after tuning. SELECT performance is crucial and… of files. The show stopper was restore of tables. If we needed to do a restore of any table … looking for (at least that seems to be the flow of things to be done for such). In our …
