MySQL for the system administrator
MySQL is ubiquitous. It will be for many years. A little knowledge will go a long way to having a good MySQL setup. A little knowledge will also
leverage your command line knowledge when working with MySQL.
Restorals are paramount, but you can't just backup the files. Restorals need proper backups. MySQL has mechanisms for controlling access, but general system administration tools can be used in addition to the MySQL grants.
MySQL has several database engines available, choose wisely and configure it properly before starting.
It's obvious that the slow query log can be useful for finding long-running queries, but it's not the only place to find useful log information.
The presentation will also cover OS changes and good practices that will help the system administrator use and administer MySQL without having to become a DBA.
<iframe width="560" height="315" src="https://www.youtube.com/embed/h_Lwavrt9oQ" frameborder="0" allowfullscreen></iframe>