mysql

由于系统 systemd 限制导致 mysql 可创建的线程数达到上限, 出现无法登陆等问题 ...

0 前言 系统使用 Gnome 环境 1 安装 安装依赖 zypper in libatomic1 zypper in perl-JSON 下载 mysql 安装包, 链接 tar xf mysql-5.7.44-1.sles12.x86_64.rpm-bundle.tar rpm -ivh mysql-community-common-5.7.44-1.sles12.x86_64.rpm rpm -ivh mysql-community-libs-5.7.44-1.sles12.x86_64.rpm rpm -ivh mysql-community-client-5.7.44-1.sles12.x86_64.rpm rpm -ivh mysql-community-server-5.7.44-1.sles12.x86_64.rpm mkdir -p /data/mysql/{data,tmp} chown -R mysql /data/mysql mysqld --initialize --datadir=/data/mysql/data/ --user=mysql 修改 /etc/my.cnf 配置文件 [client] port = 3306 socket = /data/mysql/mysql.sock default-character-set=utf8 [mysqld] port = 3306 skip-grant-tables datadir = /data/mysql/data tmpdir = /data/mysql/tmp socket = /data/mysql/mysql.sock character-set-server = utf8 collation-server = utf8_general_ci pid-file = /data/mysql/mysql.pid user = mysql explicit_defaults_for_timestamp lower_case_table_names = 1 max_connections = 1000 back_log = 1024 open_files_limit = 10240 table_open_cache = 5120 skip-external-locking local-infile = 1 key_buffer_size = 32M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K ...

mysql 主从复制的详细原理, 主从复制模式, 主从复制方式, 以及 GTID 复制和并行复制 ...

在 centos7 中部署 mysql-5.7 ...

0 下载地址 https://dev.mysql.com/downloads/mysql/ 1 常用 Sql 1.1 查看用户权限 SELECT u.user, u.host, d.db, u.select_priv, u.insert_priv, u.update_priv, u.delete_priv, u.create_priv, u.drop_priv, u.grant_priv FROM mysql.user u LEFT JOIN mysql.db d ON u.user = d.user ORDER BY u.user, u.host, d.db; 1.2 查看所有库的表数量 SELECT table_schema, COUNT(*) AS table_count FROM information_schema.tables WHERE table_type = 'BASE TABLE' GROUP BY table_schema; 1.3 加载的配置文件顺序 mysql --help |grep -i "my.cnf" /etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf 1.4 查看库的表数量及占用空间 select table_schema as '数据库', table_name as '表名', table_rows as '记 ...