메뉴 건너뛰기

XEDITION

tech

OS : CentOS7 MySQL : install rpm package from mysql official repository 1. mysql error log [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 16384) [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 3000) [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 2048) 2. modify service file file path : /usr/lib/systemd/system/mysqld.service add LimitNOFILE=163840 LimitNPROC=163840 3. reload # systemctl daemon-reload for this error message… Warning: mysqld.service changed on disk. Run ’systemctl daemon-reload’ to reload units. 4. Restart mysql # service mysqld restart

The post [mysql] Buffered warning: Could not increase number of max_open_files to more than 1024 on centos appeared first on 지락문화예술공작단.




원문출처 : https://jirak.net/wp/mysql-buffered-warning-not-increase-number-max_open_files-1024-centos/
번호 제목 글쓴이 날짜 조회 수
124 Mozilla SSL Configuration Generator 관리자 2016.10.15 24
123 mysql server system variables log_warnings to log_error_verbosity 관리자 2016.10.05 58
122 [MariaDB] InnoDB: Redo log crypto: failed to decrypt log block 관리자 2016.09.28 53
» [mysql] Buffered warning: Could not increase number of max_open_files to more than 1024 on centos 관리자 2016.09.08 68
120 Unable to validate certificate chain in aws elb – comodossl 관리자 2016.09.06 134
119 WordPress 4.6 “Pepper” 관리자 2016.08.17 18
118 리눅스 서버의 TCP 네트워크 성능을 결정짓는 커널 파라미터 이야기 – 3편 관리자 2016.08.12 41
117 리눅스 서버의 TCP 네트워크 성능을 결정짓는 커널 파라미터 이야기 – 2편 관리자 2016.08.12 33
116 리눅스 서버의 TCP 네트워크 성능을 결정짓는 커널 파라미터 이야기 – 1편 관리자 2016.08.12 46
115 WordPress 4.6 Release Candidate 관리자 2016.07.28 18
114 Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MariaDB client in /home1/htdocs/apartzm/affisacc/php/acc_tongys.inc.php on line 188ERROR 1251: Client does not smysql_connect(): Client 관리자 2016.07.26 41
113 WordPress 4.6 Beta 3 관리자 2016.07.14 13
112 mysqlbinlog: unknown variable ‘default-character-set=utf8’ 관리자 2016.07.09 20
111 WordPress 4.6 Beta 1 관리자 2016.06.30 9
110 $_SERVER[‘SERVER_SOFTWARE’]=’Apache’ in wp-config.php 관리자 2016.06.24 25
위로