Isolate Slow MySQL Processes

Even the best MySQL implementation will sometimes have problems with processes taking too long and hogging the CPU and memory. This will have a knock-on effect on any other processes running on the server and can have a significant effect on performance. In an ideal world, you could just increase the resources available to the…

Automating MySQL Database Backups

One of the most critical tasks for a MySQL administrator is reliably backing up and restoring databases. This, of course, helps to prevent data loss in the event of a hardware failure, data corruption… or a little accident. Most modern hosting/server solutions have some kind of database backup solution available. However, many people prefer to…

PHP Tips and Tricks

PHP: Hypertext Preprocessor is a scripting language that is a great tool for web developers to use when they want to produce dynamic web pages. Embed your PHP code into the HTML source and the PHP processor on the web server interprets it and generates the web page document. It does not matter if you…

Hide PHP Usage

If you are the web developer for a site, then you might not want visitors to know that you are using PHP for your scripting. One simple way around this is to use a different extension for the PHP files instead of the default .php. You can use any extension that you want including: .htm…

Send an email from PHP

It is common now for developers to use email as a means of communicating with users from the web site. There are many reasons that you might want to do this including: Confirmation of user action Password reset Send error logs to site administrator Before you start to configure your PHP scripts to send email,…