MariaDB Database

  1. Database Administration
    1. User and Privilege Management
      1. CREATE USER
        1. GRANT Privileges
          1. Global Privileges
            1. Database Privileges
              1. Table Privileges
                1. Column Privileges
                2. REVOKE Privileges
                  1. DROP USER
                    1. Roles for Privilege Grouping
                      1. Creating and Assigning Roles
                        1. Managing Role Privileges
                      2. Backup and Recovery
                        1. Logical Backups with mariadb-dump
                          1. Full and Partial Backups
                            1. Restoring from Dumps
                            2. Physical Backups
                              1. Using Mariabackup
                                1. Hot and Cold Backups
                                  1. Restoring Physical Backups
                                  2. Point-in-Time Recovery using Binary Logs
                                    1. Enabling Binary Logging
                                      1. Applying Binary Logs
                                    2. Logging
                                      1. Error Log
                                        1. Location and Configuration
                                          1. Interpreting Error Messages
                                          2. General Query Log
                                            1. Enabling and Disabling
                                              1. Log Contents
                                              2. Slow Query Log
                                                1. Identifying Slow Queries
                                                  1. Tuning Slow Queries
                                                  2. Binary Log (Binlog)
                                                    1. Replication Use
                                                      1. Log Rotation and Purging
                                                    2. Server Monitoring
                                                      1. SHOW STATUS
                                                        1. Key Status Variables
                                                        2. SHOW VARIABLES
                                                          1. Viewing and Modifying Variables
                                                          2. The information_schema Database
                                                            1. Metadata Tables
                                                              1. Querying Schema Information
                                                              2. The performance_schema Database
                                                                1. Performance Monitoring Tables
                                                                  1. Analyzing Server Performance
                                                                2. Table Maintenance
                                                                  1. ANALYZE TABLE
                                                                    1. CHECK TABLE
                                                                      1. REPAIR TABLE
                                                                        1. OPTIMIZE TABLE
                                                                          1. Table Defragmentation

                                                                        Previous

                                                                        9. Indexing and Performance Optimization

                                                                        Go to top

                                                                        Next

                                                                        11. Security