请问给数据库进行分表?
2023-07-13 14:53 来自 迪巴拉 发布@ Discuz!问题求助
各位老师,我的网站服务器cpu近段时间经常跑到100%,主要是php-fpm进程到达100,有时nginx进程达到100,有时是sysmed达到100(大部分是php-fpm进程到达100),经咨询宝塔那边的网友,说有可能是因为我网站的数据库太大了,建议将数据库进行分表。但是我是小白,不会进行具体分表操作(怕出错,同时希望分表后,网友在被分出的主题帖后面进行回复)
在此请教各位老师,能否告知下分表的具体操作流程(有示例图就最好了),诚挚感谢...
42799
42800
我知道答案 回答被采纳将会获得1 贡献 已有0人回答
在此请教各位老师,能否告知下分表的具体操作流程(有示例图就最好了),诚挚感谢...
42799
42800
我知道答案 回答被采纳将会获得1 贡献 已有0人回答
网站访问后台不间断出现502问题,大佬帮忙看下日志
2024-10-28 18:28 来自 哥斯拉 发布@ Discuz! X3.5专区
网站访问后台不间断出现502问题,重启php74后恢复正常,大佬帮忙看下日志
WARNING: seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are 0 idle, and 27 total children WARNING: seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 16 children, there are 0 idle, and 32 total children WARNING: seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 32 children, there are 3 idle, and 37 tota
WARNING: seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are 0 idle, and 27 total children WARNING: seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 16 children, there are 0 idle, and 32 total children WARNING: seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 32 children, there are 3 idle, and 37 tota
网站有很多这样的错误记录
2023-03-11 15:16 来自 惧愁人 发布@ Discuz! X3.5专区
网站有很多这样的错误记录,是什么原因呢?无时无刻的在不停的出现。
2023/03/11 14:01:38 1553963#0: *27104 upstream prematurely closed FastCGI request while reading upstream, client: 222.137.81.87, server: www.XXXXXX.com, request: "GET /forum.php?mod=attachment&aid=MTkyNzd8MzViNTVmMWN8MTY2MTY2NTA1OHwwfDE0MDQ1&mobile=1&simpletype=no HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-cgi-74.sock:", host: "www.XXXXXX.com", referrer: "https://www.XXXXXX.com/forum.php?mod=attachment&aid=MTkyNzd8MzViNTVmMWN8MTY2MTY2NTA1OHwwfDE0MDQ1&mobil
2023/03/11 14:01:38 1553963#0: *27104 upstream prematurely closed FastCGI request while reading upstream, client: 222.137.81.87, server: www.XXXXXX.com, request: "GET /forum.php?mod=attachment&aid=MTkyNzd8MzViNTVmMWN8MTY2MTY2NTA1OHwwfDE0MDQ1&mobile=1&simpletype=no HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-cgi-74.sock:", host: "www.XXXXXX.com", referrer: "https://www.XXXXXX.com/forum.php?mod=attachment&aid=MTkyNzd8MzViNTVmMWN8MTY2MTY2NTA1OHwwfDE0MDQ1&mobil



