… to really restrict how much resources single user can consume. I have written over a year ago about 10+ ways to crash or overload MySQL and since that people have come to me and suggested more ways to do the same. This… to know you stay up just because nobody wants bring you down rather than because your systems are solid and designed to prevent…
Post: SimCity outages, traffic control and Thread Pool for MySQL
March 16, 2013 By 16 Comments
… month and a few examples of how Thread Pool for MySQL and Percona Server for MySQL can help to prevent such incidents. Users of SimCity… MySQL does not improve the performance magically by itself, but it is rather a protection for cases when MySQL may become suddenly overloaded…
Post: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
… extreme database overload for the customer recently I have found about 80 copies…can prevent it from starting again) or using GET_LOCK function in MySQL. The second one is good if you want to …the table in the database and store information about how long cron took to run. It can also be done by …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…things about objects is you can easily overload > methods and get debugging and …MySQL. Good design will help dictate how many tables are required in order to get the job done. To…to use the indexes to join rows together, potentially preventing a table scan. The trick is to know what kind of JOIN to…
Comment: Adaptive flushing in MySQL 5.6 - cont
September 11, 2012 By 13 Comments
…to happen. Adaptive flushing is supposed to be varying up to innodb_max_io_capacity (which is being renamed to innodb_io_capacity_max) to prevent…overload if it happens in production we do want to handle it gracefully. Glad to…
