MariaDB Database

  1. Indexing and Performance Optimization
    1. Fundamentals of Indexing
      1. How Indexes Work
        1. B-Tree Indexes
          1. Full-Text Indexes
            1. Spatial Indexes
              1. Hash Indexes (Engine-Specific)
              2. Indexing Strategies
                1. Choosing Columns to Index
                  1. Composite Indexes
                    1. Covering Indexes
                      1. Index Cardinality
                        1. Index Maintenance
                        2. Managing Indexes
                          1. CREATE INDEX
                            1. DROP INDEX
                              1. SHOW INDEX
                                1. Renaming Indexes
                                2. Query Optimization
                                  1. The EXPLAIN Statement
                                    1. Analyzing Query Execution Plans
                                      1. Identifying Bottlenecks
                                        1. Interpreting Output
                                        2. The MariaDB Query Optimizer
                                          1. Cost-Based Optimization
                                            1. Join Order Selection
                                            2. Optimizer Hints
                                              1. Forcing Index Usage
                                                1. Controlling Join Order
                                              2. Server Performance Tuning
                                                1. Key Buffer and Cache Settings
                                                  1. InnoDB Buffer Pool
                                                    1. Key Buffer (for MyISAM)
                                                      1. Query Cache (and its deprecation)
                                                      2. Thread and Connection Handling
                                                        1. Thread Pooling
                                                          1. Connection Limits
                                                          2. Optimizing Server System Variables
                                                            1. Memory Allocation
                                                              1. Disk I/O Settings
                                                                1. Network Settings

                                                            Previous

                                                            8. Storage Engines

                                                            Go to top

                                                            Next

                                                            10. Database Administration