As we know in the hosting industry there are many people who rely on MySQL but know, and don’t wish to know, next to nothing about MySQL. Yet slow queries are indiscriminate about who they afflict. I think what bothers non-technical users the most about slow queries causing problems in MySQL is a feeling of helplessness. Unlike a car which pretty much anyone can do the regular maintenance, MySQL maintenance isn’t so clear, even less so when the issue is query optimization. This document is meant to be a facilitator between the non-technical MySQL user with slow query problems, and a MySQL expert who can help them. The information here is to help the non-technical user at least get a handle on the situation, and not feel so helpless. From there, a MySQL expert can more easily take over and fix the issue.
(more…)
March 31, 2008
Isolating Slow MySQL Queries
Install MRTG on RH9 in 10 Easy Steps
This Howto work on a cpanel machine. Was tested on Rh9, FC2, FC1
1: rpm -e mrtg
2: rpm http://download.cheetaweb.com/mrtg-2.9.17-1cpanel.i386.rpm -Uvh
3: cd /usr/lib
How-To: Mod_Security
Mod_Security
This guide is going to show you how to install and configure mod_security which will help protect your server from exploits that are passed though apache. Mod_security does this by inspecting the information sent in apache and filtering out all of the “bad” requests as determined by the set of rules specified in the httpd.conf.
How-To: Secure your /tmp directories
How-To: Secure your /tmp directories
Every system needs temporary folders that any user is able to read and write BUT these directories should not be able to execute programs or scripts. Though this will only protect you from somebody running the script directly it will help with a large portion of the automated rootkits and trojans that script kiddies use.
Configure APF Firewall
Configure APF Firewall
A firewall is a very good idea for a server. Though many people think that a firewall is instant protection that will do everything it really is not. A firewall will help prevent some things but it is not going to stop everything.
