May 24, 2012

Post: MySQL for Hosting Providers - how do they manage ?

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: Watch out for your CRON jobs

… 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

…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. Toto use the indexes to join rows together, potentially preventing a table scan. The trick is to know what kind of JOIN to