Mysql 默认配置

# Copyright (c) 2015, 2021, Oracle and/or its affiliates. # # This program is free software; you can redistri…

# Copyright (c) 2015, 2021, Oracle and/or its affiliates.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2.0,…

# Copyright (c) 2015, 2021, Oracle and/or its affiliates. # # This program is free software; you can redistri…

# Copyright (c) 2015, 2021, Oracle and/or its affiliates.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2.0,…

# Copyright (c) 2014, 2021, Oracle and/or its affiliates. # # This program is free software; you can redistri…

# Copyright (c) 2014, 2021, Oracle and/or its affiliates.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2.0,…

# Copyright (c) 2015, 2021, Oracle and/or its affiliates. # # This program is free software; you can redistri…

# Copyright (c) 2015, 2021, Oracle and/or its affiliates.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2.0,…

# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/8.0/en/server-configurati…

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most …

# Automatically generated for Debian scripts. DO NOT TOUCH! [client] host = localhost user = root pas…

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = root
password = 
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user …

#!/bin/bash # # This script is executed by "/etc/init.d/mysql" on every (re)start. # # Changes to this file w…

#!/bin/bash
#
# This script is executed by "/etc/init.d/mysql" on every (re)start.
#
# Changes to this file will be preserved when updating the Debian package.
#
# NOTE: This file is read only by the…

# The MariaDB configuration file # # The MariaDB/MySQL tools read configuration files in the following order:…

# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d…

# Copyright (c) 2015, 2021, Oracle and/or its affiliates. # # This program is free software; you can redistri…

# Copyright (c) 2015, 2021, Oracle and/or its affiliates.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2.0,…

# # These groups are read by MariaDB server. # Use it for options that only the server (but not clients) shou…

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read …

# NOTE: This file is read only by the traditional SysV init script, not systemd. # MariaDB systemd does _not_…

# NOTE: This file is read only by the traditional SysV init script, not systemd.
# MariaDB systemd does _not_ utilize mysqld_safe nor read this file.
#
# For similar behaviour, systemd users should c…

# # These groups are read by MariaDB command-line tools # Use it for options that affect only one utility # …

#
# These groups are read by MariaDB command-line tools
# Use it for options that affect only one utility
#

[mysql]
# Default is Latin1, if you need UTF-8 set this (also in server section)
default-c…

# # This group is read by the client library # Use it for options that affect all clients, but not the server…

#
# This group is read by the client library
# Use it for options that affect all clients, but not the server
#

[client]
# Default is Latin1, if you need UTF-8 set this (also in server section)
defa…

# Copyright (c) 2015, 2021, Oracle and/or its affiliates. # # This program is free software; you can redistri…

# Copyright (c) 2015, 2021, Oracle and/or its affiliates.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2.0,…

# # * Galera-related settings # # See the examples of server wsrep.cnf files in /usr/share/mysql # and read m…

#
# * Galera-related settings
#
# See the examples of server wsrep.cnf files in /usr/share/mysql
# and read more at https://mariadb.com/kb/en/galera-cluster/

[galera]
# Mandatory settings
#wsrep_on …

[server] plugin_load_add=provider_snappy provider_snappy=force_plus_permanent

[server]
plugin_load_add=provider_snappy
provider_snappy=force_plus_permanent

[server] plugin_load_add=provider_lzo provider_lzo=force_plus_permanent

[server]
plugin_load_add=provider_lzo
provider_lzo=force_plus_permanent

[server] plugin_load_add=provider_lzma provider_lzma=force_plus_permanent

[server]
plugin_load_add=provider_lzma
provider_lzma=force_plus_permanent

[server] plugin_load_add=provider_lz4 provider_lz4=force_plus_permanent

[server]
plugin_load_add=provider_lz4
provider_lz4=force_plus_permanent

[server] plugin_load_add=provider_bzip2 provider_bzip2=force_plus_permanent

[server]
plugin_load_add=provider_bzip2
provider_bzip2=force_plus_permanent