youtube的Shorts就是shift.........

2026-01-27 其他 YY.K Permalink

两三年前刷过，老是重复出现看过的视频， 现在还是一点都没变。。。。。。

 

真是shi。。。。。。。。 shift

none

workerman和swoole单文件静态php

2026-01-20 Linux YY.K Permalink

worker和swoole直接常驻内存运行抛弃fpm直接高效运行， 官方提供了现成的静态编译php文件，拿来直接可以运行，不用再自己吭哧吭哧再去编译，直接带上nginx就可以跑，如果将php打包成二进制文件会更简单。

 

几个相关项目发布地址

https://github.com/swoole/swoole-cli/releases
https://github.com/dixyes/phpmicro
https://github.com/crazywhalecc/static-php-cli

https://www.swoole.com/download
https://www.workerman.net/download

swoole-cli静态php

wget -O - https://github.com/swoole/swoole-cli/releases/download/v6.1.4.0/swoole-cli-v6.1.4-linux-x64.tar.xz | tar -xJ 
install swoole-cli /usr/bin/swoole

workerman官方静态php

wget https://www.workerman.net/download/php/php-8.4-linux-x86_64.tar.gz|  tar -xz

phpmicro可以打包php为二进制文件

 

swoole启动fpm

swoole-cli -P -h
# 运行 FPM
swoole-cli -P --fpm-config /opt/php-8.1/etc/php-fpm.conf -p /opt/php-8.1/var
# 关闭守护进程
swoole-cli -P --fpm-config /opt/php-8.1/etc/php-fpm.conf -p /opt/php-8.1/var -F
# 使用 root 账户启动
swoole-cli -P --fpm-config /opt/php-8.1/etc/php-fpm.conf -p /opt/php-8.1/var -F -R
swoole, workerman, webman

发现两个新的邮局方案mox和stalwart

2026-01-18 Linux YY.K Permalink

https://github.com/stalwartlabs/stalwart/releases

https://github.com/mjl-/mox/releases

none

PostgreSQL查找慢查询

2026-01-10 Linux YY.K Permalink

统计CPU

ps -u postgres -o %cpu | awk '{s+=$1} END {print "Postgres Total CPU: " s "%"}'

查看活跃查询

SELECT pid, now() - query_start AS duration, query, state FROM pg_stat_activity WHERE state = 'active' ORDER BY duration DESC;
SELECT pid, now() - query_start AS duration, query, state FROM pg_stat_activity WHERE state = 'active' ORDER BY duration DESC LIMIT 5;

查看连接IP和查询语句

SELECT pid, now() - query_start AS 执行时间, usename AS 用户名, 
client_addr AS 连接IP, state AS 状态, query AS 查询语句         
FROM pg_stat_activity WHERE
 pid <> pg_backend_pid() ORDER BY 执行时间 DESC;

查看扫表

SELECT 
    relname AS 表名,
    seq_scan AS 全表扫描次数,
    seq_tup_read AS 全表扫描读取行数,
    idx_scan AS 索引扫描次数,
    idx_tup_fetch AS 索引提取行数
FROM pg_stat_user_tables
WHERE seq_scan > 0
ORDER BY seq_tup_read DESC
LIMIT 10;

启用插件

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

 重置自动增续ID

SELECT setval('tag_id_seq', (SELECT MAX(id) FROM tag));
PostgreSQL

nginx隐藏真实文件路径

2026-01-10 Linux YY.K Permalink

给浏览器浏览器返回头

$file=decode($url);
header("X-Accel-Redirect: /privatefiles/$file");

nginx配置

    location /privatefiles {
        internal;  #内部访问
        alias /var/www/html/xaccel/restrictedfiles;
    }

 

将文件名url加密， 然后接收解密，通过X-Accel-Redirect再转给nginx返回数据。

为什么要这么做？  一些文件路径在某些原因下不想暴露真实路径，又不通过程序再去读一遍问题直接转交个nginx响应。

转载自：https://dev.to/gbhorwood/nginx-serving-private-files-with-x-accel-redirect-57dl

nginx