Administrative SQL Statements

SQL statements for administering MariaDB.

Title Description
Table Statements Documentation on creating, altering, analyzing and maintaining tables.
ANALYZE and EXPLAIN Statements Articles on the ANALYZE and EXPLAIN statements
BACKUP commands Commands used by backup tools
FLUSH Commands Commands to flush or reset various caches in MariaDB
Replication Commands List of replication-related commands.
Plugin SQL Statements List of SQL statements related to plugins.
SET Commands The SET commands
SHOW Articles on the various SHOW commands.
System Tables
BINLOG Generated by mysqlbinlog
PURGE BINARY LOGS PURGE BINARY LOGS removes all binary logs from the server, prior to the provided date or log file.
CACHE INDEX Caches MyISAM or Aria indexes
DESCRIBE Information about columns in a table.
EXECUTE Statement Executes a previously PREPAREd statement
HELP Command The HELP command will retrieve syntax and help within the mysql client.
KILL [CONNECTION | QUERY] Kill connection by query or thread id.
LOAD INDEX Loads one or more indexes from one or more MyISAM/Aria tables into a key buffer
RESET Overall description of the different RESET commands
SHUTDOWN Shuts down the server.
USE Set the current default database.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/administrative-sql-statements/