MySQL, 5th Edition

12. General MySQL Administration

This chapter discusses the responsibilities that you must carry out to keep MySQL running smoothly if you administer MySQL at your site:

• Securing your MySQL setup after installing it

• Keeping the server running as much of the time as possible

• Monitoring and setting the server’s operating parameters

• Selecting plugins to enable server features

• Maintaining server logs

• Tuning the server for better performance

• Analyzing what’s going on with the underlying hardware and working around its physical constraints to improve performance

• Running multiple servers

• Determining whether and when to upgrade MySQL to a newer version

Other significant administrative concerns are discussed in Chapter 13, “Security ...