Administrative Statements

Explore administrative SQL statements for MariaDB Server. This section covers commands for server management, maintenance, and diagnostics, including BINLOG, KILL, SHUTDOWN, and SHOW.

BINLOG

Executes binary log events directly using base64-encoded data. Primarily used by the mariadb-binlog utility to re-apply events to the server.

CACHE INDEX

Assigns specific table indices to a named key cache. Optimizes server performance by preloading or dedicating memory to frequently accessed keys.

DESCRIBE

Provides information about a table's columns. Acts as a shortcut for SHOW COLUMNS, displaying field names, types, and other attributes.

HELP Command

Displays help information from the server's help tables. Useful for looking up SQL syntax and command descriptions directly from the client.

KILL

Terminates a specific connection or query. Allows administrators to stop runaway threads or disconnect users to free up server resources.

PURGE BINARY LOGS

Official PURGE BINARY LOGS syntax: delete binlogs using TO 'log_name' or BEFORE datetime_expr, replica read constraints, and SHOW BINARY LOGS commands.

RESET

Clears internal server buffers, caches, and status variables. Resets state information like the query cache or replication status without a restart.

SHUTDOWN

Stops the MariaDB server process. Allows a client with the SHUTDOWN privilege to cleanly power down the database instance.

ANALYZE and EXPLAIN Statements

Learn commands for query analysis. This section covers ANALYZE TABLE and EXPLAIN, used to view execution plans and optimize query performance.

BACKUP Statements

Learn about backup statements for MariaDB Server. This section details SQL statements and utilities for creating consistent database backups, essential for disaster recovery and data protection.

FLUSH Statements

Explore commands to clear internal caches. Learn to use FLUSH to reload privileges, clear the query cache, or close open tables.

Plugin Statements

Manage server plugins. This section covers INSTALL PLUGIN, UNINSTALL PLUGIN, and SHOW PLUGINS for extending server functionality.

Replication Statements

Control replication topologies. Learn statements like CHANGE MASTER TO and START SLAVE to configure primaries and replicas.

SET Statements

Assign values to system variables. Learn to use the SET statement to configure GLOBAL and SESSION variables for tuning server behavior.

SHOW Statements

View server metadata and status. This section lists SHOW statements for inspecting databases, tables, variables, and performance metrics.