Skip to Main Content
Sams Teach Yourself MySQL in 21 Days, Second Edition
book

Sams Teach Yourself MySQL in 21 Days, Second Edition

by Tony Butcher
December 2002
Beginner content levelBeginner
640 pages
16h 41m
English
Sams
Content preview from Sams Teach Yourself MySQL in 21 Days, Second Edition

Factors Affecting Performance

The performance of your system will be affected by a number of factors. Here are the main factors, roughly in order of impact:

  • How your columns and tables are defined, and what table types they have

  • How your application uses MySQL

  • How your application runs its queries and how the MySQL optimizer processes them

  • The MySQL system variables

  • Your operating system and hardware

  • How mysqld is compiled

We will go through these factors in turn. This should enable you to get a good grasp of them, and you will learn what you can do in each respect to improve performance.

Whatever tactics you may come to use, always run benchmark tests to measure the impact of any change. Carry out timings before and after any adjustment. You will ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Sams Teach Yourself MySQL

Sams Teach Yourself MySQL

Chris Newman
Oracle® Database 10g Insider Solutions

Oracle® Database 10g Insider Solutions

Arun Kumar R., John Kanagaraj, Richard Stroupe
MySQL and mSQL

MySQL and mSQL

Tim King, George Reese, Randy Yarger
Jump Start MySQL

Jump Start MySQL

Timothy Boronczyk

Publisher Resources

ISBN: 0672323923Purchase book