> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands.md).

# FLUSH Statements

{% columns %}
{% column %}
{% content-ref url="/pages/awIczDOZUaVtaTE9gyZG" %}
[FLUSH](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete FLUSH statement reference: NO\_WRITE\_TO\_BINLOG/LOCAL syntax, FLUSH TABLES WITH READ LOCK/FOR EXPORT, FLUSH STATUS, and SSL/TLS certificate reload.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/vfNfmzbjEBPOmel8NaYZ" %}
[FLUSH QUERY CACHE](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush-query-cache.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Defragment the query cache to optimize memory usage. This command reorganizes the cache to eliminate fragmentation without removing existing cached queries.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/KFrjyaqpgp5MyETodsFI" %}
[FLUSH TABLES FOR EXPORT](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush-tables-for-export.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Prepare individual tables for binary backup. This command flushes changes to disk and locks tables, allowing safe copying of .ibd files while the server runs.
{% endcolumn %}
{% endcolumns %}