Posted by Unknown 0 komentar
Download free Beginning MySQL database design and optimization.pdf So far, we've concentrated mostly on database design and writing queries through this book, and we’ll continue to discuss aspects of those in this chapter. But there are other areas where you can work to improve the performance of MySQL and MySQL-backed applications. This chapter addresses those areas.

For example, many aspects of the MySQL server’s operation can be modified by setting configuration variables. Although their default values are often “good enough,” sometimes changing these can make a big difference in performance. In addition, you can obtain a lot of information regarding how well MySQL is actually performing by checking the values of system variables.

In the first part of this chapter, we’ll look at the commands you need to read configuration and system variables, which ones are likely to be most useful to you (and why), and how to change them when necessary. We’ll also take a very brief look at some freely available tools that can help you monitor your server’s performance and make changes in its configuration, including mytop (a top clone written in Perl), WinMySqlAdmin, phpMyAdmin, and the new MySQL Administrator, available from MySQL AB. MySQL Administrator promises to become a standard and valuable part of every MySQL database administrator’s toolkit.

Table content Beginning MySQL database design and optimization
  • Review of MySQL Basics
  • MySQL Column and Table Types
  • Keys, Indexes, and Normalization
  • Optimizing Queries with Operators, Branching, and Functions
  • Joins, Temporary Tables, and Transactions
  • Finding the Bottlenecks
  • MySQL Programming
  • Looking Ahead
  • Index

0 komentar:

Post a Comment