01 2023 档案

ANALYZE和vacuum
摘要：1. ANALYZE — collect statistics about a database # PostgreSQL: Documentation: 15: ANALYZE 30 18 * * 1-5 /home/pg_statistics.sh [root@iZwz9ahkm8c1vnw9g 阅读全文
posted @ 2023-01-30 22:07 littlevigra 阅读(66) 评论(1) 推荐(0) 编辑
/usr/bin/updatedb -f sysfs ramfs bdev proc cgroup cpuset tmpfs
摘要：rpm -q --whatrequires mlocate yum remove mlocatelinux - Can I just disable updatedb? - Unix & Linux Stack Exchange 阅读全文
posted @ 2023-01-17 11:53 littlevigra 阅读(111) 评论(0) 推荐(0) 编辑
mysql 时间维度 以10分钟为粒度
摘要：1. 10分钟为粒度分组 SELECT concat(left(date_format(create_time, '%Y-%m-%d %H:%i'),15),'0') AS groupTime, count(*) FROM ai_t_task WHERE create_time BETWEEN '2 阅读全文
posted @ 2023-01-16 23:47 littlevigra 阅读(248) 评论(0) 推荐(0) 编辑
tcpdump高级使用和TCP/IP协议了解
摘要：1. 打印数据长度大于0的数据包 To print all IPv4 HTTP packets to and from port 80, i.e. print only packets that contain data, not, for example, SYN and FIN packets 阅读全文
posted @ 2023-01-08 00:17 littlevigra 阅读(57) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示