littlevigra

摘要： 给nginx的日志按照接口统计每个小时的请求量 cat access_2023-02-01.log |awk '{split($2,a,":");b[a[2]]+=1} END{for(i in b) printf("%10s %5d\n",i,b[i])}'|sort cat /home/apaa 阅读全文

摘要： CREATE INDEX CONCURRENTLY idx_kx_kq_storeinandout_time_status on public.kx_kq_storeinandout USING btree(signintime,platstatus); create UNIQUE INDEX CO 阅读全文

摘要： [root@XWBizEngine03 conf]# cat nginx.conf |egrep -v '#' |grep -v '^$' user root; worker_processes auto; error_log logs/error.log debug; events { worke 阅读全文

摘要： 1. ANALYZE — collect statistics about a database # PostgreSQL: Documentation: 15: ANALYZE 30 18 * * 1-5 /home/pg_statistics.sh [root@iZwz9ahkm8c1vnw9g 阅读全文

摘要： rpm -q --whatrequires mlocate yum remove mlocatelinux - Can I just disable updatedb? - Unix & Linux Stack Exchange 阅读全文

摘要： 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 阅读全文

摘要： 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 阅读全文

摘要： 参考：MySQL 案例：Delete 删数据后磁盘空间未释放 - 腾讯云开发者社区-腾讯云 (tencent.com) 1. 查看有多少为回收的空间 select * from information_schema.tables where TABLE_NAME ='ai_t_placedetect 阅读全文

摘要： 1. MySQL查看剩余空间 select table_name, round(data_length/1024/1024) as data_length_mb, round(data_free/1024/1024) as data_free_mb from information_schema.t 阅读全文

摘要： jvm 参数 JAVA_OPTIONS="-Xmx30720m -Xms2048m -XX:+HeapDumpOnOutOfMemoryError " 内存溢出 参数 [C:\Users\linux\Downloads\CrashAnalysis-master]$ java -jar CrashAn 阅读全文