{"id":18416,"date":"2014-08-26T06:54:55","date_gmt":"2014-08-25T22:54:55","guid":{"rendered":"https:\/\/2blog.ilc.edu.tw\/25793\/2014\/08\/26\/mariadb-server-%e8%aa%bf%e6%95%b4\/"},"modified":"2021-03-18T17:24:01","modified_gmt":"2021-03-18T09:24:01","slug":"mariadb-server-%e8%aa%bf%e6%95%b4","status":"publish","type":"post","link":"https:\/\/2blog.ilc.edu.tw\/25793\/2014\/08\/26\/mariadb-server-%e8%aa%bf%e6%95%b4\/","title":{"rendered":"MariaDB Server \u8abf\u6574"},"content":{"rendered":"

\u53c3\u8003 – \u65b0\u5b89\u88dd CentOS 6.5 \u7b46\u8a18 ~ .\u963f\u6b23\u90e8\u843d. ~<\/a>
\u5728 \/usr\/share\/mysql\/ \u4e0b\u6709\u5e7e\u500b\u7bc4\u4f8b\u914d\u7f6e\u6a94
\u00a0\u00a0\u00a0 my-innodb-heavy-4G.cnf: \u9069\u5408\u5927\u65bc 4GB RAM \u7684\u4f3a\u670d\u5668\u4f7f\u7528\u3002
\u00a0\u00a0\u00a0 my-huge.cnf: \u9069\u5408 1GB \u2013 2GB RAM \u7684\u4f3a\u670d\u5668\u4f7f\u7528\u3002
\u00a0\u00a0\u00a0 my-large.cnf: \u9069\u5408 512MB RAM \u7684\u4f3a\u670d\u5668\u4f7f\u7528\u3002
\u00a0\u00a0\u00a0 my-medium.cnf: \u9069\u5408 64MB ~ 512 RAM \u7684\u4f3a\u670d\u5668\u4f7f\u7528\u3002
\u00a0\u00a0\u00a0 my-small.cnf: \u9069\u5408\u8a18\u61b6\u9ad4\u5c0f\u65bc 64MB\u7684\u4f3a\u670d\u5668\u3002
# ls -l \/usr\/share\/mysql\/*.cnf<\/span>
-rw-r–r–. 1 root root\u00a0 4920 Jun 24 22:24 \/usr\/share\/mysql\/my-huge.cnf<\/span>
-rw-r–r–. 1 root root 20438 Jun 24 22:24 \/usr\/share\/mysql\/my-innodb-heavy-4G.cnf<\/span>
-rw-r–r–. 1 root root\u00a0 4907 Jun 24 22:24 \/usr\/share\/mysql\/my-large.cnf<\/span>
-rw-r–r–. 1 root root\u00a0 4920 Jun 24 22:24 \/usr\/share\/mysql\/my-medium.cnf<\/span>
-rw-r–r–. 1 root root\u00a0 2846 Jun 24 22:24 \/usr\/share\/mysql\/my-small.cnf<\/span><\/p>\n

\u5099\u4efd\u539f\u6a94
# mv \/etc\/my.cnf.d\/mysql-clients.cnf \/etc\/my.cnf.d\/mysql-clients.cnf.$(date +%F)<\/span>
\u8907\u88fd\u7bc4\u4f8b\u6a94\u5230\u8a2d\u5b9a\u76ee\u9304\uff0cServer \u7684 RAM \u662f 2G
# cp \/usr\/share\/mysql\/my-huge.cnf \/etc\/my.cnf.d\/mysql-clients.cnf<\/span>[@more@]<\/p>\n

MariaDB Server UTF-8 \u74b0\u5883\u8a2d\u5b9a
\u67e5\u770b\u76ee\u524d MariaDB Server \u7684\u8a2d\u5b9a
# \/usr\/bin\/mysql -u root -p<\/span>
\u8f38\u5165\u5bc6\u78bc\u5f8c\uff0c\u8f38\u5165 s<\/span>
\u53ef\u4ee5\u770b\u5230
Server characterset:\u00a0\u00a0\u00a0 latin1<\/span>
Db\u00a0\u00a0\u00a0\u00a0 characterset:\u00a0\u00a0\u00a0 latin1<\/span>
\"\"<\/a><\/p>\n

Client \u7aef\u8a2d\u5b9a
# sed -i ‘\/[client]\/adefault-character-set=utf8’ \/etc\/my.cnf.d\/client.cnf<\/span>
Server \u7aef\u8a2d\u5b9a
# sed -i ‘\/[mysqld]\/acharacter-set-server=utf8’ \/etc\/my.cnf.d\/server.cnf<\/span><\/p>\n

\u91cd\u65b0\u555f\u52d5 MariaDB Server
# systemctl restart mariadb<\/span><\/p>\n

\u91cd\u65b0\u6aa2\u67e5\u4e00\u6b21
# \/usr\/bin\/mysql -u root -p<\/span>
\u8f38\u5165\u5bc6\u78bc\u5f8c\uff0c\u8f38\u5165 s<\/span>
\u53ef\u4ee5\u770b\u5230
Server characterset:\u00a0\u00a0\u00a0 utf8<\/span>
Db\u00a0\u00a0\u00a0\u00a0 characterset:\u00a0\u00a0\u00a0 utf8<\/span>
Client characterset:\u00a0\u00a0\u00a0 utf8<\/span>
Conn.\u00a0 characterset:\u00a0\u00a0\u00a0 utf8<\/span>
\"\"<\/a>
\u6216
> show variables like ‘character_set%’;<\/span>
\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\u53c3\u8003 – \u65b0\u5b89\u88dd CentOS 6.5 \u7b46\u8a18 ~ .\u963f\u6b23\u90e8\u843d. ~\u5728 \/usr\/share\/mys … <\/p>\n

\u95b1\u8b80\u5168\u6587\u3008MariaDB Server \u8abf\u6574\u3009<\/span><\/a><\/p>\n","protected":false},"author":55,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[117,116],"tags":[],"class_list":["post-18416","post","type-post","status-publish","format-standard","hentry","category-c-78462","category-c-78461"],"meta_key":{"_pingme":["1"],"_encloseme":["1"],"lt_post_id":["514426"]},"_links":{"self":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18416"}],"collection":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/comments?post=18416"}],"version-history":[{"count":1,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18416\/revisions"}],"predecessor-version":[{"id":20060,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18416\/revisions\/20060"}],"wp:attachment":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/media?parent=18416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/categories?post=18416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/tags?post=18416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}