Recently Updated Pages
Quick Count
使用最小覆盖索引 针对 InnoDB 表（几十万到几百万行）快速统计行数，可以有几个方法。下面按实用性和效率排序： 选择最窄的索引列（最好是整型或短列）进行扫描，不访问表数据页。 假设你有一...
Commands
Config Path mysql --help | grep -B 1 etc/my.cnf Default options are read from the following fil...
MyDumper
https://mydumper.github.io/mydumper/docs/html/index.html Installation macOS brew install mydumper
Commands
Get NIC/IP Wiredifconfig en0 Wi-Fiifconfig en1 en0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMP...
Install Java8 on macOS
Oracle 1.8 is only support x86. Azul Zulu JDK 8 brew install --cask zulu@8 java -versionopenjdk...
Datasource Error
Errors 根据时间排查错误日志docker logs grafana | grep '2025-08-28T05:22:' Grafana 原始日志logger=datasources...
Commands
Get Container Running Containersdocker ps All Containersdocker ps -a Inspect Container docker...
Installation
MySQL Client 到 Oracle 官方 MySQL APT repo 下载配置包（最新版在 2025 之前是 0.8.33 这一支）： wget https://dev.mysql....
tcpdump
Specify Port & Flags tcpdump -i lo -nn -s 0 tcp port 9004 and '(tcp[tcpflags] & (tcp-syn|tcp-rst...
Commands
ss summary ss -s Total: 1785 TCP: 2635 (estab 1564, closed 1026, orphaned 23, timewait 1013) ...