MySQL Tips and Tricks

Last Updated on: October 11, 2022 On a standard MySQL installation, remote access is disabled by default. This is great if you are sitting next to your server but generally inconvenient if you are not. With the advent of modern support teams spanning the globe, it is entirely possible to administer a server that is…

Last Updated on: September 16, 2022 One of the most valuable additions to MySQL 5 is the subquery, which lets you execute SQL like this: Unfortunately, MySQL 4 lacks this feature and is still prevalent in many web hosts. If you need to use a subquery, try the following workaround in PHP; Step by step:…

Last Updated on: September 15, 2022 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…

Last Updated on: October 11, 2022 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…

Last Updated on: October 11, 2022 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…

Last Updated on: March 13, 2011 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…