mysql（mariadb）之配置文件/etc/my.cnf的修改方式及查询当前值方式

河北强商网络科技有限公司

于 2020-02-26 19:07:31 发布

阅读量1.4k

点赞数

分类专栏： mysql 文章标签： mysql mariadb linux centos

原文链接：https://mariadb.com/kb/en/server-system-variables/#socket

版权

mysql 专栏收录该内容

28 篇文章

订阅专栏

本文详细介绍MariaDB服务器系统变量的设置方法，包括通过命令行、配置文件及mysql客户端进行设置。文章还介绍了如何查看所有服务器系统变量，以及变量大小单位的表示方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql（mariadb）之配置文件/etc/my.cnf的修改方式及查询当前值方式

       MariaDB has many system variables that can be changed to suit your needs.
The full list of server variables are listed in the contents on this page, and most are described on this page, but some are described elsewhere:
       MariaDB has many system variables that can be changed to suit your needs.
       The full list of server variables are listed in the contents on this page, and most are described on this page, but some are described elsewhere:
       See also the Full list of MariaDB options, system and status variables.
       Most of these can be set with command line options and many of them can be changed at runtime.
       There are a few ways to see the full list of server system variables:

While in the mysql client, run:

SHOW VARIABLES;
See SHOW VARIABLES for instructions on using this command.

From your shell, run mysqld like so:

mysqld --verbose --help
View the Information Schema GLOBAL_VARIABLES, SESSION_VARIABLES, and SYSTEM_VARIABLES tables.
Setting Server System Variables
There are several ways to set server system variables:

Specify them on the command line:

shell> ./mysqld_safe --aria_group_commit=“hard”

Specify them in your my.cnf file (see Configuring MariaDB with my.cnf for more information):

aria_group_commit = “hard”

Set them from the mysql client using the SET command. Only variables that are dynamic can be set at runtime in this way. Note that variables set in this way will not persist after a restart.

SET GLOBAL aria_group_commit=“hard”;
By convention, server variables have usually been specified with an underscore in the configuration files, and a dash on the command line. You can however specify underscores as dashes - they are interchangeable(强商科技：配置变量中的下划线与破折号是一样的效果).