SELECT * FROM information_schema.INNODB_TRX;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
[Warning] Could not increase number of max_open_files to more than 1024 (request: 10811)
解决方法：
修改服务
vim /usr/lib/systemd/system/mariadb.service
#在[service]下面加
[Service]
LimitNOFILE=infinityhtml/css实现打印分页
Warning: Unknown: Input variables exceeded 1000. To increase the limit change max_input_vars in php.ini. in Unknown on line 0
nginx proxy_pass使用gzip传输节约内部流量
location / {
...
proxy_set_header Accept-Encoding "gzip";
...
proxy_pass ...;
}PHP笛卡尔积的一种实现方式
_reindex
__construct、register_shutdown_function、__destruct执行顺序
run __construct
run shutdown_function
run __destruct
* unset 等操作可以提前触发 __destruct
可以利用变量作用域在__destruct内来释放连接、解锁等释放操作
深度优先搜索 dfs php版
启用 opcache.enable_cli 也需要小心
opcache.enable_cli + xdebug + swoole 可能会导致“段错误”(Segmentation fault)