\u5927\u591a\u6570\u4eba\u5728\u4f7f\u7528\u5b9d\u5854\u7684\u65f6\u5019\u90fd\u4f1a\u9047\u5230\u8d44\u6e90\u4e0d\u8db3\u7684\u60c5\u51b5\uff0c\u7531\u4e8e\u5927\u90e8\u5206\u7f51\u7ad9\u7684\u6570\u636e\u5e93\u6027\u80fd\u9700\u6c42\u8f83\u5c0f\uff0c\u56e0\u6b64\u53ef\u4ee5\u964d\u4f4e\u6570\u636e\u5e93\u5185\u5b58\u6765\u589e\u52a0\u53ef\u7528\u5185\u5b58\u3002<\/p>\n
1.\u9996\u5148\u4f7f\u7528top\u547d\u4ee4\u663e\u793acpu\u5185\u5b58\u5360\u7528\u60c5\u51b5\uff0c\u7136\u540e\u8f93\u5165M\u5207\u6362\u5230\u6362\u5185\u5b58\u6392\u5e8f\u7684\u6a21\u5f0f\uff0c\u5982\u4e0b\u662f\u76f8\u5173\u663e\u793a\u5185\u5bb9\uff0c\u53ef\u4ee5\u770b\u5230\u6570\u636e\u5e93\u5360\u7528\u5185\u5b58\u4e3a3.3%<\/p>\n
Tasks: 134 total, 1 running, 133 sleeping, 0 stopped, 0 zombie
\n%Cpu(s): 17.5 us, 15.5 sy, 0.0 ni, 45.8 id, 9.8 wa, 0.0 hi, 0.7 si, 10.8 st
\nKiB Mem : 1014660 total, 73624 free, 860972 used, 80064 buff\/cache
\nKiB Swap: 1048572 total, 461588 free, 586984 used. 41120 avail Mem<\/p>\n
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
\n20635 www 20 0 316376 53652 1252 S 0.0 5.3 1:45.23 php-fpm
\n20880 www 20 0 303860 51560 1240 S 0.0 5.1 1:43.47 php-fpm
\n20335 www 20 0 309552 47172 1244 S 0.0 4.6 1:45.35 php-fpm
\n27093 www 20 0 309044 45388 1564 S 18.6 4.5 14:55.65 php-fpm
\n7822 www 20 0 290804 41696 444 S 0.0 4.1 1:05.54 php-fpm
\n7827 www 20 0 289876 38492 440 S 0.0 3.8 1:06.45 php-fpm
\n7832 www 20 0 300572 38476 436 S 0.0 3.8 1:04.92 php-fpm
\n20088 www 20 0 305452 38348 424 S 0.0 3.8 2:25.93 php-fpm
\n7826 www 20 0 288152 35380 440 S 0.0 3.5 1:05.41 php-fpm
\n20481 www 20 0 288056 34064 436 S 0.0 3.4 2:05.35 php-fpm
\n20803 www 20 0 284372 33960 436 S 0.0 3.3 1:42.47 php-fpm
\n2007 mysql 20 0 859620 33420 960 S 1.7 3.3 46:10.76 mysqld
\n7828 www 20 0 292940 32940 448 S 0.0 3.2 1:04.07 php-fpm
\n20945 www 20 0 286944 32808 424 S 0.0 3.2 1:54.24 php-fpm
\n7833 www 20 0 284020 31652 432 S 0.0 3.1 1:04.04 php-fpm
\n21047 www 20 0 279588 30232 416 S 0.0 3.0 1:46.65 php-fpm
\n20501 www 20 0 277936 28748 436 S 0.0 2.8 1:39.72 php-fpm<\/p>\n
2.\u67e5\u770bmysql\u7684\u914d\u7f6e\u6587\u4ef6\/etc\/my.cnf<\/p>\n
[client]
\n#password = your_password
\nport = 3306
\nsocket = \/tmp\/mysql.sock<\/p>\n
[mysqld]
\nport = 3306
\nsocket = \/tmp\/mysql.sock
\ndatadir = \/www\/server\/data
\ndefault_storage_engine = InnoDB
\nperformance_schema_max_table_instances = 400
\ntable_definition_cache = 400
\nskip-external-locking
\nkey_buffer_size = 4M
\nmax_allowed_packet = 64M
\ntable_open_cache = 32
\nsort_buffer_size = 256K
\nnet_buffer_length = 4K
\nread_buffer_size = 128K
\nread_rnd_buffer_size = 256K
\nmyisam_sort_buffer_size = 4M
\nthread_cache_size = 4
\nquery_cache_size = 4M
\ntmp_table_size = 8M
\nsql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES<\/p>\n
explicit_defaults_for_timestamp = true
\n#skip-name-resolve
\nmax_connections = 500
\nmax_connect_errors = 100
\nopen_files_limit = 65535<\/p>\n
log-bin=mysql-bin
\nbinlog_format=mixed
\nserver-id = 1
\nexpire_logs_days = 10
\nslow_query_log=1
\nslow-query-log-file=\/www\/server\/data\/mysql-slow.log
\nlong_query_time=3
\n#log_queries_not_using_indexes=on
\nearly-plugin-load = \"\"<\/p>\n
innodb_data_home_dir = \/www\/server\/data
\ninnodb_data_file_path = ibdata1:10M:autoextend
\ninnodb_log_group_home_dir = \/www\/server\/data
\ninnodb_buffer_pool_size = 16M
\ninnodb_log_file_size = 5M
\ninnodb_log_buffer_size = 8M
\ninnodb_flush_log_at_trx_commit = 1
\ninnodb_lock_wait_timeout = 50
\ninnodb_max_dirty_pages_pct = 90
\ninnodb_read_io_threads = 1
\ninnodb_write_io_threads = 1<\/p>\n
[mysqldump]
\nquick
\nmax_allowed_packet = 500M<\/p>\n
[mysql]
\nno-auto-rehash<\/p>\n
[myisamchk]
\nkey_buffer_size = 20M
\nsort_buffer_size = 20M
\nread_buffer = 2M
\nwrite_buffer = 2M<\/p>\n
[mysqlhotcopy]
\ninteractive-timeout<\/p>\n
3.\u53ef\u4fee\u6539\u9879<\/p>\n
innodb_buffer_pool_size = 16M<\/p>\n
[mysqldump]\u4e0a\u9762\u4e00\u884c\u53ef\u4ee5\u589e\u52a0\u5982\u4e0b\u5185\u5bb9<\/p>\n
performance_schema_max_table_instances=150<\/p>\n
table_definition_cache=150<\/p>\n
table_open_cache=64<\/p>\n
4.\u6700\u540e\u91cd\u542fmysql<\/p>\n
systemctl restart mysqld<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5927\u591a\u6570\u4eba\u5728\u4f7f\u7528\u5b9d\u5854\u7684\u65f6\u5019\u90fd\u4f1a\u9047\u5230\u8d44\u6e90\u4e0d\u8db3\u7684\u60c5\u51b5\uff0c\u7531\u4e8e\u5927\u90e8\u5206\u7f51\u7ad9\u7684\u6570\u636e\u5e93\u6027\u80fd\u9700\u6c42\u8f83\u5c0f\uff0c\u56e0\u6b64\u53ef\u4ee5\u964d\u4f4e\u6570\u636e\u5e93\u5185\u5b58\u6765\u589e\u52a0\u53ef\u7528\u5185\u5b58\u3002 1.\u9996\u5148\u4f7f\u7528top\u547d\u4ee4\u663e\u793acpu\u5185\u5b58\u5360\u7528\u60c5\u51b5\uff0c\u7136\u540e\u8f93\u5165M\u5207\u6362\u5230\u6362\u5185\u5b58\u6392\u5e8f\u7684\u6a21\u5f0f\uff0c\u5982\u4e0b\u662f\u76f8\u5173\u663e\u793a\u5185\u5bb9\uff0c\u53ef\u4ee5\u770b\u5230\u6570\u636e\u5e93\u5360 […]<\/p>\n","protected":false},"author":4,"featured_media":281,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33],"tags":[],"topic":[37],"class_list":["post-280","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-app","topic-linux"],"_links":{"self":[{"href":"https:\/\/idc.birk.cn\/index.php?rest_route=\/wp\/v2\/posts\/280","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/idc.birk.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/idc.birk.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/idc.birk.cn\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/idc.birk.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=280"}],"version-history":[{"count":6,"href":"https:\/\/idc.birk.cn\/index.php?rest_route=\/wp\/v2\/posts\/280\/revisions"}],"predecessor-version":[{"id":293,"href":"https:\/\/idc.birk.cn\/index.php?rest_route=\/wp\/v2\/posts\/280\/revisions\/293"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/idc.birk.cn\/index.php?rest_route=\/wp\/v2\/media\/281"}],"wp:attachment":[{"href":"https:\/\/idc.birk.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/idc.birk.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/idc.birk.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=280"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/idc.birk.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftopic&post=280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}