It does not matter how well you can write queries in MySQL; if the underlying schema is not optimized, it will slow your database performance down. This is not just removing unwanted fields, but you need to make sure that your fields are storing data with the correct size. One example of this is a…
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…
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…
One of the best ways to check the performance of your MySQL application is to benchmark it regularly. Put the application under as much load as you can to simulate the worst possible reasonable load and check the performance. Several functions within MySQL can help you to test your databases. One of the most useful…
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…
MySQL can support large databases, but as the size of the data grows, the performance of your database can start to suffer. As a database administrator, there are a few things that you can do to improve the performance of your databases. The first place to start is with your hardware. As MySQL uses many…
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…
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:…
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…
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….
