Register now or log in to join your professional community.
Queries, in the form of SELECT statements, perform all the lookup operations in the database. Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight reports.
Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE clauses in DELETE statements. Those statements have additional performance considerations because they combine write operations with the read-oriented query operations.
MySQL is a great database engine for small to medium sites and has great performance of SQL queries. I also read somewhere that Google uses MySQL for some of its functionality. MySQL is very rugged but its performance can be greatly improved. MySQL is now owned by Oracle. MySQL is the world’s most popular database. Being open source, it is constantly being improved upon by developers around the world.
MySQL is part of the LAMP stack that is very widely known and used. LAMP stands for Linux, Apache, MySQL and PHP. MySQL does not ship with any graphical user interface, but phpMyAdmin can be installed which makes the database very easy to use through an HTML frontend.
