{"id":398,"date":"2017-04-12T18:56:37","date_gmt":"2017-04-12T10:56:37","guid":{"rendered":"https:\/\/blog.freesilo.com\/?p=398"},"modified":"2017-04-12T18:56:37","modified_gmt":"2017-04-12T10:56:37","slug":"mysql%e5%9c%a8512m%e4%bb%a5%e4%b8%8b%e5%b0%8f%e5%86%85%e5%ad%98vps%e4%b8%8a%e7%9a%84%e4%bc%98%e5%8c%96%e8%ae%be%e7%bd%ae","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=398","title":{"rendered":"MySQL\u5728512M\u4ee5\u4e0b\u5c0f\u5185\u5b58VPS\u4e0a\u7684\u4f18\u5316\u8bbe\u7f6e"},"content":{"rendered":"<p>\u505a\u7f51\u7ad9\u7684\u65f6\u5019\u9009\u6570\u636e\u5e93\uff0cMySQL\u662f\u9996\u9009\uff0c\u4f46\u662f\u670d\u52a1\u5668\u914d\u7f6e\u4e0d\u9ad8\uff0c\u5982\u679c\u4e0d\u4f18\u5316\u7684\u8bdd\uff0c\u670d\u52a1\u5668\u5185\u5b58\u5b8c\u5168\u4e0d\u591f\u3002\u4e8e\u662f\u627e\u4e86\u4e00\u4e9b\u56fd\u5916\u5927\u795e\u7684\u4f18\u5316\u5b9e\u4f8b\uff0c\u5e0c\u671b\u80fd\u7ed9\u5927\u5bb6\u4e00\u4e9b\u542f\u53d1\u3002<\/p>\n<h2>MySQL\u8bbe\u7f6e\u9879<\/h2>\n<p>\u4e0b\u9762\u4e00\u5f20\u8868\u683c\u662f\u6211\u4ece\u56fd\u5916\u7684\u4e00\u4e2a\u535a\u5ba2\u91cc\u8fb9\u6458\u6284\u4e0b\u6765\u7684MySQL\u7684\u4e00\u4e9b\u9ed8\u8ba4\u914d\u7f6e\u9879\u548c\u6700\u4f4e\u8bbe\u7f6e\u53c2\u6570\u3002<\/p>\n<table>\n<tbody>\n<tr>\n<td>\u8bbe\u7f6e\u9879<\/td>\n<td>\u9ed8\u8ba4<\/td>\n<td>\u6700\u4f4e<\/td>\n<\/tr>\n<tr>\n<td>innodb_buffer_pool_size<\/td>\n<td>128M<\/td>\n<td>5M<\/td>\n<\/tr>\n<tr>\n<td>innodb_log_buffer_size<\/td>\n<td>1M<\/td>\n<td>256K<\/td>\n<\/tr>\n<tr>\n<td>query_cache_size<\/td>\n<td>1M<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>max_connections<\/td>\n<td>151<\/td>\n<td>1 (\u63a8\u8350\u6700\u4f4e\u8bbe\u7f6e\u4e3a10)<\/td>\n<\/tr>\n<tr>\n<td>key_buffer_size<\/td>\n<td>8388608<\/td>\n<td>8<\/td>\n<\/tr>\n<tr>\n<td>thread_cache_size<\/td>\n<td>(\u81ea\u52a8\u914d\u7f6e)<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>host_cache_size<\/td>\n<td>(\u81ea\u52a8\u914d\u7f6e)<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>innodb_ft_cache_size<\/td>\n<td>8000000<\/td>\n<td>1600000<\/td>\n<\/tr>\n<tr>\n<td>innodb_ft_total_cache_size<\/td>\n<td>640000000<\/td>\n<td>32000000<\/td>\n<\/tr>\n<tr>\n<td>thread_stack<\/td>\n<td>262144<\/td>\n<td>131072<\/td>\n<\/tr>\n<tr>\n<td>sort_buffer_size<\/td>\n<td>262144<\/td>\n<td>32K<\/td>\n<\/tr>\n<tr>\n<td>read_buffer_size<\/td>\n<td>131072<\/td>\n<td>8200<\/td>\n<\/tr>\n<tr>\n<td>read_rnd_buffer_size<\/td>\n<td>262144<\/td>\n<td>8200<\/td>\n<\/tr>\n<tr>\n<td>max_heap_table_size<\/td>\n<td>16777216<\/td>\n<td>16K<\/td>\n<\/tr>\n<tr>\n<td>tmp_table_size<\/td>\n<td>16777216<\/td>\n<td>1K<\/td>\n<\/tr>\n<tr>\n<td>bulk_insert_buffer_size<\/td>\n<td>8388608<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>join_buffer_size<\/td>\n<td>262144<\/td>\n<td>128<\/td>\n<\/tr>\n<tr>\n<td>net_buffer_length<\/td>\n<td>16384<\/td>\n<td>1K<\/td>\n<\/tr>\n<tr>\n<td>innodb_sort_buffer_size<\/td>\n<td>1M<\/td>\n<td>64K<\/td>\n<\/tr>\n<tr>\n<td>binlog_cache_size<\/td>\n<td>32K<\/td>\n<td>4K<\/td>\n<\/tr>\n<tr>\n<td>binlog_stmt_cache_size<\/td>\n<td>32K<\/td>\n<td>4K<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>MySQL\u4f18\u5316\u8bbe\u7f6e<\/h2>\n<p>\u4f9d\u636e\u4ee5\u4e0a\u53c2\u6570\uff0cMySQL\u7684\u6700\u5c0f\u914d\u7f6e\u4e3a\uff1a<\/p>\n<div id=\"crayon-584fc08faf2dd514177655\" class=\"crayon-syntax crayon-theme-github crayon-font-consolas crayon-os-pc print-yes notranslate crayon-wrapped\" data-settings=\" no-popup minimize scroll-always disable-anim wrap\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-1\">1<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-3\">3<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-5\">5<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-7\">7<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-9\">9<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-11\">11<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-13\">13<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-15\">15<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-16\">16<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-17\">17<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-18\">18<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-19\">19<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-20\">20<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-21\">21<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-22\">22<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-23\">23<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-24\">24<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-25\">25<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2dd514177655-26\">26<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-584fc08faf2dd514177655-1\" class=\"crayon-line\"><span class=\"crayon-p\"># \/etc\/my.cnf:<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-2\" class=\"crayon-line\"><span class=\"crayon-v\">innodb_buffer_pool_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">5M<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-3\" class=\"crayon-line\"><span class=\"crayon-v\">innodb_log_buffer_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">256K<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-4\" class=\"crayon-line\"><span class=\"crayon-v\">query_cache_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">0<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-5\" class=\"crayon-line\"><span class=\"crayon-v\">max_connections<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">10<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-6\" class=\"crayon-line\"><span class=\"crayon-v\">key_buffer_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">8<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-7\" class=\"crayon-line\"><span class=\"crayon-v\">thread_cache_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">0<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-8\" class=\"crayon-line\"><span class=\"crayon-v\">host_cache_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">0<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-9\" class=\"crayon-line\"><span class=\"crayon-v\">innodb_ft_cache_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">1600000<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-10\" class=\"crayon-line\"><span class=\"crayon-v\">innodb_ft_total_cache_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">32000000<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-11\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-12\" class=\"crayon-line\"><span class=\"crayon-p\"># per thread or per operation settings<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-13\" class=\"crayon-line\"><span class=\"crayon-v\">thread_stack<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">131072<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-14\" class=\"crayon-line\"><span class=\"crayon-v\">sort_buffer_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">32K<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-15\" class=\"crayon-line\"><span class=\"crayon-v\">read_buffer_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">8200<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-16\" class=\"crayon-line\"><span class=\"crayon-v\">read_rnd_buffer_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">8200<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-17\" class=\"crayon-line\"><span class=\"crayon-v\">max_heap_table_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">16K<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-18\" class=\"crayon-line\"><span class=\"crayon-v\">tmp_table_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">1K<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-19\" class=\"crayon-line\"><span class=\"crayon-v\">bulk_insert_buffer_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">0<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-20\" class=\"crayon-line\"><span class=\"crayon-v\">join_buffer_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">128<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-21\" class=\"crayon-line\"><span class=\"crayon-v\">net_buffer_length<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">1K<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-22\" class=\"crayon-line\"><span class=\"crayon-v\">innodb_sort_buffer_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">64K<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-23\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-24\" class=\"crayon-line\"><span class=\"crayon-p\">#settings that relate to the binary log (if enabled)<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-25\" class=\"crayon-line\"><span class=\"crayon-v\">binlog_cache_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">4K<\/span><\/div>\n<div id=\"crayon-584fc08faf2dd514177655-26\" class=\"crayon-line\"><span class=\"crayon-v\">binlog_stmt_cache_size<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">4K<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>\u4f46\u662f\u5e76\u4e0d\u63a8\u8350\u4f7f\u7528\u6700\u5c0f\u914d\u7f6e\uff0c\u53ef\u4ee5\u9002\u5f53\u4fee\u6539\u4e00\u4e0b\u3002<\/p>\n<p>\u5728\u53e6\u5916\u4e00\u4e2a\u535a\u5ba2\u4e0a\u627e\u5230\u4e86\u4e00\u4e2a\u6bd4\u8f83\u9002\u5408\u4e8e512M\u5185\u5b58\u7684\u914d\u7f6e\uff1a<\/p>\n<div id=\"crayon-584fc08faf2e5598284596\" class=\"crayon-syntax crayon-theme-github crayon-font-consolas crayon-os-pc print-yes notranslate crayon-wrapped\" data-settings=\" no-popup minimize scroll-always disable-anim wrap\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-1\">1<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-3\">3<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-5\">5<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-7\">7<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-9\">9<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-11\">11<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-13\">13<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-15\">15<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-16\">16<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-17\">17<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-18\">18<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-19\">19<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-20\">20<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-21\">21<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-22\">22<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-23\">23<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-24\">24<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-25\">25<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-26\">26<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-27\">27<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-28\">28<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-29\">29<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-30\">30<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-31\">31<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-32\">32<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-33\">33<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-34\">34<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-35\">35<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-36\">36<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-37\">37<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-38\">38<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-39\">39<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-40\">40<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-41\">41<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-42\">42<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-43\">43<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-44\">44<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-45\">45<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-46\">46<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-47\">47<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-48\">48<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-49\">49<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-50\">50<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-51\">51<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-52\">52<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-53\">53<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-54\">54<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-55\">55<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-56\">56<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-57\">57<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-58\">58<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-59\">59<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-60\">60<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-61\">61<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-62\">62<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-63\">63<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-64\">64<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-65\">65<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-66\">66<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-67\">67<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-68\">68<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-69\">69<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-70\">70<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-71\">71<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-72\">72<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-73\">73<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-74\">74<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-75\">75<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-76\">76<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-77\">77<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-78\">78<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-79\">79<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-80\">80<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-81\">81<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-82\">82<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-83\">83<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-84\">84<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-85\">85<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-86\">86<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-87\">87<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-88\">88<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-89\">89<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-90\">90<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-91\">91<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-92\">92<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-93\">93<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-94\">94<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-95\">95<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-96\">96<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-97\">97<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-98\">98<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-99\">99<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-100\">100<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-101\">101<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-102\">102<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-103\">103<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-104\">104<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-105\">105<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-106\">106<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-107\">107<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-108\">108<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-109\">109<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-110\">110<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-111\">111<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-112\">112<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-113\">113<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-114\">114<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-115\">115<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-116\">116<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-117\">117<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-118\">118<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-119\">119<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-120\">120<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-121\">121<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-122\">122<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-123\">123<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-124\">124<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-125\">125<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-126\">126<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-127\">127<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-128\">128<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-129\">129<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-130\">130<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-131\">131<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-132\">132<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-133\">133<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-134\">134<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-135\">135<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-136\">136<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-137\">137<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-138\">138<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-139\">139<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-140\">140<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-141\">141<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-142\">142<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-143\">143<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-144\">144<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-145\">145<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-584fc08faf2e5598284596-146\">146<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-584fc08faf2e5598284596-1\" class=\"crayon-line\"><span class=\"crayon-p\"># Example MySQL config file for large systems.<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-2\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-3\" class=\"crayon-line\"><span class=\"crayon-p\"># This is for a large system with memory = 512M where the system runs mainly<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-4\" class=\"crayon-line\"><span class=\"crayon-p\"># MySQL.<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-5\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-6\" class=\"crayon-line\"><span class=\"crayon-p\"># MySQL programs look for option files in a set of<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-7\" class=\"crayon-line\"><span class=\"crayon-p\"># locations which depend on the deployment platform.<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-8\" class=\"crayon-line\"><span class=\"crayon-p\"># You can copy this option file to one of those<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-9\" class=\"crayon-line\"><span class=\"crayon-p\"># locations. For information about these locations, see:<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-10\" class=\"crayon-line\"><span class=\"crayon-p\"># http:\/\/dev.mysql.com\/doc\/mysql\/en\/option-files.html<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-11\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-12\" class=\"crayon-line\"><span class=\"crayon-p\"># In this file, you can use all long options that a program supports.<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-13\" class=\"crayon-line\"><span class=\"crayon-p\"># If you want to know which options a program supports, run the program<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-14\" class=\"crayon-line\"><span class=\"crayon-p\"># with the &#8220;&#8211;help&#8221; option.<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-15\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-16\" class=\"crayon-line\"><span class=\"crayon-p\"># The following options will be passed to all MySQL clients<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-17\" class=\"crayon-line\"><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">client<\/span><span class=\"crayon-sy\">]<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-18\" class=\"crayon-line\"><span class=\"crayon-p\">#password = your_password<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-19\" class=\"crayon-line\"><span class=\"crayon-v\">port<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">3306<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-20\" class=\"crayon-line\"><span class=\"crayon-v\">socket<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-o\">\/<\/span><span class=\"crayon-t\">var<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">lib<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">sock<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-21\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-22\" class=\"crayon-line\"><span class=\"crayon-p\"># Here follows entries for some specific programs<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-23\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-24\" class=\"crayon-line\"><span class=\"crayon-p\"># The MySQL server<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-25\" class=\"crayon-line\"><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">mysqld<\/span><span class=\"crayon-sy\">]<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-26\" class=\"crayon-line\"><span class=\"crayon-v\">port<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">3306<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-27\" class=\"crayon-line\"><span class=\"crayon-v\">socket<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-o\">\/<\/span><span class=\"crayon-t\">var<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">lib<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">sock<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-28\" class=\"crayon-line\"><span class=\"crayon-v\">skip<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">external<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e\">locking<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-29\" class=\"crayon-line\"><span class=\"crayon-v\">key_buffer_size<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">256M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-30\" class=\"crayon-line\"><span class=\"crayon-v\">max_allowed_packet<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">1M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-31\" class=\"crayon-line\"><span class=\"crayon-v\">table_open_cache<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">256<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-32\" class=\"crayon-line\"><span class=\"crayon-v\">sort_buffer_size<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">1M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-33\" class=\"crayon-line\"><span class=\"crayon-v\">read_buffer_size<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">1M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-34\" class=\"crayon-line\"><span class=\"crayon-v\">read_rnd_buffer_size<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">4M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-35\" class=\"crayon-line\"><span class=\"crayon-v\">myisam_sort_buffer_size<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">64M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-36\" class=\"crayon-line\"><span class=\"crayon-v\">thread_cache_size<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">8<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-37\" class=\"crayon-line\"><span class=\"crayon-v\">query_cache_size<\/span><span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">16M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-38\" class=\"crayon-line\"><span class=\"crayon-p\"># Try number of CPU&#8217;s*2 for thread_concurrency<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-39\" class=\"crayon-line\"><span class=\"crayon-v\">thread_concurrency<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">8<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-40\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-41\" class=\"crayon-line\"><span class=\"crayon-p\"># Don&#8217;t listen on a TCP\/IP port at all. This can be a security enhancement,<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-42\" class=\"crayon-line\"><span class=\"crayon-p\"># if all processes that need to connect to mysqld run on the same host.<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-43\" class=\"crayon-line\"><span class=\"crayon-p\"># All interaction with mysqld must be made via Unix sockets or named pipes.<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-44\" class=\"crayon-line\"><span class=\"crayon-p\"># Note that using this option without enabling named pipes on Windows<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-45\" class=\"crayon-line\"><span class=\"crayon-p\"># (via the &#8220;enable-named-pipe&#8221; option) will render mysqld useless!<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-46\" class=\"crayon-line\"><span class=\"crayon-p\"># <\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-47\" class=\"crayon-line\"><span class=\"crayon-p\">#skip-networking<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-48\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-49\" class=\"crayon-line\"><span class=\"crayon-p\"># Replication Master Server (default)<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-50\" class=\"crayon-line\"><span class=\"crayon-p\"># binary logging is required for replication<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-51\" class=\"crayon-line\"><span class=\"crayon-v\">log<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">bin<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">bin<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-52\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-53\" class=\"crayon-line\"><span class=\"crayon-p\"># binary logging format &#8211; mixed recommended<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-54\" class=\"crayon-line\"><span class=\"crayon-v\">binlog_format<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-v\">mixed<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-55\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-56\" class=\"crayon-line\"><span class=\"crayon-p\"># required unique id between 1 and 2^32 &#8211; 1<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-57\" class=\"crayon-line\"><span class=\"crayon-p\"># defaults to 1 if master-host is not set<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-58\" class=\"crayon-line\"><span class=\"crayon-p\"># but will not function as a master if omitted<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-59\" class=\"crayon-line\"><span class=\"crayon-v\">server<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">id<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">1<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-60\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-61\" class=\"crayon-line\"><span class=\"crayon-p\"># Replication Slave (comment out master section to use this)<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-62\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-63\" class=\"crayon-line\"><span class=\"crayon-p\"># To configure this host as a replication slave, you can choose between<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-64\" class=\"crayon-line\"><span class=\"crayon-p\"># two methods :<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-65\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-66\" class=\"crayon-line\"><span class=\"crayon-p\"># 1) Use the CHANGE MASTER TO command (fully described in our manual) &#8211;<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-67\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0the syntax is:<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-68\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-69\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0CHANGE MASTER TO MASTER_HOST=&lt;host&gt;, MASTER_PORT=&lt;port&gt;,<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-70\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0MASTER_USER=&lt;user&gt;, MASTER_PASSWORD=&lt;password&gt; ;<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-71\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-72\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0where you replace &lt;host&gt;, &lt;user&gt;, &lt;password&gt; by quoted strings and<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-73\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0&lt;port&gt; by the master&#8217;s port number (3306 by default).<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-74\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-75\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0Example:<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-76\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-77\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0CHANGE MASTER TO MASTER_HOST=&#8217;125.564.12.1&#8242;, MASTER_PORT=3306,<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-78\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0MASTER_USER=&#8217;joe&#8217;, MASTER_PASSWORD=&#8217;secret&#8217;;<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-79\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-80\" class=\"crayon-line\"><span class=\"crayon-p\"># OR<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-81\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-82\" class=\"crayon-line\"><span class=\"crayon-p\"># 2) Set the variables below. However, in case you choose this method, then<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-83\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0start replication for the first time (even unsuccessfully, for example<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-84\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0if you mistyped the password in master-password and the slave fails to<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-85\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0connect), the slave will create a master.info file, and any later<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-86\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0change in this file to the variables&#8217; values below will be ignored and<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-87\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0overridden by the content of the master.info file, unless you shutdown<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-88\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0the slave server, delete master.info and restart the slaver server.<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-89\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0For that reason, you may want to leave the lines below untouched<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-90\" class=\"crayon-line\"><span class=\"crayon-p\">#\u00a0\u00a0\u00a0\u00a0(commented) and instead use CHANGE MASTER TO (see above)<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-91\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-92\" class=\"crayon-line\"><span class=\"crayon-p\"># required unique id between 2 and 2^32 &#8211; 1<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-93\" class=\"crayon-line\"><span class=\"crayon-p\"># (and different from the master)<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-94\" class=\"crayon-line\"><span class=\"crayon-p\"># defaults to 2 if master-host is set<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-95\" class=\"crayon-line\"><span class=\"crayon-p\"># but will not function as a slave if omitted<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-96\" class=\"crayon-line\"><span class=\"crayon-p\">#server-id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 2<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-97\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-98\" class=\"crayon-line\"><span class=\"crayon-p\"># The replication master for this slave &#8211; required<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-99\" class=\"crayon-line\"><span class=\"crayon-p\">#master-host\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0 &lt;hostname&gt;<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-100\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-101\" class=\"crayon-line\"><span class=\"crayon-p\"># The username the slave will use for authentication when connecting<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-102\" class=\"crayon-line\"><span class=\"crayon-p\"># to the master &#8211; required<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-103\" class=\"crayon-line\"><span class=\"crayon-p\">#master-user\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0 &lt;username&gt;<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-104\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-105\" class=\"crayon-line\"><span class=\"crayon-p\"># The password the slave will authenticate with when connecting to<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-106\" class=\"crayon-line\"><span class=\"crayon-p\"># the master &#8211; required<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-107\" class=\"crayon-line\"><span class=\"crayon-p\">#master-password =\u00a0\u00a0 &lt;password&gt;<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-108\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-109\" class=\"crayon-line\"><span class=\"crayon-p\"># The port the master is listening on.<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-110\" class=\"crayon-line\"><span class=\"crayon-p\"># optional &#8211; defaults to 3306<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-111\" class=\"crayon-line\"><span class=\"crayon-p\">#master-port\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0&lt;port&gt;<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-112\" class=\"crayon-line\"><span class=\"crayon-p\">#<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-113\" class=\"crayon-line\"><span class=\"crayon-p\"># binary logging &#8211; not required for slaves, but recommended<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-114\" class=\"crayon-line\"><span class=\"crayon-p\">#log-bin=mysql-bin<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-115\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-116\" class=\"crayon-line\"><span class=\"crayon-p\"># Uncomment the following if you are using InnoDB tables<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-117\" class=\"crayon-line\"><span class=\"crayon-p\">#innodb_data_home_dir = \/var\/lib\/mysql<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-118\" class=\"crayon-line\"><span class=\"crayon-p\">#innodb_data_file_path = ibdata1:10M:autoextend<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-119\" class=\"crayon-line\"><span class=\"crayon-p\">#innodb_log_group_home_dir = \/var\/lib\/mysql<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-120\" class=\"crayon-line\"><span class=\"crayon-p\"># You can set .._buffer_pool_size up to 50 &#8211; 80 %<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-121\" class=\"crayon-line\"><span class=\"crayon-p\"># of RAM but beware of setting memory usage too high<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-122\" class=\"crayon-line\"><span class=\"crayon-p\">#innodb_buffer_pool_size = 256M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-123\" class=\"crayon-line\"><span class=\"crayon-p\">#innodb_additional_mem_pool_size = 20M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-124\" class=\"crayon-line\"><span class=\"crayon-p\"># Set .._log_file_size to 25 % of buffer pool size<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-125\" class=\"crayon-line\"><span class=\"crayon-p\">#innodb_log_file_size = 64M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-126\" class=\"crayon-line\"><span class=\"crayon-p\">#innodb_log_buffer_size = 8M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-127\" class=\"crayon-line\"><span class=\"crayon-p\">#innodb_flush_log_at_trx_commit = 1<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-128\" class=\"crayon-line\"><span class=\"crayon-p\">#innodb_lock_wait_timeout = 50<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-129\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-130\" class=\"crayon-line\"><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">mysqldump<\/span><span class=\"crayon-sy\">]<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-131\" class=\"crayon-line\"><span class=\"crayon-e\">quick<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-132\" class=\"crayon-line\"><span class=\"crayon-v\">max_allowed_packet<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">16M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-133\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-134\" class=\"crayon-line\"><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">mysql<\/span><span class=\"crayon-sy\">]<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-135\" class=\"crayon-line\"><span class=\"crayon-v\">no<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">auto<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">rehash<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-136\" class=\"crayon-line\"><span class=\"crayon-p\"># Remove the next comment character if you are not familiar with SQL<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-137\" class=\"crayon-line\"><span class=\"crayon-p\">#safe-updates<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-138\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-139\" class=\"crayon-line\"><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">myisamchk<\/span><span class=\"crayon-sy\">]<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-140\" class=\"crayon-line\"><span class=\"crayon-v\">key_buffer_size<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">128M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-141\" class=\"crayon-line\"><span class=\"crayon-v\">sort_buffer_size<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">128M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-142\" class=\"crayon-line\"><span class=\"crayon-v\">read_buffer<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">2M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-143\" class=\"crayon-line\"><span class=\"crayon-v\">write_buffer<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-cn\">2M<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-144\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-145\" class=\"crayon-line\"><span class=\"crayon-sy\">[<\/span><span class=\"crayon-v\">mysqlhotcopy<\/span><span class=\"crayon-sy\">]<\/span><\/div>\n<div id=\"crayon-584fc08faf2e5598284596-146\" class=\"crayon-line\"><span class=\"crayon-v\">interactive<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">timeout<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>\u94fe\u63a5\uff1a<\/p>\n<p>1.<a href=\"http:\/\/www.tocker.ca\/2014\/03\/10\/configuring-mysql-to-use-minimal-memory.html\" target=\"_blank\" rel=\"external nofollow\">Configuring MySQL to use minimal memory<\/a><\/p>\n<p>2.<a href=\"http:\/\/www.yourhowto.net\/mysql-sample-configuration-512m-ram\/\" target=\"_blank\" rel=\"external nofollow\">Mysql sample configuration with 512M ram<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u505a\u7f51\u7ad9\u7684\u65f6\u5019\u9009\u6570\u636e\u5e93\uff0cMySQL\u662f\u9996\u9009\uff0c\u4f46\u662f\u670d\u52a1\u5668\u914d\u7f6e\u4e0d\u9ad8\uff0c\u5982\u679c\u4e0d\u4f18\u5316\u7684\u8bdd\uff0c\u670d\u52a1&#8230;<br \/><a class=\"read-more-button\" href=\"https:\/\/freesilo.com\/?p=398\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-398","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/398","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=398"}],"version-history":[{"count":1,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/398\/revisions"}],"predecessor-version":[{"id":399,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/398\/revisions\/399"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}