致知的博客

表A UserIdABC表B DeviceIdUserIdaaAbbAccB目的：查询每个用户拥有的设备数量sql = SELECT L.Id, R.Id AS DeviceId COUNT(R.Id) AS DeviceNumber FROM device_user AS L LEFT JOIN device_device AS R ON L.Id = R.UserId WHERE 1 = 1 GROUP BY Id

MySQL远程连接命令偶尔能连上偶尔连不上，报错：error: (2003, Can’t connect to MySQL server on ip (110))ping显示能连通，没有丢包，但是内网延迟不稳定，在0.8-1.5ms之间。telnet偶尔能连偶尔连不上ping发的是icmp协议包，很小，看不出来网络的状况，而telnet间歇性断联，则说明服务器之间的网络有问题。...

1. 安装Docker卸载旧版本$ sudo yum remove docker docker-client docker-client-latest docker-common docker-latest docker-latest-logrotate docker-logrotate docker-engine更新、添加软件源$ sudo yum-config-manager...

打开MySQL的general log, 方便排查临时一次: mysql -uroot -p 进入，set global general_log='ON';永久: MySQL配置文件, /etc/my.cnf 在[mysqld]下添加general-log=1默认日志位置: /var/lib/mysql/localhost.log打开events_statements_history 历...

vim /etc/default/grub possible_cpus=8 grub2-mkconfig -o /boot/grub2/grub.cfg;# 每条MySQL语句都会记录set global general_log='ON';tail -f /var/lib/mysql/localhost.logStop mysql may hung up for the fir...

首先确定Windows中的MySQL服务没有运行，占用3306端口/var/log/mysql/error.log中依然报错:Linux Native AIO interface is not supported on this platform. Pleasecheck your OS documentation and install appropriate binary of Inn...