O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

MySQL 5 Administration - Part 1

Video Description

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.

Table of Contents

  1. Introduction
    1. Welcome 00:05:13
    2. What This Course Will Cover 00:05:55
    3. System Requirements 00:03:59
    4. Prerequisite Knowledge 00:03:13
  2. The Job of the DBA
    1. Database Administration Overview 00:06:47
    2. The Company DBA Team 00:03:55
    3. The Company MySQL Team 00:05:01
    4. Hiring the Right People 00:07:05
  3. Architecture
    1. Client/Server Architecture 00:05:43
    2. MySQL Server Architecture 00:06:25
    3. Client Libraries 00:05:04
    4. Core Subsystems 00:04:09
    5. Performance Caches 00:06:35
    6. Query Parsing 00:03:02
    7. Query Cache 00:03:49
    8. Query Optimizer 00:04:32
    9. MySQL Plug-In Interface 00:03:39
    10. Storage Engines 00:06:33
    11. Information Schema 00:03:56
    12. Hardware and OS Issues 00:05:30
  4. MySQL Resource Usage
    1. Global Memory 00:06:48
    2. Session Memory 00:05:23
    3. Estimating Memory Usage 00:05:02
    4. Data Directory Main Server 00:06:54
    5. Data Directory Replication Slave 00:05:01
    6. Temporary Disk Usage 00:07:17
    7. Disk Speed Issues 00:05:52
    8. Disk Redundancy 00:05:08
    9. Open File Issues 00:06:56
    10. Multicore CPU Usage 00:02:57
  5. MySQL Server
    1. Types of MySQL Distribution 00:07:01
    2. MySQL Forks 00:07:44
    3. Scripted Packages 00:03:35
    4. Binary Packages 00:04:25
    5. MySQL on Windows 00:06:00
    6. MySQL on Mac OS X 00:03:41
    7. MySQL on Linux 00:06:59
    8. Upgrading MySQL 00:07:18
    9. Using Multiple MySQL Servers 00:06:39
    10. Service Contract Options 00:07:30
  6. Installing MySQL
    1. Installation Basics 00:06:28
    2. Windows Details 00:06:26
    3. Mac OS X Details 00:04:20
    4. Linux Details 00:03:03
    5. Initializing the Data Directory 00:04:21
    6. Named Time Zone Tables 00:06:20
    7. First Admin User Account 00:03:58
  7. Configuration and Setup
    1. mysqld Startup Options 00:04:44
    2. Global Server Variables 00:07:23
    3. Configuration File Location 00:06:55
    4. Configuration File Structure 00:03:43
    5. Configuration File Syntax 00:06:57
    6. Important Server Settings 00:07:05
    7. Server Startup Initialization 00:05:44
    8. Connection Initialization 00:05:19
    9. Replication Initialization 00:03:06
  8. Command Line Clients
    1. Command Line Basics 00:07:59
    2. mysql Client Interactive Mode 00:04:02
    3. mysql Client Batch Mode 00:04:53
    4. mysql Batch Mode Demo 00:06:33
    5. mysqladmin Client 00:04:16
    6. mysqladmin Demo 00:06:25
    7. mysqlimport Client 00:04:40
    8. mysqlimport Demo 00:05:30
    9. mysqldump Client 00:05:44
    10. mysqldump Demo 00:06:38
    11. mysqlcheck Client 00:05:45
    12. mysqlcheck Demo 00:05:20
    13. mysqlslap Client 00:04:31
    14. mysqlslap Demo 00:06:01
    15. Other Command Line Tools 00:02:35
    16. Client Configuration Settings 00:05:50
  9. GUI Clients
    1. GUI Clients Introduction 00:04:56
    2. MySQL Workbench 00:07:27
    3. SkySQL Visual Editor 00:03:47
    4. Navicat 00:04:37
    5. Omnis Studio 00:07:39
    6. phpMyAdmin 00:04:55
    7. Toad for MySQL 00:03:13
    8. SQLYog 00:04:00
    9. Other GUI Clients 00:05:14
  10. User Accounts and Security
    1. Security Basics 00:06:03
    2. User Accounts 00:06:27
    3. The Host Property 00:07:05
    4. Creating a New User 00:07:02
    5. User Privileges 00:05:55
    6. Reviewing Privileges 00:04:37
    7. Global Privileges 00:07:11
    8. Database Privileges 00:05:40
    9. Table Privileges 00:05:04
    10. Column Privileges 00:04:33
    11. Routine Privileges 00:03:40
    12. The Grant Option 00:03:37
    13. Granting Global Privileges 00:06:26
    14. Granting Database Privileges 00:04:03
    15. Granting Table Privileges 00:04:07
    16. Granting Column Privileges 00:05:27
    17. Granting Routine Privileges 00:03:53
    18. Revoking Privileges 00:04:51
    19. Table and Column Priv Dependency 00:05:23
    20. Assigning and Changing Passwords 00:05:22
    21. User Limitation Options 00:07:10
    22. The Login Process 00:06:44
    23. Additional Features in MySQL 5.5 00:06:24
    24. Privilege Persistence 00:03:24
    25. Creating a User Using GRANT 00:01:59
    26. Alternate Authentication 00:03:58
    27. Dropping a User Account 00:03:03
  11. Storage Engines
    1. Storage Engine Basics 00:07:17
    2. MyISAM Engine Basics 00:05:25
    3. MyISAM Features 00:08:00
    4. MyISAM DBA Issues 00:08:00
    5. InnoDB Engine Basics 00:06:34
    6. InnoDB Features 00:07:08
    7. InnoDB DBA Issues 00:07:33
    8. Memory Engine Basics 00:06:56
    9. Memory Engine Issues 00:07:43
    10. XtraDB 00:03:19
    11. Aria 00:04:09
    12. NDB Cluster 00:05:52
    13. Federated 00:06:29
    14. Blackhole 00:06:39
    15. CSV 00:06:26
    16. Archive 00:06:20
    17. Other Engines 00:02:39
  12. Data Types
    1. Data Type Issues 00:06:14
    2. Integer Numbers 00:06:05
    3. Floating Point Numbers 00:06:10
    4. Fixed Decimal Numbers 00:04:36
    5. BIT Data Type 00:05:17
    6. String Data Types 00:02:44
    7. Character Strings 00:07:24
    8. Binary Strings 00:05:37
    9. Character Sets 00:06:21
    10. Collations 00:06:49
    11. ENUM Data Type 00:06:30
    12. Compressed MyISAM Tables 00:05:23
    13. SET Data Type 00:06:57
    14. DATE Data Type 00:06:29
    15. TIME and DATETIME 00:06:55
    16. DATETIME vs TIMESTAMP 00:07:18
    17. Choices for Booleans 00:05:46
  13. Indexes
    1. Index Basics 00:05:09
    2. Index Usage Types 00:08:22
    3. Index Structure Types 00:07:16
    4. Indexing Strategies 00:07:45
    5. Character String Indexes 00:06:29
    6. Index Page Caching 00:08:07
    7. FULLTEXT Indexes 00:08:55
    8. HASH vs BTREE Indexes 00:07:17
  14. Administrative Metadata
    1. Sources of Metadata 00:07:33
    2. Connection Data 00:05:55
    3. Cache and Buffer Information 00:08:13
    4. Table Status 00:06:20
    5. Engine Status 00:05:08
  15. Table Maintenance
    1. Table Maintenance Basics 00:03:38
    2. CHECK TABLE Command 00:03:47
    3. CHECK TABLE Options 00:06:20
    4. Inflicting Some Damage 00:05:09
    5. REPAIR TABLE Command 00:05:50
    6. REPAIR TABLE Options 00:03:41
    7. Repairing the Damage 00:04:01
    8. ANALYZE TABLE Command 00:06:07
    9. OPTIMIZE TABLE Command 00:07:19
    10. mysqlcheck Client 00:05:41
    11. myisamchk Utility 00:06:45
    12. mysqlcheck and myisamchk Options 00:02:58
    13. Storage Engine Differences 00:07:31
  16. Conclusion
    1. What We Covered 00:02:55
    2. Where to Go from Here 00:03:33
  17. Credits
    1. About This Author 00:03:52