mobile logo

Posts tagged Mysql

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. What is the IUS Community Project? The IUS Community Project is an effort to package rpms of the latest stable versions of the most commonly requested software on Red Hat Enterprise Linux and CentOS.   IUS provides a better way to upgrade PHP/MySQL/Python/Etc on RHEL or CentOS.  The project is run by professional Linux Engineers that are primarily focused on RPM Development in the web hosting industry. What …

Read More

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: GRANT LOCK TABLES, SELECT ON mydatabase.* TO 'backup'@'hostname' IDENTIFIED BY 'p4sswOrd';

Read More

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 blanks, and combined a few other articles into this overview. You may also want to check out this good article from MySQL on performance tuning.. Now onto the show.. Benchmarking As with all improvement activities, it is better to start with a known problem area that …

Read More