> 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/server-usage.md).

# Server Usage

<table data-view="cards"><thead><tr><th align="center"></th><th align="center"></th><th align="center"></th><th data-hidden data-card-cover data-type="files"></th></tr></thead><tbody><tr><td align="center"><strong>WHITE PAPER</strong></td><td align="center">The Ultimate Guide to High Availability with MariaDB</td><td align="center"><a href="https://go.mariadb.com/high-availability-guide-MariaDB-whitepaper.html?utm_source=onpagepromo&#x26;utm_medium=kb&#x26;utm_campaign=high-availability"><strong>Download Now</strong></a></td><td><a href="/files/JDzSeoj8SSLyYtuNxbQ6">/files/JDzSeoj8SSLyYtuNxbQ6</a></td></tr></tbody></table>

{% columns %}
{% column %}
{% content-ref url="/pages/BsnCdpw0aFDRvLsm3LiD" %}
[Basics](/docs/server/server-usage/basics.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Grasp the basics of using MariaDB Server. This section introduces fundamental concepts, common SQL commands, and essential operations to get you started with your database.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/EqcKwytLfNcv1iwBoqbW" %}
[Backup & Restore](/docs/server/server-usage/backup-and-restore.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn to back up and restore MariaDB Server databases. This section covers essential strategies and tools to ensure data safety and quick recovery from potential data loss.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/0sn6UZAnisyOpB9WTwho" %}
[Tables](/docs/server/server-usage/tables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Manage tables in MariaDB Server. This section details creating, altering, and dropping tables, along with understanding data types and storage engines for optimal database design.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/7TtUzQ9U5hhkN0gGJbCD" %}
[Partitioning Tables](/docs/server/server-usage/partitioning-tables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Optimize large tables in MariaDB Server with partitioning. Learn how to divide tables into smaller, manageable parts for improved performance, easier maintenance, and scalability.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/XqqPWhqXzauZN9IjpmeC" %}
[Stored Routines](/docs/server/server-usage/stored-routines.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Automate tasks in MariaDB Server with stored routines. Learn to create and manage stored procedures and functions for enhanced database efficiency and code reusability.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/GPSdWLvO4uRURM7G3ToJ" %}
[Storage Engines](/docs/server/server-usage/storage-engines.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Understand MariaDB Server's storage engines. Explore the features and use cases of InnoDB, Aria, MyISAM, and other engines to choose the best option for your specific data needs.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/YqQ0Qv7eZiJy7tklX8Cx" %}
[Triggers & Events](/docs/server/server-usage/triggers-events.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Automate database actions with triggers and events in MariaDB Server. Learn to define automatic responses to data modifications and schedule tasks for efficient database management.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/04QCnhSGYswA2TplM2J2" %}
[User-Defined Functions](/docs/server/server-usage/user-defined-functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Extend MariaDB Server's capabilities with user-defined functions (UDFs). Learn how to create and implement custom functions to perform specialized operations directly within your SQL queries.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/TSWPfWnFqdYL2vvIRUoN" %}
[Views](/docs/server/server-usage/views.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn to use views in MariaDB Server. This section explains how to create virtual tables from query results, simplifying complex queries and enhancing data security and abstraction.
{% endcolumn %}
{% endcolumns %}