dyunok 发表于 2015-8-20 14:51:39

谢谢军哥，用上了，军哥很敬业呵，向你学习！致敬！

Wention 发表于 2016-2-25 21:59:33

MYSQL是5.5.42 我是lnmp1.2的，为何我替换了etc下的my.cnf文件不行的？如果用默认my.cnf，动态文件就很卡或者502错误，如果替换为my-huge的话，后台可以打开，但是出现No such file or directory。我的机器是linode 1G的RAM 1CPU

[ 本帖最后由 Wention 于 2016-2-25 22:09 编辑 ]

licess 发表于 2016-2-26 10:34:03

回复 17# 的帖子

什么地方报No such file or directory？
mysql日志有什么信息？
502时php-fpm和慢日志有什么信息？
反馈问题要尽可能提供多的信息

Wention 发表于 2016-2-26 13:22:40

回复 18# 的帖子

No such file or directory是动态页面或者后台会出现，php-fpm重启了就不会卡，但是过会儿就卡成渣我是用飞飞CMS我试了下，如果把my.cnf替换了，可以打开播放页，但是搜索和后台会出现No such file or directory

[ 本帖最后由 Wention 于 2016-2-27 13:14 编辑 ]

Wention 发表于 2016-2-27 11:14:00

始终502好蛋疼啊~！不知道怎么解决，哎

qiqiy_rui 发表于 2017-3-14 10:45:55

同时在线如达到几百个人，一会网站就挂掉，显示no such file or directory

军哥，你的忠实粉丝，默默支持了你好几年~~， 这几天网站只要达到同时几百人在线，就挂掉，出现no such file or directory，应该是mysql死掉了，差看mysql， 得到如下mysql垂死挣扎的过程:

170313 21:40:11 Event Scheduler: Loaded 0 events
170313 21:40:11 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170313 23:24:56 mysqld_safe Number of processes running now: 0
170313 23:24:56 mysqld_safe mysqld restarted
170313 23:24:56 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 18163 ...
170313 23:24:56 Plugin 'FEDERATED' is disabled.
170313 23:24:56 InnoDB: The InnoDB memory heap is disabled
170313 23:24:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170313 23:24:56 InnoDB: Compressed tables use zlib 1.2.3
170313 23:24:56 InnoDB: Initializing buffer pool, size = 128.0M
170313 23:24:56 InnoDB: Completed initialization of buffer pool
170313 23:24:56 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 1589182633
170313 23:24:56InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1589183080
170313 23:24:56InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 5299928, file name ./mysql-bin.000018
170313 23:24:57InnoDB: Waiting for the background threads to start
170313 23:24:58 InnoDB: 5.5.48 started; log sequence number 1589183080
170313 23:24:58 Recovering after a crash using mysql-bin
170313 23:24:58 Starting crash recovery...
170313 23:24:58 Crash recovery finished.
170313 23:24:58 Server hostname (bind-address): '0.0.0.0'; port: 3306
170313 23:24:58    - '0.0.0.0' resolves to '0.0.0.0';
170313 23:24:58 Server socket created on IP: '0.0.0.0'.
170313 23:24:58 Event Scheduler: Loaded 0 events
170313 23:24:58 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
170313 23:56:21 mysqld_safe Number of processes running now: 0
170313 23:56:21 mysqld_safe mysqld restarted
170313 23:56:21 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 18532 ...
170313 23:56:21 Plugin 'FEDERATED' is disabled.
170313 23:56:21 InnoDB: The InnoDB memory heap is disabled
170313 23:56:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170313 23:56:21 InnoDB: Compressed tables use zlib 1.2.3
170313 23:56:21 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
170313 23:56:21 InnoDB: Completed initialization of buffer pool
170313 23:56:21 InnoDB: Fatal error: cannot allocate memory for the buffer pool
170313 23:56:21 Plugin 'InnoDB' init function returned error.
170313 23:56:21 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170313 23:56:21 Unknown/unsupported storage engine: InnoDB
170313 23:56:21 Aborting

170313 23:56:21 /usr/local/mysql/bin/mysqld: Shutdown complete

170313 23:56:21 mysqld_safe mysqld from pid file /usr/local/mysql/var/li1206-174.pid ended


用的是 Linode 4096系列主机，想问一下是主机不行还是需要更改mysql的什么配置文件？ 如下是php-fpm 设置


listen = /tmp/php-cgi.sock
listen.backlog = -1
listen.allowed_clients = 127.0.0.1
listen.owner = www
listen.group = www
listen.mode = 0666
user = www
group = www
pm = dynamic
pm.max_children = 50
pm.start_servers = 30
pm.min_spare_servers = 20
pm.max_spare_servers = 50
request_terminate_timeout = 100
request_slowlog_timeout = 0
slowlog = var/log/slow.log


恳请军哥看到了回复下...

licess 发表于 2017-3-14 15:55:44

回复 21# 的帖子

只按这个日志看是内存不够用了，需要调小innodb_buffer_pool_size的值，调小再看看

qiqiy_rui 发表于 2017-3-14 17:58:47

回复 22# 的帖子

谢谢军哥回复，我先改改试试~

qiqiy_rui 发表于 2017-5-14 12:21:23

军哥，修改后再也没有出现网站崩溃的情况了，太感谢了

520dchk 发表于 2022-11-2 15:27:25

请问军哥，此篇优化参数现在还适用吗？谢谢。

licess 发表于 2022-11-2 16:16:20

520dchk 发表于 2022-11-2 15:27
请问军哥，此篇优化参数现在还适用吗？谢谢。

参数都还是那些

520dchk 发表于 2022-11-2 19:04:37

licess 发表于 2022-11-2 16:16
参数都还是那些

好的，谢谢。
页: 1 [2]
查看完整版本: 请问独立服务器php，mysql ，nginx 配置文件什么参数可以优化调整