CentOS5 and PHP52 upgrade rpms
We encounter many scenarios where using the latest version of PHP is required. No great way, aside from downloading the PHP5 source and compiling, is available. That is, until you discover then IUS Community Project.
Read moreMySQL Backup User Privilege Grant
LOCK TABLES and SELECT are the minimal requirements to use ‘mysqldump’. You can use the following grant statement to create a user with as little privileges as possible:
Read moreMySQL performance tuning
This document serves as a starting point for MySQL performance tuning. This document is a combination of research and experience. When I started this document, I utilized a great Google video [1] as a reference for the document structure and many bullet items. I would suggest watching this video. I then filled in a few [...]
Read more