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
May 28, 2008 By 12 Comments
… 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.
Comment: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… be used in a web environment. PHP manual says: Process Control support in PHP implements the Unix style of process creation…. Process Control should not be enabled within a web server environment and unexpected results may happen if any Process Control functions are used…
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
In MySQL 5.0 mainly error control was improved, such as strict mode was added to change … you might not notice part of your application does not function. Also monitoring often monitors MySQL is up and running and…
Comment: Using flow control functions for performance monitoring queries
May 28, 2008 By 12 Comments
… optimized as well as equivalent set of queries without flow control functions.
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 
.
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… implements Global Resource Management as otherwise you can’t really control how much resources user can takes. You would say resource… reduce system performance beyond being functional. General Overload As MySQL does not have much of resource utilization control you can simply run heavy queries to get MySQL Server barely functional. The limits which exist…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… as every minute, perhaps. The refresh method you select effectively controls the minimum amount of time it takes to refresh the… N** N*** Y *All aggregate functions supported, except GROUP_CONCAT and AVG(distinct). **non-deterministic functions like RAND(),NOW(), etc, are not… SQL is dynamically generated by the flexviews.get_sql() function call. This function reads the meta-data stored in the Flexviews data…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
… and is quite easy – it is trivial to write the function which will take SELECT query and the table to which… in your application in all cases when you need this functionality. Finally you should not overload your replication – Quite typically I… enough breathing room for replication thread. You can also have controlled execution of batch job – this is when they will check…
Post: Worse than DDOS
August 18, 2008 By 5 Comments
… interesting lessons one can learn from it. Implement proper error control In reality it took some time to find what was… easier to find. User Curl PHP Has a lot of functions which can accept URL as parameter and just fetch the… to match your application needs. If you’re using PHP functions make sure default_socket_timeout has proper value or set…
