
MySQL 5 Administration (Part 1)
This VTC MySQL 5 Administration Part 1 course is the first of a two-part series on the basics of administering a MySQL Server. This is a continuation of the introduction to MySQL 5 we began with the MySQL 5 Development Parts 1 and 2 courses and it assumes that the student has the equivalent knowledge covered in those courses. This first Administration course lays the groundwork for an understanding of basic internal systems of the MySQL server. The focus in Part 1 is to gain familiarity with these systems and various alternatives we have, from the different administrative tools that are available to the different options and sources for MySQL server software and services. While Part 1 has limited hands-on sections, we do offer a lot of detail and a number of exercises on user accounts and security, accessing information about some key internal systems, and some important operations for performing table maintenance. After learning this academic information about the Server, Part 2 will follow this with many practical administrative operations and systems critical to your successful use of the MySQL Server. To begin learning today, simply click on the movie links.
Course content
Introduction4 lessons
The Job of the DBA4 lessons
Architecture12 lessons
- Client/Server Architecture5:431 credit or ad
- MySQL Server Architecture6:251 credit or ad
- Client Libraries5:041 credit or ad
- Core Subsystems4:091 credit or ad
- Performance Caches6:351 credit or ad
- Query Parsing3:021 credit or ad
- Query Cache3:491 credit or ad
- Query Optimizer4:321 credit or ad
- MySQL Plug-In Interface3:391 credit or ad
- Storage Engines6:331 credit or ad
- Information Schema3:561 credit or ad
- Hardware and OS Issues5:301 credit or ad
MySQL Resource Usage10 lessons
- Global Memory6:481 credit or ad
- Session Memory5:231 credit or ad
- Estimating Memory Usage5:021 credit or ad
- Data Directory Main Server6:541 credit or ad
- Data Directory Replication Slave5:011 credit or ad
- Temporary Disk Usage7:171 credit or ad
- Disk Speed Issues5:521 credit or ad
- Disk Redundancy5:081 credit or ad
- Open File Issues6:561 credit or ad
- Multicore CPU Usage2:571 credit or ad
MySQL Server10 lessons
- Types of MySQL Distribution7:011 credit or ad
- MySQL Forks7:441 credit or ad
- Scripted Packages3:351 credit or ad
- Binary Packages4:251 credit or ad
- MySQL on Windows6:001 credit or ad
- MySQL on Mac OS X3:411 credit or ad
- MySQL on Linux6:591 credit or ad
- Upgrading MySQL7:181 credit or ad
- Using Multiple MySQL Servers6:391 credit or ad
- Service Contract Options7:301 credit or ad
Installing MySQL7 lessons
Configuration and Setup9 lessons
- mysqld Startup Options4:441 credit or ad
- Global Server Variables7:231 credit or ad
- Configuration File Location6:551 credit or ad
- Configuration File Structure3:431 credit or ad
- Configuration File Syntax6:571 credit or ad
- Important Server Settings7:051 credit or ad
- Server Startup Initialization5:441 credit or ad
- Connection Initialization5:191 credit or ad
- Replication Initialization3:061 credit or ad
Command Line Clients16 lessons
- Command Line Basics7:591 credit or ad
- mysql Client Interactive Mode4:021 credit or ad
- mysql Client Batch Mode4:531 credit or ad
- mysql Batch Mode Demo6:331 credit or ad
- mysqladmin Client4:161 credit or ad
- mysqladmin Demo6:251 credit or ad
- mysqlimport Client4:401 credit or ad
- mysqlimport Demo5:301 credit or ad
- mysqldump Client5:441 credit or ad
- mysqldump Demo6:381 credit or ad
- mysqlcheck Client5:451 credit or ad
- mysqlcheck Demo5:201 credit or ad
- mysqlslap Client4:311 credit or ad
- mysqlslap Demo6:011 credit or ad
- Other Command Line Tools2:351 credit or ad
- Client Configuration Settings5:501 credit or ad
GUI Clients9 lessons
User Accounts and Security27 lessons
- Security Basics6:031 credit or ad
- User Accounts6:271 credit or ad
- The Host Property7:051 credit or ad
- Creating a New User7:021 credit or ad
- User Privileges5:551 credit or ad
- Reviewing Privileges4:371 credit or ad
- Global Privileges7:111 credit or ad
- Database Privileges5:401 credit or ad
- Table Privileges5:041 credit or ad
- Column Privileges4:331 credit or ad
- Routine Privileges3:401 credit or ad
- The Grant Option3:371 credit or ad
- Granting Global Privileges6:261 credit or ad
- Granting Database Privileges4:031 credit or ad
- Granting Table Privileges4:071 credit or ad
- Granting Column Privileges5:271 credit or ad
- Granting Routine Privileges3:531 credit or ad
- Revoking Privileges4:511 credit or ad
- Table and Column Priv Dependency5:231 credit or ad
- Assigning and Changing Passwords5:221 credit or ad
- User Limitation Options7:101 credit or ad
- The Login Process6:441 credit or ad
- Additional Features in MySQL 5.56:241 credit or ad
- Privilege Persistence3:241 credit or ad
- Creating a User Using GRANT1:591 credit or ad
- Alternate Authentication3:581 credit or ad
- Dropping a User Account3:031 credit or ad
Storage Engines17 lessons
- Storage Engine Basics7:171 credit or ad
- MyISAM Engine Basics5:251 credit or ad
- MyISAM Features8:001 credit or ad
- MyISAM DBA Issues8:001 credit or ad
- InnoDB Engine Basics6:341 credit or ad
- InnoDB Features7:081 credit or ad
- InnoDB DBA Issues7:331 credit or ad
- Memory Engine Basics6:561 credit or ad
- Memory Engine Issues7:431 credit or ad
- XtraDB3:191 credit or ad
- Aria4:091 credit or ad
- NDB Cluster5:521 credit or ad
- Federated6:291 credit or ad
- Blackhole6:391 credit or ad
- CSV6:261 credit or ad
- Archive6:201 credit or ad
- Other Engines2:391 credit or ad
Data Types17 lessons
- Data Type Issues6:141 credit or ad
- Integer Numbers6:051 credit or ad
- Floating Point Numbers6:101 credit or ad
- Fixed Decimal Numbers4:361 credit or ad
- BIT Data Type5:171 credit or ad
- String Data Types2:441 credit or ad
- Character Strings7:241 credit or ad
- Binary Strings5:371 credit or ad
- Character Sets6:211 credit or ad
- Collations6:491 credit or ad
- ENUM Data Type6:301 credit or ad
- Compressed MyISAM Tables5:231 credit or ad
- SET Data Type6:571 credit or ad
- DATE Data Type6:291 credit or ad
- TIME and DATETIME6:551 credit or ad
- DATETIME vs TIMESTAMP7:181 credit or ad
- Choices for Booleans5:461 credit or ad
Indexes8 lessons
Administrative Metadata5 lessons
Table Maintenance13 lessons
- Table Maintenance Basics3:381 credit or ad
- CHECK TABLE Command3:471 credit or ad
- CHECK TABLE Options6:201 credit or ad
- Inflicting Some Damage5:091 credit or ad
- REPAIR TABLE Command5:501 credit or ad
- REPAIR TABLE Options3:411 credit or ad
- Repairing the Damage4:011 credit or ad
- ANALYZE TABLE Command6:071 credit or ad
- OPTIMIZE TABLE Command7:191 credit or ad
- mysqlcheck Client5:411 credit or ad
- myisamchk Utility6:451 credit or ad
- mysqlcheck and myisamchk Options2:581 credit or ad
- Storage Engine Differences7:311 credit or ad