Linux Today: Linux News On Internet Time.

Linux Magazine: How to Write Efficient MySQL Applications

Aug 26, 2001, 10:08 (7 Talkback[s])
(Other stories by Jeremy D. Zawodny)

[ Thanks to Jeremy D. Zawodny for this link. ]

"With tools like Apache, Perl, PHP, and Python, building great MySQL applications is easy. Making sure that they are fast, however, requires quite a bit more insight. Here's what you need to know.

MySQL has a well-deserved reputation for being a very fast database server that's also quite easy to set up and use. (We looked at the installation process in the March 2001 issue, available on the Web at http://www.linux-mag.com/2001-03/mysql_01.html.) With its growing popularity as a back-end database for Web sites, its visibility has increased dramatically in the last year or so. But few MySQL users know more than how to create a database and write queries against it. Just as thousands of folks are learning about Unix by experimenting with Linux in their spare time, many are learning about relational database systems by playing with MySQL. Most of these newcomers to MySQL have neither a background in relational database theory nor the time to read the entire MySQL manual.

For this reason, we've decided to take a look at some of the methods you can use to tune MySQL for optimal performance. After reading this article, you'll understand some of the techniques that will help you design your MySQL databases and queries so that your applications are efficient. We will assume you are familiar with MySQL and SQL basics, but will not assume you have extensive knowledge of either."

Complete Story

Related Stories: