{"id":501,"date":"2015-03-10T09:16:34","date_gmt":"2015-03-10T01:16:34","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=501"},"modified":"2015-09-10T21:53:02","modified_gmt":"2015-09-10T13:53:02","slug":"mysql%e6%9f%a5%e8%af%a2%e5%bd%93%e5%89%8d%e7%89%88%e6%9c%ac","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=501","title":{"rendered":"MySQL\u67e5\u8be2\u5f53\u524d\u7248\u672c"},"content":{"rendered":"

1.\u4f7f\u7528Mysql -V
\n[root@ucjmh ~]# mysql -V
\nmysql Ver 14.14 Distrib 5.5.41, for Linux (i686) using readline 5.1
\n2.\u5728mysql\u4e2d\u8f93\u5165\u547d\u4ee4–>status
\nmysql> status
\n————–
\nmysql Ver 14.14 Distrib 5.5.41, for Linux (i686) using readline 5.1<\/p>\n

Connection id: 25
\nCurrent database:
\nCurrent user: root@localhost
\nSSL: Not in use
\nCurrent pager: stdout
\nUsing outfile: ”
\nUsing delimiter: ;
\nServer version: 5.5.41 MySQL Community Server (GPL)
\nProtocol version: 10
\nConnection: Localhost via UNIX socket
\nServer characterset: latin1
\nDb characterset: utf8
\nClient characterset: utf8
\nConn. characterset: utf8
\nUNIX socket: \/var\/lib\/mysql\/mysql.sock
\nUptime: 3 hours 4 min 36 sec<\/p>\n

Threads: 2 Questions: 161 Slow queries: 0 Opens: 78 Flush tables: 3 Open tables: 24 Queries per second avg: 0.014
\n3.\u5728help\u4e2d\u627e\u5230
\n[root@ucjmh ~]# mysql –help | grep Distrib
\nmysql Ver 14.14 Distrib 5.5.41, for Linux (i686) using readline 5.1<\/p>\n

4.\u4f7f\u7528version()\u51fd\u6570
\nmysql> select version();
\n+———–+
\n| version() |
\n+———–+
\n| 5.5.41 |
\n+———–+
\n1 row in set (0.00 sec)<\/p>\n","protected":false},"excerpt":{"rendered":"

1.\u4f7f\u7528Mysql -V [root@ucjmh ~]# mysql -V mysql Ver 14.14 D […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[27],"class_list":["post-501","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/501","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=501"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/501\/revisions"}],"predecessor-version":[{"id":1005,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/501\/revisions\/1005"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=501"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}