Jeff的专栏

1、系统软件环境系统信息：[root@centos7 ~]# cat /proc/versionLinux version 3.10.0-862.el7.x86_64 (builder@kbuilder.dev.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-28) (GCC) ) #1 SMP Fri Apr 20 16:...

实现方式有以下三种：第一种：mysql> select SUBSTRING_INDEX(host,':',1) as ip , count(*) from information_schema.processlist group by ip;+--------------+----------+| ip | count(*) |+-----------...

本文章是通过docker创建了两个mariadb的容器，主要是记录，方便以后使用.....1、master配置a、修改/etc/my.cnf文件[mysqld]server-id=1log_bin=master-binbinlog-ignore-db=mysqlbinlog-ignore-db=information_schemabinlog-ignore-db=perfo...