Road Map to This Book

This book is organized into four parts.

Part I: General MySQL Use

  • Chapter 1, "Getting Started with MySQL and SQL." Discusses how MySQL can be useful to you, and provides a tutorial that introduces the interactive MySQL client program, covers the basics of SQL, and demonstrates MySQL's general capabilities.

  • Chapter 2, "Working with Data in MySQL." Discusses the column types that MySQL provides for describing your data, properties and limitations of each type, when and how to use them, how to choose between similar types, expression evaluation, and type conversion.

  • Chapter 3, "MySQL SQL Syntax and Use." Every major RDBMS now available understands SQL, but every database engine implements a slightly different SQL dialect. This chapter discusses SQL with particular emphasis on those features that make MySQL distinctive.

  • Chapter 4, "Query Optimization." How to make your queries run more efficiently.

Part II: Using MySQL Programming Interfaces

  • Chapter 5, "Introduction to MySQL Programming." Discusses some of the application programming interfaces available for MySQL and provides a general comparison of the APIs that the book covers in detail.

  • Chapter 6, "The MySQL C API." How to write C programs using the API provided by the client library included in the MySQL distribution.

  • Chapter 7, "The Perl DBI API." How to write Perl scripts using the DBI module. Covers standalone scripts and CGI scripts for Web site programming.

  • Chapter 8, "The PHP API." How to use the PHP scripting language to write dynamic Web pages that access MySQL databases.

Part III: MySQL Administration

  • Chapter 9, "Introduction to MySQL Administration." What the database administrator's duties are and what you should know to run a site successfully.

  • Chapter 10, "The MySQL Data Directory." An in-depth look at the organization and contents of the data directory, the area under which MySQL stores databases and status files.

  • Chapter 11, "General MySQL Administration." How to make sure your server starts up and shuts down properly when your system does. Also includes instructions for setting up MySQL user accounts, and discusses log file maintenance, configuring the InnoDB tablespace, server tuning, running multiple servers, and setting up replication servers.

  • Chapter 12, "Security." What you need to know to make your MySQL installation safe from intrusion, both from other users on the server host and from clients connecting over the network. Describes how to set up your MySQL server to support secure connections over SSL.

  • Chapter 13, "Database Backups, Maintenance, and Repair." Discusses how to reduce the likelihood of disaster through preventive maintenance, how to back up your databases, and how to perform crash recovery if disaster strikes in spite of your preventive measures.

Part IV: Appendixes

  • Appendix A, "Obtaining and Installing Software." Where to get and how to install the major tools described in the book.

  • Appendix B, "Column Type Reference." Descriptions of MySQL's column types.

  • Appendix C, "Operator and Function Reference." Descriptions of the operators and functions that are used to write expressions in SQL statements.

  • Appendix D, "SQL Syntax Reference." Descriptions of each SQL statement that MySQL understands.

  • Appendix E, "MySQL Program Reference." Descriptions of the programs provided in the MySQL distribution.

  • Appendix F, "C API Reference." Descriptions of data types and functions in the MySQL C client library.

  • Appendix G, "Perl DBI API Reference." Descriptions of methods and attributes provided by the Perl DBI module.

  • Appendix H, "PHP API Reference." Descriptions of the functions that PHP provides for MySQL support.

  • Appendix I, "Internet Service Providers." What to consider when choosing an ISP that provides MySQL access. What to consider when operating as an ISP providing MySQL services to customers.



MySQL
High Performance MySQL: Optimization, Backups, Replication, and More
ISBN: 0596101716
EAN: 2147483647
Year: 2003
Pages: 188

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net