\u7269\u7406\u673a \uff1a ubuntu14.04 \u914d\u7f6e 8core 32G
\nmysql \uff1a 5.5.62<\/p>\n

\u8c03\u4f18\u914d\u7f6e<\/strong><\/div>\n
\r\n[client]\r\nport = 3306\r\nsocket = \/var\/run\/mysqld\/mysqld.sock\r\ndefault-character-set = utf8\r\n\r\n[mysqld_safe]\r\nsocket = \/var\/run\/mysqld\/mysqld.sock\r\n\r\n[mysqld]\r\nuser = mysql\r\npid-file = \/var\/run\/mysqld\/mysqld.pid\r\nsocket = \/var\/run\/mysqld\/mysqld.sock\r\nport = 3306\r\nbasedir = \/usr\r\ndatadir = \/var\/lib\/mysql\r\ntmpdir = \/tmp\r\nlc-messages-dir = \/usr\/share\/mysql\r\nskip-external-locking\r\n\r\n\r\nkey_buffer = 256M\r\nmax_allowed_packet = 1073741824\r\nthread_stack = 512K\r\nthread_cache_size = 50\r\nmax_connections = 5000\r\nmax_connect_errors = 1000000\r\ntable_cache = 4096\r\nmax_heap_table_size = 128M\r\nopen_files_limit = 102400\r\nback_log = 2000\r\nthread_concurrency = 20\r\n\r\nsort_buffer_size = 524288\r\nft_min_word_len = 4\r\nquery_cache_size = 0\r\n\r\n\r\nlog_error = \/var\/log\/mysql\/error.log\r\nlog_slow_queries = \/var\/log\/mysql\/mysql-slow.log\r\nlong_query_time = 3\r\n\r\nserver-id = 1\r\nlog_bin = \/var\/log\/mysql\/mysql-bin.log\r\nexpire_logs_days = 2\r\n\r\ntmp_table_size = 4294967295\r\n\r\n#default_table_type = InnoDB\r\n\r\n#loose-skip-bdb\r\ndefault-storage-engine =InnoDB\r\ninnodb_file_format=barracuda\r\n#ROW_FORMAT=COMPRESSED\r\ninnodb_additional_mem_pool_size = 64M\r\ninnodb_buffer_pool_size = 6G\r\ninnodb_data_file_path = ibdata1:128M:autoextend\r\ninnodb_read_io_threads = 8\r\ninnodb_write_io_threads = 8\r\ninnodb_thread_concurrency = 20\r\ninnodb_flush_log_at_trx_commit = 2\r\ninnodb_log_buffer_size = 8388608\r\ninnodb_log_file_size = 512M\r\ninnodb_log_files_in_group = 3\r\ninnodb_max_dirty_pages_pct = 90\r\ninnodb_lock_wait_timeout = 120\r\n\r\n\r\n[mysqldump]\r\nquick\r\nquote-names\r\nmax_allowed_packet = 1073741824\r\n\r\n\r\n[mysql]\r\ndefault-character-set = utf8\r\n\r\n[isamchk]\r\nkey_buffer = 256M\r\n\r\n!includedir \/etc\/mysql\/conf.d\/\r\n<\/pre>\n
\u9644\u4e00\u4e9b\u53c2\u6570\u7684\u7b80\u5355\u89e3\u91ca<\/strong><\/p>\n
\r\n# The MySQL database server configuration file.\r\n#\r\n# You can copy this to one of:\r\n# - \"\/etc\/mysql\/my.cnf\" to set global options,\r\n# - \"~\/.my.cnf\" to set user-specific options.\r\n# \r\n# One can use all long options that the program supports.\r\n# Run program with --help to get a list of available options and with\r\n# --print-defaults to see which it would actually understand and use.\r\n#\r\n# For explanations see\r\n# http:\/\/dev.mysql.com\/doc\/mysql\/en\/server-system-variables.html\r\n\r\n# This will be passed to all mysql clients\r\n# It has been reported that passwords should be enclosed with ticks\/quotes\r\n# escpecially if they contain \"#\" chars...\r\n# Remember to edit \/etc\/mysql\/debian.cnf when changing the socket location.\r\n[client]\r\nport = 3306\r\nsocket = \/var\/run\/mysqld\/mysqld.sock\r\n\r\n# Here is entries for some specific programs\r\n# The following values assume you have at least 32M ram\r\n\r\n# This was formally known as [safe_mysqld]. Both versions are currently parsed.\r\n[mysqld_safe]\r\nsocket = \/var\/run\/mysqld\/mysqld.sock\r\nnice = 0\r\nopen-files-limit = 8192 #\u589e\u52a0\u6bcf\u4e2a\u8fdb\u7a0b\u7684\u53ef\u6253\u5f00\u6587\u4ef6\u6570\u91cf\r\n[mysqld]\r\n#\r\n# * Basic Settings\r\n#\r\nuser = mysql\r\npid-file = \/var\/run\/mysqld\/mysqld.pid\r\nsocket = \/var\/run\/mysqld\/mysqld.sock\r\nport = 3306\r\nbasedir = \/usr\r\ndatadir = \/var\/lib\/mysql\r\ntmpdir = \/tmp #\u8bb0\u5f55msyql\u4e34\u65f6\u6587\u4ef6\r\n#back_log = 300 \r\nlc-messages-dir = \/usr\/share\/mysql\r\nskip-external-locking #\u5141\u8bb8\u5916\u90e8\u6587\u4ef6\u7ea7\u522b\u7684\u9501. \u6253\u5f00\u6587\u4ef6\u9501\u4f1a\u5bf9\u6027\u80fd\u9020\u6210\u8d1f\u9762\u5f71\u54cd\r\n#\r\n# Instead of skip-networking the default is now to listen only on\r\n# localhost which is more compatible and is not less secure.\r\n#bind-address = 0.0.0.0 #\u63a7\u5236\u53ef\u8fde\u63a5\u6570\u636e\u5e93\u7684 \u5ba2\u6237\u7aef\r\n#\r\n# * Fine Tuning\r\n#\r\nkey_buffer = 16M #\u53ef\u53d8\u5927 \u5f85\u67e5\u8be2 \u7528\u4e8e\u7d22\u5f15\u5757\u7f13\u51b2\u533a\u5927\u5c0f\r\nmax_allowed_packet = 16M \r\nthread_stack = 192K #\u7ebf\u7a0b\u4f7f\u7528\u7684\u5806\u5927\u5c0f. \u6b64\u5bb9\u91cf\u7684\u5185\u5b58\u5728\u6bcf\u6b21\u8fde\u63a5\u65f6\u88ab\u9884\u7559\r\nthread_cache_size = 8 #cache\u4e2d\u4fdd\u7559\u591a\u5c11\u7ebf\u7a0b\u7528\u4e8e\u91cd\u7528\r\n# This replaces the startup script and checks MyISAM tables if needed\r\n# the first time they are touched\r\nmyisam-recover = BACKUP\r\nmax_connections = 100 #mysql \u5141\u8bb8 \u540c\u65f6\u4f1a\u8bdd\u7684\u4e0a\u9650\r\nmax_connect_errors = 30 #mysql \u5141\u8bb8\u6700\u5927\u7684\u9519\u8bef\u8fde\u63a5\u4e0a\u9650\r\ntable_cache = 64 #mysql\u6240\u6709\u7ebf\u7a0b\u6253\u5f00\u8868\u7684\u6570\u91cf \uff0c\u9700\u5bf9\u5e94\u7684open_files_limit \u5141\u8bb8\r\nmax_heap_table_size = 128M #\u72ec\u7acb\u7684\u5185\u5b58\u8868\u6240\u5141\u8bb8\u7684\u6700\u5927\u5bb9\u91cf\uff08\u9632\u6b62\u610f\u5916\u521b\u5efa\u4e00\u4e2a\u8d85\u5927\u7684\u5185\u5b58\u8868\u5bfc\u81f4\u7528\u5c3d\u6240\u6709\u7684\u5185\u5b58\u8d44\u6e90\uff09\r\nopen_files_limit = 10240 #mysql\u5141\u8bb8\u6253\u5f00\u6700\u5927\u6587\u4ef6\u6570\r\nback_log = 300 #\u64cd\u4f5c\u7cfb\u7edf\u5728\u76d1\u542c\u961f\u5217\u4e2d\u6240\u4fdd\u6301\u7684\u8fde\u63a5\u6570\r\n\r\nthread_concurrency = 10 #\u5e94\u7528\u7a0b\u5e8f\u7ed9\u4e88\u7ebf\u7a0b\u7cfb\u7edf\u4e00\u4e2a\u63d0\u793a\u5728\u540c\u4e00\u65f6\u95f4\u7ed9\u4e88\u6e34\u671b\u88ab\u8fd0\u884c\u7684\u7ebf\u7a0b\u7684\u6570\u91cf\r\n#\r\n# * Query Cache Configuration\r\n#\r\nsort_buffer_size = 16M #\u6392\u5e8f\u53d1\u751f\u65f6\u6bcf\u4e2a\u7ebf\u7a0b\u5206\u914d\r\njoin_buffer_size = 16M #\u5f53\u5168\u8054\u5408\u53d1\u751f\u65f6,\u5728\u6bcf\u4e2a\u7ebf\u7a0b\u4e2d\u5206\u914d\r\nquery_cache_limit = 1M #\u53ea\u6709\u5c0f\u4e8e\u6b64\u8bbe\u5b9a\u503c\u7684\u7ed3\u679c\u624d\u4f1a\u88ab\u7f13\u51b2\r\nquery_cache_size = 16M #\u67e5\u8be2\u7f13\u51b2\u5e38\u88ab\u7528\u6765\u7f13\u51b2 SELECT \u7684\u7ed3\u679c\u5e76\u4e14\u5728\u4e0b\u4e00\u6b21\u540c\u6837\u67e5\u8be2\u7684\u65f6\u5019\u4e0d\u518d\u6267\u884c\u76f4\u63a5\u8fd4\u56de\u7ed3\u679c\r\nft_min_word_len = 8 #\u88ab\u5168\u6587\u68c0\u7d22\u7d22\u5f15\u7684\u6700\u5c0f\u7684\u5b57\u957f\r\n\r\n#memlock #\u5982\u679c\u4f60\u7684\u7cfb\u7edf\u652f\u6301 memlock() \u51fd\u6570,\u4f60\u4e5f\u8bb8\u5e0c\u671b\u6253\u5f00\u6b64\u9009\u9879\u7528\u4ee5\u8ba9\u8fd0\u884c\u4e2d\u7684mysql\u5728\u5728\u5185\u5b58\u9ad8\u5ea6\u7d27\u5f20\u7684\u65f6\u5019,\u6570\u636e\u5728\u5185\u5b58\u4e2d\u4fdd\u6301\u9501\u5b9a\u5e76\u4e14\u9632\u6b62\u53ef\u80fd\u88abswapping out\r\n#\r\n# * Logging and Replication\r\n#\r\n# Both location gets rotated by the cronjob.\r\n# Be aware that this log type is a performance killer.\r\n# As of 5.1 you can enable the log at runtime!\r\n#general_log_file = \/var\/log\/mysql\/mysql.log\r\n#general_log = 1\r\n#\r\n# Error log - should be very few entries.\r\n#\r\n#log #\u6253\u5f00\u5168\u67e5\u8be2\u65e5\u5fd7. \u6240\u6709\u7684\u7531\u670d\u52a1\u5668\u63a5\u6536\u5230\u7684\u67e5\u8be2 (\u751a\u81f3\u5bf9\u4e8e\u4e00\u4e2a\u9519\u8bef\u8bed\u6cd5\u7684\u67e5\u8be2\uff09 \u7528\u4e8e\u8c03\u8bd5\u73af\u5883\r\n#log_warnings #\u5c06\u8b66\u544a\u6253\u5370\u8f93\u51fa\u5230\u9519\u8beflog\u6587\u4ef6\r\nlog_error = \/var\/log\/mysql\/error.log\r\n# Here you can see queries with especially long duration\r\nlog_slow_queries = \/var\/log\/mysql\/mysql-slow.log #\u5f00\u542f\u6162\u65e5\u5fd7\r\nlong_query_time = 2 #\u6162\u65e5\u5fd7\u65f6\u95f4\u754c\u9650\r\nlog_long_format #\u5728\u6162\u901f\u65e5\u5fd7\u4e2d\u8bb0\u5f55\u66f4\u591a\u7684\u4fe1\u606f \r\n#log-queries-not-using-indexes\r\n#\r\n# The following can be used as easy to replay backup logs or for replication.\r\n# note: if you are setting up a replication slave, see README.Debian about\r\n# other settings you may need to change.\r\nserver-id = 1 #\u4e3b\u4eceid\r\nlog_bin = \/var\/log\/mysql\/mysql-bin.log #\u5f00\u542f\u4e8c\u8fdb\u5236\r\nexpire_logs_days = 10\r\nmax_binlog_size = 100M\r\nbinlog_cache_size = 4M #\u5728\u4e00\u4e2a\u4e8b\u52a1\u4e2dbinlog \u4e3a\u4e86\u8bb0\u5f55sql\u72b6\u6001\u6240\u6301\u6709\u7684cache\u5927\u5c0f\r\n#binlog_do_db = include_database_name\r\n#binlog_ignore_db = include_database_name\r\nlog_slave_updates #\u4e3b\u4ece\u65e5\u5fd7\r\n#\r\n# * InnoDB\r\n#\r\n# InnoDB is enabled by default with a 10MB datafile in \/var\/lib\/mysql\/.\r\n# Read the manual for more InnoDB related options. There are many!\r\ndefault_table_type = MYISAM #\u5f53\u521b\u5efa\u65b0\u8868\u65f6\u4f5c\u4e3a\u9ed8\u8ba4\u4f7f\u7528\u7684\u8868\u7c7b\u578b, \r\ntransaction_isolation = REPEATABLE-READ #\u8bbe\u5b9a\u9ed8\u8ba4\u7684\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b.\u53ef\u7528\u7684\u7ea7\u522b\u5982\u4e0b: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE\r\ntmp_table_size = 128M #\u5185\u90e8(\u5185\u5b58\u4e2d)\u4e34\u65f6\u8868\u7684\u6700\u5927\u5927\u5c0f\r\n\r\n\r\n#\r\n# * Security Features\r\n#\r\n# Read the manual, too, if you want chroot!\r\n# chroot = \/var\/lib\/mysql\/\r\n#\r\n# For generating SSL certificates I recommend the OpenSSL GUI \"tinyca\".\r\n#\r\n# ssl-ca=\/etc\/mysql\/cacert.pem\r\n# ssl-cert=\/etc\/mysql\/server-cert.pem\r\n# ssl-key=\/etc\/mysql\/server-key.pem\r\n\r\n\r\n# MyISAM \u76f8\u5173\u9009\u9879\r\n#read_buffer_size = 8M #\u7528\u6765\u505aMyISAM\u8868\u5168\u8868\u626b\u63cf\u7684\u7f13\u51b2\u5927\u5c0f\r\n#read_rnd_buffer_size = 64M #\u5f53\u5728\u6392\u5e8f\u4e4b\u540e,\u4ece\u4e00\u4e2a\u5df2\u7ecf\u6392\u5e8f\u597d\u7684\u5e8f\u5217\u4e2d\u8bfb\u53d6\u884c\u65f6,\u884c\u6570\u636e\u5c06\u4ece\u8fd9\u4e2a\u7f13\u51b2\u4e2d\u8bfb\u53d6\u6765\u9632\u6b62\u78c1\u76d8\u5bfb\u9053\r\n#bulk_insert_buffer_size = 256M #MyISAM \u4f7f\u7528\u7279\u6b8a\u7684\u7c7b\u4f3c\u6811\u7684cache\u6765\u4f7f\u5f97\u7a81\u53d1\u63d2\u5165\r\n#myisam_sort_buffer_size = 256M #\u6b64\u7f13\u51b2\u5f53MySQL\u9700\u8981\u5728 REPAIR, OPTIMIZE, ALTER \u4ee5\u53ca LOAD DATA INFILE \u5230\u4e00\u4e2a\u7a7a\u8868\u4e2d\u5f15\u8d77\u91cd\u5efa\u7d22\u5f15\u65f6\u88ab\u5206\u914d.\r\n#myisam_max_sort_file_size = 10G #MySQL\u91cd\u5efa\u7d22\u5f15\u65f6\u6240\u5141\u8bb8\u7684\u6700\u5927\u4e34\u65f6\u6587\u4ef6\u7684\u5927\u5c0f (\u5f53 REPAIR, ALTER TABLE \u6216\u8005 LOAD DATA INFILE).\r\n#myisam_max_extra_sort_file_size = 10G #\u5982\u679c\u88ab\u7528\u6765\u66f4\u5feb\u7684\u7d22\u5f15\u521b\u5efa\u7d22\u5f15\u6240\u4f7f\u7528\u4e34\u65f6\u6587\u4ef6\u5927\u4e8e\u5236\u5b9a\u7684\u503c,\u90a3\u5c31\u4f7f\u7528\u952e\u503c\u7f13\u51b2\u65b9\u6cd5.\r\n#myisam_repair_threads = 1 #\u5982\u679c\u4e00\u4e2a\u8868\u62e5\u6709\u8d85\u8fc7\u4e00\u4e2a\u7d22\u5f15, MyISAM \u53ef\u4ee5\u901a\u8fc7\u5e76\u884c\u6392\u5e8f\u4f7f\u7528\u8d85\u8fc7\u4e00\u4e2a\u7ebf\u7a0b\u53bb\u4fee\u590d\u4ed6\u4eec\r\n#myisam_recover #\u81ea\u52a8\u68c0\u67e5\u548c\u4fee\u590d\u6ca1\u6709\u9002\u5f53\u5173\u95ed\u7684 MyISAM \u8868\r\n\r\n\r\n#INNODB \u76f8\u5173\u9009\u9879\r\n#skip-innodb #\u5982\u679c\u4f60\u7684MySQL\u670d\u52a1\u5305\u542bInnoDB\u652f\u6301\u4f46\u662f\u5e76\u4e0d\u6253\u7b97\u4f7f\u7528\u7684\u8bdd,\r\n#innodb_additional_mem_pool_size = 64M #\u9644\u52a0\u7684\u5185\u5b58\u6c60\u88abInnoDB\u7528\u6765\u4fdd\u5b58 metadata \u4fe1\u606f\r\n#innodb_buffer_pool_size = 6G #InnoDB\u4f7f\u7528\u4e00\u4e2a\u7f13\u51b2\u6c60\u6765\u4fdd\u5b58\u7d22\u5f15\u548c\u539f\u59cb\u6570\u636e, \u4e0d\u50cf MyISAM\r\n#innodb_data_file_path = ibdata1:10M:autoextend #InnoDB \u5c06\u6570\u636e\u4fdd\u5b58\u5728\u4e00\u4e2a\u6216\u8005\u591a\u4e2a\u6570\u636e\u6587\u4ef6\u4e2d\u6210\u4e3a\u8868\u7a7a\u95f4\r\n#innodb_data_home_dir = #\u8bbe\u7f6e\u6b64\u9009\u9879\u5982\u679c\u4f60\u5e0c\u671bInnoDB\u8868\u7a7a\u95f4\u6587\u4ef6\u88ab\u4fdd\u5b58\u5728\u5176\u4ed6\u5206\u533a\r\n#innodb_file_io_threads = 4 #\u7528\u6765\u540c\u6b65IO\u64cd\u4f5c\u7684IO\u7ebf\u7a0b\u7684\u6570\u91cf.\r\n#innodb_force_recovery=1 #\u5982\u679c\u4f60\u53d1\u73b0InnoDB\u8868\u7a7a\u95f4\u635f\u574f, \u8bbe\u7f6e\u6b64\u503c\u4e3a\u4e00\u4e2a\u975e\u96f6\u503c\u53ef\u80fd\u5e2e\u52a9\u4f60\u5bfc\u51fa\u4f60\u7684\u8868\r\n#innodb_thread_concurrency = 16 #\u5728InnoDb\u6838\u5fc3\u5185\u7684\u5141\u8bb8\u7ebf\u7a0b\u6570\u91cf\r\n#innodb_flush_log_at_trx_commit = 2 #\u5982\u679c\u8bbe\u7f6e\u4e3a1 ,InnoDB\u4f1a\u5728\u6bcf\u6b21\u63d0\u4ea4\u540e\u5237\u65b0(fsync)\u4e8b\u52a1\u65e5\u5fd7\u5230\u78c1\u76d8\u4e0a \u5982\u679c\u662f\u6e38\u620f\u670d\u52a1\u5668\uff0c\u5efa\u8bae\u6b64\u503c\u8bbe\u7f6e\u4e3a2\uff1b\u5982\u679c\u662f\u5bf9\u6570\u636e\u5b89\u5168\u8981\u6c42\u6781\u9ad8\u7684\u5e94\u7528\uff0c\u5efa\u8bae\u8bbe\u7f6e\u4e3a1\r\n#innodb_fast_shutdown #\u52a0\u901fInnoDB\u7684\u5173\u95ed. \u8fd9\u4f1a\u963b\u6b62InnoDB\u5728\u5173\u95ed\u65f6\u505a\u5168\u6e05\u9664\u4ee5\u53ca\u63d2\u5165\u7f13\u51b2\u5408\u5e76.\r\n#innodb_log_buffer_size = 16M #\u7528\u6765\u7f13\u51b2\u65e5\u5fd7\u6570\u636e\u7684\u7f13\u51b2\u533a\u7684\u5927\u5c0f.\r\n#innodb_log_file_size = 512M #\u5728\u65e5\u5fd7\u7ec4\u4e2d\u6bcf\u4e2a\u65e5\u5fd7\u6587\u4ef6\u7684\u5927\u5c0f. \r\n#innodb_log_files_in_group = 3 #\u5728\u65e5\u5fd7\u7ec4\u4e2d\u7684\u6587\u4ef6\u603b\u6570.\r\n#innodb_log_group_home_dir #InnoDB\u7684\u65e5\u5fd7\u6587\u4ef6\u6240\u5728\u4f4d\u7f6e. \u9ed8\u8ba4\u662fMySQL\u7684datadir\r\n#innodb_max_dirty_pages_pct = 90 #\u5728InnoDB\u7f13\u51b2\u6c60\u4e2d\u6700\u5927\u5141\u8bb8\u7684\u810f\u9875\u9762\u7684\u6bd4\u4f8b.\r\n#innodb_flush_method=O_DSYNC #InnoDB\u7528\u6765\u5237\u65b0\u65e5\u5fd7\u7684\u65b9\u6cd5 \u8868\u7a7a\u95f4\u603b\u662f\u4f7f\u7528\u53cc\u91cd\u5199\u5165\u5237\u65b0\u65b9\u6cd5 # \u9ed8\u8ba4\u503c\u662f \u201cfdatasync\u201d, \u53e6\u4e00\u4e2a\u662f \u201cO_DSYNC\u201d\r\n#innodb_lock_wait_timeout = 120 #\u5728\u88ab\u56de\u6eda\u524d,\u4e00\u4e2aInnoDB\u7684\u4e8b\u52a1\u5e94\u8be5\u7b49\u5f85\u4e00\u4e2a\u9501\u88ab\u6279\u51c6\u591a\u4e45\r\n[mysqldump]\r\nquick\r\nquote-names\r\nmax_allowed_packet = 16M ## \u670d\u52a1\u6240\u80fd\u5904\u7406\u7684\u8bf7\u6c42\u5305\u7684\u6700\u5927\u5927\u5c0f\u4ee5\u53ca\u670d\u52a1\u6240\u80fd\u5904\u7406\u7684\u6700\u5927\u7684\u8bf7\u6c42\u5927\u5c0f(\u5f53\u4e0e\u5927\u7684BLOB\u5b57\u6bb5\u4e00\u8d77\u5de5\u4f5c\u65f6\u76f8\u5f53\u5fc5\u8981)\r\n\r\n#safe-updates #\u4ec5\u4ec5\u5141\u8bb8\u4f7f\u7528\u952e\u503c\u7684 UPDATEs \u548c DELETEs \r\n[mysql]\r\n#no-auto-rehash # faster start of mysql but no tab completition \r\n\r\n[isamchk]\r\nkey_buffer = 16M\r\nsort_buffer_size = 2048M\r\nread_buffer = 32M\r\nwrite_buffer = 32M\r\n#\r\n# * IMPORTANT: Additional settings that can override those from this file!\r\n# The files must end with '.cnf', otherwise they'll be ignored.\r\n#\r\n[myisamchk]\r\nkey_buffer = 2048M\r\nsort_buffer_size = 2048M\r\nread_buffer = 32M\r\nwrite_buffer = 32M\r\n\r\n\r\n[mysqlhotcopy]\r\ninteractive-timeout\r\n\r\n\r\n!includedir \/etc\/mysql\/conf.d\/\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
\u7269\u7406\u673a \uff1a ubuntu14.04 \u914d\u7f6e 8core 32G mysql \uff1a 5.5.62 [client] […]<\/p>\n","protected":false},"author":63,"featured_media":145823,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[55],"tags":[],"class_list":["post-145821","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thread"],"acf":[],"_links":{"self":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/145821","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/users\/63"}],"replies":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/comments?post=145821"}],"version-history":[{"count":4,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/145821\/revisions"}],"predecessor-version":[{"id":145898,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/145821\/revisions\/145898"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/media\/145823"}],"wp:attachment":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/media?parent=145821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/categories?post=145821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/tags?post=145821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}