Servage Magazine

Information about YOUR hosting company – where we give you a clear picture of what we think and do!

Optimize your MySQL tables and queries

Thursday, November 15th, 2012 by Servage

When working with dynamic content, you know the problems that can arise from improperly designed tables and inefficient queries. In a worst case scenario, such problems can lead to long load times, user dissatisfaction and thus resulting in loss of revenue if running a commercial website. Therefore even database optimization is an important factor for you as a webmaster. On your Servvage web hosting account you get MySQL databases to use with your scripts. If you need more information or are just curious about more advanced MySQL knowledge, then take a look at the following book examples:

Learning MySQL

Whether you’re running a business, keeping track of members and meetings for a club, or just trying to organize a large and diverse collection of information, you’ll find the MySQL database engine useful for answering questions such as: Which are my top ten fastest-selling products? How frequently does this person come to our facility? What was the highest, lowest, and average score of the team last season?

Murach’s MySQL

This practical, hands-on training and reference guide is perfect for developers who need to learn MySQL. Written by Joel Murach, the author of bestselling “Java Servlets and JSP” and “PHP and MySQL” books, this is exactly the database book that web developers should have on their desks. As you would expect, this book shows how to code all of the essential SQL statements for creating and working with a MySQL database. But beyond that, this book also shows how to design a database, including how to use the graphical MySQL Workbench to create an EER model. It shows how to take advantage of the MySQL enhancements that aren’t covered in older books, such as foreign keys, transactions, stored procedures, stored functions, triggers, and events. It even presents a whole section on database administrator (DBA) skills, including how to secure and back up databases. And like all Murach books, it uses the distinctive “paired pages” format, which breaks the material into manageable skills to speed up both learning and reference. A great help for MySQL users at any level.

High Performance MySQL

“How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover. Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL.”

Optimize your MySQL tables and queries, 4.4 out of 5 based on 5 ratings
Categories: Servage

Keywords:

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

No comments yet (leave a comment)

You are welcome to initiate a conversation about this blog entry.

Leave a comment

You must be logged in to post a comment.