Optimize a MariaDB Table

Rebuild a table to reclaim space and refresh index statistics.

Defragments a table and reclaims storage space from deleted rows. After heavy DELETE/UPDATE workloads, tables accumulate wasted space that OPTIMIZE reclaims.

When you need this: After mass deletes or when SHOW TABLE STATUS shows Data_free is large relative to Data_length.

Variables

Command


        

    







    10 views
    0 copies
    





    
    Log in to rate




    

        
Related in this category

        

                                                
                        Install MariaDB server
                    
                                                                
                        MariaDB secure installation
                    
                                                                
                        Create MariaDB database, user, and grants
                    
                                                                
                        Backup MariaDB database to .sql file
                    
                                    

    





        

        
            
                
            
            Log in to save
        
        
Free account. Save snippets into your own collections.