13.Administering Your Database
In this chapter we will cover the day-to-day administration activities associated with running a MySQL database, including the following:
• Starting up and shutting down
• Getting information about the server and databases
• Setting variables
• Killing threads
• Clearing caches
• Analyzing tables
• Understanding the log files
Although this chapter is structured in a task-oriented fashion, we will make use of one important script, mysqladmin
, for several of these tasks.
The mysqladmin
script is used with appropriate parameters to perform a wide variety of administrative tasks. A summary of these appears at the end of this chapter.
We will also cover the use of the mysqlshow
and mysqlcheck
scripts and the ...
Get MySQL Tutorial now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.