Linux Magazine: How to Write Efficient MySQL Applications

[ 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:

• CNET: A comparison of MySQL vs. MS Access(Jul 27, 2001)
• Datamation: Doors Still Closed to Open Source Databases(Jul 06, 2001)
• Linux Magazine: Hey! Leggo My SQL -- Installing, Configuring, and Using MySQL(May 18, 2001)
• IBM developerWorks: Executing SQL statements in MySQL databases using C [Book Excerpt](Mar 18, 2001)
• osfaq.com: Getting out of MS Access [to MySQL](Mar 17, 2001)
• Linux.com: Writing Database Oriented Web Based Applications With Perl - Part I(Mar 05, 2001)
• SearchDatabase.com: MySQL and the open source revolution; Q&A with Britt Johnston of NuSphere(Feb 03, 2001)
• DevShed: Speaking SQL (Part 2)(Jan 20, 2001)