Partition Tables in MySQL

One of the big deciding factors in the performance of your database is the design of the database. Research from various parties, including Oracle, has found that poor database design is a major factor in poor database performance and unscheduled system downtime. One great way to improve the performance of your MySQL database is to…

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 is a widely-used scripting language that allows web developers to produce dynamic web pages with ease. By embedding PHP code into the HTML source, developers can create web applications that can interact with databases, perform complex calculations, and generate content on the fly. Whether you are an experienced PHP developer or a beginner, there…

More Ways to Hide PHP Usage

There are a few other methods that you can use to hide your usage of PHP from visitors to your website. Another trick is to use filenames without extensions and then tell Apache to process them as a PHP file. This can be done easily by amending your .htaccess file to include the following lines:…

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: You…

Send an email from PHP

It is common now for developers to use email as a means of communicating with users from the website. There are many reasons that you might want to do this, including: Before you start to configure your PHP scripts to send emails, you will first need to know some configuration settings for your email system….