文件操作 - server.cnf
返回文件管理
返回主菜单
删除本文件
文件: /root/sh/etc/my.cnf.d/server.cnf
编辑文件内容
# # 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 by the standalone daemon and embedded servers [server] port = 3306 # this is only for the mysqld standalone daemon [mysqld] max_execution_time = 10000 max_connections = 400 # Ross 09-06-2023 aumentate a 120 erano 40 # con 8GB di memroia possono arrivare anche a 500 # https://stackoverflow.com/questions/11183727/how-to-solve-mysql-max-user-connections-error max_user_connections = 500 # # * Galera-related settings # [galera] # Mandatory settings #wsrep_on=ON #wsrep_provider= #wsrep_cluster_address= #binlog_format=row #default_storage_engine=InnoDB #innodb_autoinc_lock_mode=2 # # Allow server to accept connections on all interfaces. bind-address = 127.0.0.1 # # Optional setting #wsrep_slave_threads=1 #innodb_flush_log_at_trx_commit=0 # this is only for embedded server [embedded] # This group is only read by MariaDB servers, not by MySQL. # If you use the same .cnf file for MySQL and MariaDB, # you can put MariaDB-only options here [mariadb] # This group is only read by MariaDB-10.1 servers. # If you use the same .cnf file for MariaDB of different versions, # use this group for options that older servers don't understand [mariadb-10.1]
修改文件时间
将文件时间修改为当前时间的前一年
删除文件