{"id":28832,"date":"2023-01-05T21:15:56","date_gmt":"2023-08-20T21:37:24","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/"},"modified":"2025-08-12T10:20:42","modified_gmt":"2025-08-12T02:20:42","slug":"%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/","title":{"rendered":"\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d"},"content":{"rendered":"

\u56e0\u4e3a\u5728MySQL\u9886\u57df\u5f15\u8d77\u4e86\u8f70\u52a8\u7684MyRocks\uff0c\u6240\u4ee5\u57282017\u5e745\u670823\u65e5\u53d1\u5e03\u7684MariaDB 10.2.6\u4e2d\u6dfb\u52a0\u4e86MyRocks\uff08RocksDB\uff09\u5f15\u64ce\uff08alpha\u7248\u672c\uff09\u3002\u56e0\u6b64\uff0c\u6211\u5c1d\u8bd5\u5c06InnoDB\u8868\u8fdb\u884c\u8f6c\u6362\u5e76\u4f7f\u7528MyRocks\u5f15\u64ce\u3002<\/p>\n

\u9996\u5148\u5c31\u6ce8\u610f\u4e8b\u9879\u548c\u7ed3\u8bba\u800c\u8a00\uff0c\u5982\u679c\u662f\u7528\u4e8e\u5b9e\u9645\u5e94\u7528\uff0c\u90a3\u4e48MyRocks\u4e5f\u9700\u8981\u8fdb\u884c\u8c03\u4f18\u624d\u884c\u3002\u7136\u800c\uff0c\u8fd9\u5df2\u8d85\u51fa\u4e86\u672c\u6587\u7684\u8303\u56f4\u3002<\/p>\n

\u5173\u4e8e\u8c03\u8c10\uff0c\u5b98\u65b9\u4e5f\u6709\u8fd9\u6837\u7684\u63cf\u8ff0\u3002<\/p>\n

\u4e0d\u5e78\u7684\u662f\uff0c\u4f18\u5316RocksDB\u5e76\u4e0d\u7b80\u5355\u3002\u5373\u4f7f\u4f5c\u4e3aRocksDB\u5f00\u53d1\u4eba\u5458\uff0c\u6211\u4eec\u4e5f\u4e0d\u80fd\u5b8c\u5168\u7406\u89e3\u6bcf\u4e2a\u914d\u7f6e\u66f4\u6539\u7684\u5f71\u54cd\u3002\u5982\u679c\u60a8\u60f3\u4e3a\u60a8\u7684\u5de5\u4f5c\u8d1f\u8f7d\u5145\u5206\u4f18\u5316RocksDB\uff0c\u6211\u4eec\u5efa\u8bae\u8fdb\u884c\u5b9e\u9a8c\u548c\u57fa\u51c6\u6d4b\u8bd5\uff0c\u5e76\u6ce8\u610f\u4e09\u4e2a\u653e\u5927\u56e0\u7d20\u3002<\/p><\/blockquote>\n

\u7b80\u800c\u8a00\u4e4b\uff0c\u5c31\u662f\u8bf4\u201c\u56e0\u4e3a\u8fd8\u672a\u6210\u719f\uff0c\u8bf7\u81ea\u884c\u5c1d\u8bd5\u4e00\u4e0b\u201d\u3002<\/p>\n

\u6b64\u5916\uff0c\u5728\u672c\u6587\u64b0\u5199\u65f6\uff0cRocksDB\u5176\u5b9e\u8fd8\u5904\u4e8eAlpha\u53d1\u5e03\u9636\u6bb5\u3002<\/p>\n

\u51c6\u5907MariaDB\u6211\u4f1a\u5199\u4e0b\u5b89\u88c5\u548c\u7b80\u5355\u8bbe\u7f6e\u7684\u6b65\u9aa4\u3002<\/p>\n

\u5b89\u88c5\u8ba9\u6211\u4eec\u5b89\u88c5\u6700\u65b0\u7684MariaDB\u5427\u3002\u5728\u64b0\u5199\u672c\u6587\u65f6\uff0c\u6700\u65b0\u7248\u672c\u662f10.2.7\uff0c\u4f46\u5728\u6784\u5efa\u9a8c\u8bc1\u73af\u5883\u65f6\uff0c10.2.6\u662f\u6700\u65b0\u7248\u672c\u3002<\/p>\n

\u672c\u6587\u6240\u8ff0\u7684\u73af\u5883\u662f\u4ee5CentOS7\u4f5c\u4e3a\u64cd\u4f5c\u7cfb\u7edf\uff0c\u5e76\u5b89\u88c5\u4e86\u4ee5\u4e0b\u8f6f\u4ef6\u5305\u7684\u73af\u5883\u3002<\/p>\n

    \n
  • \n
      MariaDB-client-10.2.6-1.el7.centos.x86_64<\/ul>\n<\/li>\n<\/ul>\n

       <\/p>\n

        \n
      • \n
          MariaDB-shared-10.2.6-1.el7.centos.x86_64<\/ul>\n<\/li>\n<\/ul>\n

           <\/p>\n

            \n
          • \n
              MariaDB-common-10.2.6-1.el7.centos.x86_64<\/ul>\n<\/li>\n<\/ul>\n

               <\/p>\n

                \n
              • \n
                  MariaDB-devel-10.2.6-1.el7.centos.x86_64<\/ul>\n<\/li>\n<\/ul>\n

                   <\/p>\n

                    \n
                  • \n
                      MariaDB-compat-10.2.6-1.el7.centos.x86_64<\/ul>\n<\/li>\n<\/ul>\n

                       <\/p>\n

                        \n
                      • \n
                          MariaDB-server-10.2.6-1.el7.centos.x86_64<\/ul>\n<\/li>\n<\/ul>\n

                           <\/p>\n

                            MariaDB-rocksdb-engine-10.2.6-1.el7.centos.x86_64<\/ul>\n

                            \u5728 10.2.6 \u7248\u672c\u4e2d\uff0cMyRocks \u5df2\u7ecf\u6210\u4e3a\u53e6\u4e00\u4e2a\u540d\u4e3a MariaDB-rocksdb-engine \u7684\u63d2\u4ef6\u5305\uff0c\u6240\u4ee5\u4e0e MariaDB-server \u4e00\u8d77\u5b89\u88c5\u3002<\/p>\n

                            \u7b80\u5355\u7684\u8bbe\u7f6e
                            \n\u6211\u8ba4\u4e3a\u4f1a\u81ea\u52a8\u521b\u5efa\u540d\u4e3arocksdb.cnf\u7684\u6587\u4ef6\u3002<\/p>\n
                            $ <\/span>cat<\/span> \/etc\/my.cnf.d\/rocksdb.cnf\r\n[<\/span>mariadb]\r\nplugin-load-add=<\/span>ha_rocksdb.so\r\n<\/code><\/pre>\n
                            \u5982\u679c\u5b58\u5728\u8fd9\u6bb5\u63cf\u8ff0\uff0c\u90a3\u4e48\u5c06\u542f\u7528RocksDB\u5f15\u64ce\u3002
                            \n\u5f53\u542f\u52a8MariaDB\u65f6\uff0c\u5e94\u8be5\u53ef\u4ee5\u786e\u8ba4RocksDB\u5f15\u64ce\u5df2\u542f\u7528\u5982\u4e0b\u3002<\/p>\n
                            MariaDB<\/span>><\/span> SHOW<\/span> ENGINES<\/span>;<\/span>\r\n+<\/span>--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+<\/span>\r\n|<\/span> Engine<\/span>             |<\/span> Support<\/span> |<\/span> Comment<\/span>                                                                          |<\/span> Transactions<\/span> |<\/span> XA<\/span>   |<\/span> Savepoints<\/span> |<\/span>\r\n+<\/span>--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+<\/span>\r\n|<\/span> ROCKSDB<\/span>            |<\/span> YES<\/span>     |<\/span> RocksDB<\/span> storage<\/span> engine<\/span>                                                           |<\/span> YES<\/span>          |<\/span> YES<\/span>  |<\/span> YES<\/span>        |<\/span>\u3000\u2190\u3053\u308c<\/span>\r\n|<\/span> MRG_MyISAM<\/span>         |<\/span> YES<\/span>     |<\/span> Collection<\/span> of<\/span> identical<\/span> MyISAM<\/span> tables<\/span>                                            |<\/span> NO<\/span>           |<\/span> NO<\/span>   |<\/span> NO<\/span>         |<\/span>\r\n|<\/span> CSV<\/span>                |<\/span> YES<\/span>     |<\/span> CSV<\/span> storage<\/span> engine<\/span>                                                               |<\/span> NO<\/span>           |<\/span> NO<\/span>   |<\/span> NO<\/span>         |<\/span>\r\n|<\/span> Aria<\/span>               |<\/span> YES<\/span>     |<\/span> Crash<\/span>-<\/span>safe<\/span> tables<\/span> with<\/span> MyISAM<\/span> heritage<\/span>                                           |<\/span> NO<\/span>           |<\/span> NO<\/span>   |<\/span> NO<\/span>         |<\/span>\r\n|<\/span> MyISAM<\/span>             |<\/span> YES<\/span>     |<\/span> MyISAM<\/span> storage<\/span> engine<\/span>                                                            |<\/span> NO<\/span>           |<\/span> NO<\/span>   |<\/span> NO<\/span>         |<\/span>\r\n|<\/span> MEMORY<\/span>             |<\/span> YES<\/span>     |<\/span> Hash<\/span> based<\/span>,<\/span> stored<\/span> in<\/span> memory<\/span>,<\/span> useful<\/span> for<\/span> temporary<\/span> tables<\/span>                        |<\/span> NO<\/span>           |<\/span> NO<\/span>   |<\/span> NO<\/span>         |<\/span>\r\n|<\/span> Mroonga<\/span>            |<\/span> YES<\/span>     |<\/span> CJK<\/span>-<\/span>ready<\/span> fulltext<\/span> search<\/span>,<\/span> column<\/span> store<\/span>                                          |<\/span> NO<\/span>           |<\/span> NO<\/span>   |<\/span> NO<\/span>         |<\/span>\r\n|<\/span> SEQUENCE<\/span>           |<\/span> YES<\/span>     |<\/span> Generated<\/span> tables<\/span> filled<\/span> with<\/span> sequential<\/span> values<\/span>                                   |<\/span> YES<\/span>          |<\/span> NO<\/span>   |<\/span> YES<\/span>        |<\/span>\r\n|<\/span> PERFORMANCE_SCHEMA<\/span> |<\/span> YES<\/span>     |<\/span> Performance<\/span> Schema<\/span>                                                               |<\/span> NO<\/span>           |<\/span> NO<\/span>   |<\/span> NO<\/span>         |<\/span>\r\n|<\/span> InnoDB<\/span>             |<\/span> DEFAULT<\/span> |<\/span> Supports<\/span> transactions<\/span>,<\/span> row<\/span>-<\/span>level<\/span> locking<\/span>,<\/span> foreign<\/span> keys<\/span> and<\/span> encryption<\/span> for<\/span> tables<\/span> |<\/span> YES<\/span>          |<\/span> YES<\/span>  |<\/span> YES<\/span>        |<\/span>\r\n+<\/span>--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+<\/span>\r\n10<\/span> rows<\/span> in<\/span> set<\/span> (<\/span>0<\/span>.<\/span>00<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
                            \u4f60\u80fd\u770b\u5230ROCKSDB\u5427\u3002\u4f60\u4e5f\u53ef\u4ee5\u770b\u5230\u5b83\u5177\u6709\u7c7b\u4f3c\u4e8eInnoDB\u7684\u529f\u80fd\u3002<\/p>\n
                            \u8bbe\u5b9a\u6570\u503c\u8865\u5145
                            \n\u53ef\u80fd\u5728\u540e\u7eed\u7248\u672c\u4e2d\u4f1a\u4fee\u590d\u8be5\u95ee\u9898\uff0c\u8fd9\u53ea\u662f\u4e00\u4e2a\u8865\u5145\u8bf4\u660e…
                            \n\u5728MariaDB 10.2.6\u4e2d\uff0cRocksDB\u76ee\u5f55\u88ab\u8bc6\u522b\u4e3a\u6570\u636e\u5e93\uff0c\u5e76\u51fa\u73b0\u4e86\u540d\u4e3a”#mysql50#.rocksdb”\u7684\u6570\u636e\u5e93\u3002\uff08\u5df2\u77e5\u7684\u9519\u8bef\uff09<\/p>\n
                            \u5982\u679c\u5728\u4e0a\u8ff0\u7684\u8bbe\u5b9a\u6587\u4ef6\u4e2d\u6dfb\u52a0\u4ee5\u4e0b\u53c2\u6570\uff0c\u5c31\u53ef\u4ee5\u907f\u514d\u8fd9\u4e2a\u95ee\u9898\u3002<\/p>\n
                            ignore-db-dirs=.rocksdb\r\n<\/code><\/pre>\n
                            \u6570\u636e\u5e93\u7684\u8fc1\u79fb de\u65e2\u7ecf\u51c6\u5907\u597d\u4e86MariaDB\uff0c\u6240\u4ee5\u6211\u5c06\u5c1d\u8bd5\u8fc1\u79fb\u6570\u636e\u3002
                            \nPercona\u7684XtraBackup\u975e\u5e38\u5feb\u901f\u4e14\u65b9\u4fbf\u3002<\/p>\n
                            \u73af\u5883\u4fe1\u606f\u5728\u672c\u6b21\u9a8c\u8bc1\u4e2d\uff0c\u6211\u4eec\u6210\u529f\u5730\u5c06\u6570\u636e\u4ece\u4ee5\u4e0b\u73af\u5883\/\u7248\u672c\u8fc1\u79fb\u5230\u53e6\u4e00\u5904\u3002\uff08\u5173\u4e8eXtraBackup\uff0c\u6211\u4eec\u53ea\u662f\u56e0\u4e3a\u8282\u7701\u65f6\u95f4\u800c\u7701\u7565\u4e86\uff0c\u6240\u4ee5\u6700\u597d\u4f7f\u7528\u6700\u65b0\u7248\u672c\u3002\uff09<\/p>\n
                              \n
                            • \n
                                \u79fb\u884c\u5143: CentOS6 + MySQL 5.6.12 + XtraBackup 2.2.11<\/ul>\n<\/li>\n<\/ul>\n
                                 <\/p>\n
                                  \u79fb\u884c\u5148: CentOS7 + MariaDB 10.2.6 + XtraBackup 2.3.6<\/ul>\n
                                  \u5907\u4efd\u4e0e\u6062\u590d\u7531\u4e8e\u4e0d\u662f\u8fd9\u4e2a\u95ee\u9898\u7684\u4e3b\u9898\uff0c\u6211\u5c06\u7b80\u8981\u5730\u5199\u4e0b\u3002<\/p>\n
                                  \u5907\u4efd\u5728\u79fb\u884c\u6e90MySQL\u670d\u52a1\u5668\u4e0a\u6309\u4ee5\u4e0b\u65b9\u5f0f\u8fdb\u884c\u5907\u4efd\u3002
                                  \n\u60a8\u53ef\u4ee5\u6839\u636e\u9700\u8981\u81ea\u884c\u66f4\u6539\u5404\u79cd\u8def\u5f84\u3001\u5e76\u884c\u503c\u3001lz4\u538b\u7f29\u7387\u7b49\u3002<\/p>\n
                                  [<\/span>MySQL\u30b5\u30fc\u30d0\u30fc]\r\n$ <\/span>mkdir<\/span> \/var\/tmp\/tmp.xtrabackup\r\n\r\n### \u8a8d\u8a3c\u60c5\u5831\u304c\u5fc5\u8981\u306a\u5834\u5408\u306f\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4ed8\u3051\u308b<\/span>\r\n$ <\/span>innobackupex --stream<\/span>=<\/span>xbstream --parallel<\/span>=<\/span>4 --socket<\/span>=<\/span>\/var\/lib\/mysql\/mysql.sock \/var\/tmp\/tmp.xtrabackup | lz4 -4<\/span> ><\/span> \/var\/tmp\/dbbackup.xbstream.lz4\r\n<\/code><\/pre>\n
                                  \u5c06\u4ee5\u6b64\u65b9\u5f0f\u521b\u5efa\u7684\/var\/tmp\/dbbackup.xbstream.lz4\u6587\u4ef6\u4f20\u8f93\u5230\u76ee\u6807\u4f4d\u7f6e\u3002<\/p>\n
                                  \u6062\u590d\u5728\u76ee\u6807MariaDB\u670d\u52a1\u5668\u4e0a\uff0c\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u8fdb\u884c\u6062\u590d\u3002
                                  \n\u5f53\u7136\uff0c\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0c\u73b0\u6709\u7684\u6240\u6709\u6570\u636e\u5c06\u88ab\u6e05\u7a7a\u3002<\/p>\n
                                  [<\/span>MariaDB\u30b5\u30fc\u30d0\u30fc]\r\n\r\n### \u4f5c\u696d\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u79fb\u52d5<\/span>\r\n$ <\/span>mkdir<\/span> \/var\/tmp\/tmp.xtrabackup\r\n$ <\/span>cd<\/span> \/var\/tmp\/tmp.xtrabackup\r\n\r\n### \u5c55\u958b\u3068\u30ea\u30b9\u30c8\u30a2\u53ef\u80fd\u72b6\u614b\u3078\u306e\u5909\u63db<\/span>\r\n$ <\/span>lz4 -d<\/span> \/var\/tmp\/dbbackup.xbstream.lz4 | xbstream -x<\/span> -v<\/span>\r\n$ <\/span>innobackupex --apply-log<\/span> .\/\r\n\r\n### \u30ea\u30b9\u30c8\u30a2<\/span>\r\n$ <\/span>mv<\/span> \/var\/lib\/mysql \/var\/tmp\/.\r\n$ <\/span>innobackupex --move-back<\/span> .\/\r\n$ <\/span>chown<\/span> -R<\/span> mysql:mysql \/var\/lib\/mysql\r\n<\/code><\/pre>\n
                                  \u53ea\u9700\u542f\u52a8MariaDB\u5373\u53ef\u5b8c\u6210\u6062\u590d\u3002<\/p>\n
                                  \u5982\u679c\u5728\u65e5\u5fd7\u4e2d\u8f93\u51fa\u4e86\u5b57\u7b26\u4e32”\u8bf7\u8fd0\u884c mysql_upgrade”\uff0c\u90a3\u4e48\u53ef\u4ee5\u5c1d\u8bd5\u8fd0\u884c mysql_upgrade\u3002<\/p>\n
                                  $ <\/span>mysql_upgrade\r\n<\/code><\/pre>\n
                                  \u5c06\u6570\u636e\u8f6c\u6362\u4e3aRocksDB<\/p>\n
                                  \u51c6\u5907\u4e4b\u524dPercona\u7684pt-online-schema-change\u975e\u5e38\u4f18\u79c0\uff0c\u53ef\u4ee5\u5728\u5207\u6362\u5230RocksDB\u65f6\u4f7f\u7528\u3002<\/p>\n
                                  \u8bf7\u6309\u7167\u5b98\u65b9\u9875\u9762\u7684\u6307\u793a\u8fdb\u884c\u64cd\u4f5c\u3002
                                  \n\u672c\u6b21\u6d4b\u8bd5\u7684\u7248\u672c\u5982\u4e0b\u3002<\/p>\n
                                    percona-toolkit-3.0.3-1.el7.x86_64<\/ul>\n
                                    \u539f\u59cb\u8868\u7684\u4fe1\u606f
                                    \n\u76ee\u6807\u662f\u9488\u5bf9\u540d\u4e3ahoge\u7684\u8868\u3002<\/p>\n
                                    mysql<\/span>><\/span> SHOW<\/span> CREATE<\/span> TABLE<\/span> hoge<\/span>\\<\/span>G<\/span>\r\n\r\n\u4e2d\u7565<\/span>\r\nENGINE<\/span>=<\/span>InnoDB<\/span> AUTO_INCREMENT<\/span>=<\/span>19103259<\/span> DEFAULT<\/span> CHARSET<\/span>=<\/span>utf8<\/span> ROW_FORMAT<\/span>=<\/span>COMPRESSED<\/span>\r\n<\/code><\/pre>\n
                                    \u8fd9\u662f\u4e00\u4e2a\u5df2\u538b\u7f29\u7684InnoDB\u8868\uff0c\u51e0\u4e4e\u5305\u542b\u4e86\u6709\u5173\u6b63\u5f0f\u6570\u636e\u7684\u76f8\u5173\u4fe1\u606f\u3002
                                    \n\u8bf7\u6ce8\u610f\uff0c\u4e0b\u9762\u7684\u884c\u6570(tbl_rows)\u53ea\u662f\u4e00\u4e2a\u4f30\u8ba1\u503c\uff0c\u4ec5\u4f9b\u53c2\u8003\u3002<\/p>\n
                                    mysql<\/span>><\/span> select<\/span>\r\n    -><\/span> table_name<\/span>,<\/span> engine<\/span>,<\/span> table_rows<\/span> as<\/span> tbl_rows<\/span>,<\/span> avg_row_length<\/span> as<\/span> rlen<\/span>,<\/span>\r\n    -><\/span> floor<\/span>((<\/span>data_length<\/span>+<\/span>index_length<\/span>)<\/span>\/<\/span>1024<\/span>\/<\/span>1024<\/span>)<\/span> as<\/span> allMB<\/span>,<\/span>\r\n    -><\/span> floor<\/span>((<\/span>data_length<\/span>)<\/span>\/<\/span>1024<\/span>\/<\/span>1024<\/span>)<\/span> as<\/span> dMB<\/span>,<\/span>\r\n    -><\/span> floor<\/span>((<\/span>index_length<\/span>)<\/span>\/<\/span>1024<\/span>\/<\/span>1024<\/span>)<\/span> as<\/span> iMB<\/span>\r\n    -><\/span> from<\/span> information_schema<\/span>.<\/span>tables<\/span>\r\n    -><\/span> where<\/span> table_schema<\/span>=<\/span>database<\/span>()<\/span> and<\/span> table_name<\/span>=<\/span>'hoge'<\/span>;<\/span>\r\n+<\/span>------------+--------+----------+------+-------+------+------+<\/span>\r\n|<\/span> table_name<\/span> |<\/span> engine<\/span> |<\/span> tbl_rows<\/span> |<\/span> rlen<\/span> |<\/span> allMB<\/span> |<\/span> dMB<\/span>  |<\/span> iMB<\/span>  |<\/span>\r\n+<\/span>------------+--------+----------+------+-------+------+------+<\/span>\r\n|<\/span> hoge<\/span>       |<\/span> InnoDB<\/span> |<\/span> 16005625<\/span> |<\/span>  605<\/span> |<\/span> 13065<\/span> |<\/span> 9240<\/span> |<\/span> 3825<\/span> |<\/span>\r\n+<\/span>------------+--------+----------+------+-------+------+------+<\/span>\r\n1<\/span> row<\/span> in<\/span> set<\/span> (<\/span>0<\/span>.<\/span>03<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
                                    \u5f15\u64ce\u8f6c\u6362
                                    \n\u4ee5\u8f93\u5165\u6b64\u547d\u4ee4\u7684\u65b9\u5f0f\u6765\u6267\u884cpt-osc\u3002<\/p>\n
                                    ALTER<\/span> TABLE<\/span> hoge<\/span> ENGINE<\/span>=<\/span>ROCKSDB<\/span> ROW_FORMAT<\/span>=<\/span>Dynamic<\/span>;<\/span>\r\n<\/code><\/pre>\n
                                    \u7531\u4e8e\u975e\u5e38\u8017\u65f6\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528nohup\u547d\u4ee4\u6765\u6267\u884c\u3002<\/p>\n
                                    ### Dryrun<\/span>\r\n$ <\/span>nohup <\/span>pt-online-schema-change --charset<\/span>=<\/span>utf8 --nocheck-replication-filters<\/span> --alter<\/span> \"ENGINE=ROCKSDB ROW_FORMAT=Dynamic\"<\/span> h<\/span>=<\/span>localhost,D=<\/span>DBNAME,t=<\/span>hoge,u=<\/span>root --socket<\/span>=<\/span>\/var\/lib\/mysql\/mysql.sock --dry-run<\/span> 2>&1 ><\/span> \/tmp\/pt-osc.log &\r\n\r\n### Execute<\/span>\r\n$ <\/span>nohup <\/span>pt-online-schema-change --charset<\/span>=<\/span>utf8 --nocheck-replication-filters<\/span> --alter<\/span> \"ENGINE=ROCKSDB ROW_FORMAT=Dynamic\"<\/span> h<\/span>=<\/span>localhost,D=<\/span>DBNAME,t=<\/span>hoge,u=<\/span>root --socket<\/span>=<\/span>\/var\/lib\/mysql\/mysql.sock --execute<\/span> 2>&1 ><\/span> \/tmp\/pt-osc.log &\r\n<\/code><\/pre>\n
                                    \u5728\u9a8c\u8bc1\u73af\u5883\uff08Openstack\u865a\u62df\u673a\uff09\u4e0a\u82b1\u4e86\u7ea66\u4e2a\u5c0f\u65f6\u3002<\/p>\n
                                    \u8bf7\u786e\u8ba4\u8f6c\u6362\u540e\u7684\u7ed3\u679c\u3002
                                    \n\u8ba9\u6211\u4eec\u518d\u6b21\u4eceinformation_schema\u4e2d\u83b7\u53d6\u4fe1\u606f\u8bd5\u8bd5\u770b\u3002<\/p>\n
                                    MariaDB<\/span>><\/span> select<\/span>\r\n    -><\/span> table_name<\/span>,<\/span> engine<\/span>,<\/span> table_rows<\/span> as<\/span> tbl_rows<\/span>,<\/span> avg_row_length<\/span> as<\/span> rlen<\/span>,<\/span>\r\n    -><\/span> floor<\/span>((<\/span>data_length<\/span>+<\/span>index_length<\/span>)<\/span>\/<\/span>1024<\/span>\/<\/span>1024<\/span>)<\/span> as<\/span> allMB<\/span>,<\/span>\r\n    -><\/span> floor<\/span>((<\/span>data_length<\/span>)<\/span>\/<\/span>1024<\/span>\/<\/span>1024<\/span>)<\/span> as<\/span> dMB<\/span>,<\/span>\r\n    -><\/span> floor<\/span>((<\/span>index_length<\/span>)<\/span>\/<\/span>1024<\/span>\/<\/span>1024<\/span>)<\/span> as<\/span> iMB<\/span>\r\n    -><\/span> from<\/span> information_schema<\/span>.<\/span>tables<\/span>\r\n    -><\/span> where<\/span> table_schema<\/span>=<\/span>database<\/span>()<\/span> and<\/span> table_name<\/span>=<\/span>'hoge'<\/span>;<\/span>\r\n+<\/span>------------+---------+----------+------+-------+------+------+<\/span>\r\n|<\/span> table_name<\/span> |<\/span> engine<\/span>  |<\/span> tbl_rows<\/span> |<\/span> rlen<\/span> |<\/span> allMB<\/span> |<\/span> dMB<\/span>  |<\/span> iMB<\/span>  |<\/span>\r\n+<\/span>------------+---------+----------+------+-------+------+------+<\/span>\r\n|<\/span> hoge<\/span>       |<\/span> ROCKSDB<\/span> |<\/span> 17774854<\/span> |<\/span>  585<\/span> |<\/span> 11937<\/span> |<\/span> 9926<\/span> |<\/span> 2010<\/span> |<\/span>\r\n+<\/span>------------+---------+----------+------+-------+------+------+<\/span>\r\n1<\/span> row<\/span> in<\/span> set<\/span> (<\/span>0<\/span>.<\/span>00<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
                                    \u53ef\u4ee5\u786e\u8ba4\u5df2\u7ecf\u4f7f\u7528\u4e86RocksDB\u3002\u5bb9\u91cf\u4e5f\u7a0d\u5fae\u51cf\u5c11\u4e86\u4e00\u70b9\u3002<\/p>\n
                                    \u8bd5\u7740\u4f7f\u7528\u6211\u5c1d\u8bd5\u53d1\u9001\u4e00\u4e2a\u5168\u4ef6COUNT\u67e5\u8be2\u7684\u8bf7\u6c42\u6765\u9a8c\u8bc1\u4e00\u4e0b\u3002<\/p>\n
                                      \n
                                    • \n
                                        \u6ce8\u610f1) Index\u304c\u4f7f\u308f\u308c\u308b\u305f\u3081\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u30d5\u30eb\u30b9\u30ad\u30e3\u30f3\u3068\u306f\u9055\u3044\u307e\u3059\u304c\u30fb\u30fb\u30fb\u53c2\u8003\u306b\u6349\u3048\u3066\u3044\u305f\u3060\u3051\u308c\u3070\u3002<\/ul>\n<\/li>\n<\/ul>\n
                                         <\/p>\n
                                          \u6ce8\u610f2) \u9055\u3046\u65e5\u306b\u6bd4\u8f03\u3057\u3066\u3044\u308b\u306e\u3067\u7d50\u679c(\u4ef6\u6570)\u304c\u7570\u306a\u308a\u307e\u3059\u304c\u3001\u304a\u304a\u3088\u305d\u540c\u3058\u30c7\u30fc\u30bf\u91cf\u306a\u306e\u3067\u5dee\u7570\u306f\u7121\u8996\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/ul>\n
                                          MySQL 5.6\u52a0\u4e0aInnoDB
                                          \n\u7531\u4e8e\u8fd9\u4e2ahoge\u8868\u5f88\u5927\uff0c\u6240\u4ee5\u5728\u6696\u6c14\u4e4b\u524d\u4f1a\u5bfc\u81f4DiskRead\u975e\u5e38\u4e25\u91cd\u3002<\/p>\n
                                          mysql<\/span>><\/span> SELECT<\/span> SQL_NO_CACHE<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> FROM<\/span> hoge<\/span>;<\/span>\r\n+<\/span>----------+<\/span>\r\n|<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> |<\/span>\r\n+<\/span>----------+<\/span>\r\n|<\/span> 17824275<\/span> |<\/span>\r\n+<\/span>----------+<\/span>\r\n1<\/span> row<\/span> in<\/span> set<\/span> (<\/span>48<\/span>.<\/span>98<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
                                          \u6696\u98ce\u505c\u6b62\u540e\uff0c\u4e3a\u4e86\u8fdb\u5165\u7f13\u51b2\u6c60\uff0c\u7ed3\u679c\u4f1a\u7a0d\u5fae\u5feb\u4e00\u4e9b\u3002\uff08\u5c3d\u7ba1\u8fd8\u9700\u89814\u79d2\u5462……\uff09<\/p>\n
                                          mysql<\/span>><\/span> SELECT<\/span> SQL_NO_CACHE<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> FROM<\/span> hoge<\/span>;<\/span>\r\n+<\/span>----------+<\/span>\r\n|<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> |<\/span>\r\n+<\/span>----------+<\/span>\r\n|<\/span> 17824275<\/span> |<\/span>\r\n+<\/span>----------+<\/span>\r\n1<\/span> row<\/span> in<\/span> set<\/span> (<\/span>4<\/span>.<\/span>03<\/span> sec<\/span>)<\/span>\r\n\r\n<\/code><\/pre>\n
                                          MariaDB\u548cRocksDB\u6211\u5c06\u5c1d\u8bd5\u4f7f\u7528\u4e0eMySQL\u7c7b\u4f3c\u7684\u65b9\u6cd5\u5904\u7406\u3002<\/p>\n
                                          MariaDB<\/span>><\/span> SELECT<\/span> SQL_NO_CACHE<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> FROM<\/span> hoge<\/span>;<\/span>\r\n+<\/span>----------+<\/span>\r\n|<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> |<\/span>\r\n+<\/span>----------+<\/span>\r\n|<\/span> 17774854<\/span> |<\/span>\r\n+<\/span>----------+<\/span>\r\n1<\/span> row<\/span> in<\/span> set<\/span> (<\/span>48<\/span>.<\/span>76<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
                                          \u6696\u673a\u4e4b\u540e\u600e\u4e48\u6837\u5462\uff1f<\/p>\n
                                          MariaDB<\/span>><\/span> SELECT<\/span> SQL_NO_CACHE<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> FROM<\/span> hoge<\/span>;<\/span>\r\n+<\/span>----------+<\/span>\r\n|<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> |<\/span>\r\n+<\/span>----------+<\/span>\r\n|<\/span> 17774854<\/span> |<\/span>\r\n+<\/span>----------+<\/span>\r\n1<\/span> row<\/span> in<\/span> set<\/span> (<\/span>11<\/span>.<\/span>81<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
                                          \u8fd9\u9700\u8981\u82b1\u8d3911\u79d2\u949f……\u662f\u56e0\u4e3a\u6240\u6709\u8bbe\u7f6e\u90fd\u662f\u9ed8\u8ba4\u7684\uff0c\u6240\u4ee5\u662f\u7f13\u51b2\u533a\u4e0d\u8db3\uff0c\u8fd8\u662f\u8fd9\u662f\u7531\u4e8eRocksDB\u7684\u7ed3\u6784\u5bfc\u81f4\u7684\u5f00\u9500\u5462\u3002<\/p>\n
                                          \u65e0\u8bba\u5982\u4f55\uff0c\u6211\u5df2\u7ecf\u660e\u767d\u5728\u5b9e\u9645\u4f7f\u7528\u4e2d\u9700\u8981\u8fdb\u884c\u8c03\u6574\u3002<\/p>\n
                                          \u6700\u540e\u5e0c\u671b\u901a\u8fc7\u672c\u6587\u80fd\u591f\u589e\u52a0\u5bf9MyRocks\u7684\u4e86\u89e3\u548c\u6848\u4f8b\u3002\u8bb8\u591a\u4f01\u4e1a\u6b63\u5728\u8003\u8651\u5c06MySQL 5.6\u8fc1\u79fb\u5230MariaDB\u8fd8\u662fMySQL 5.7\u3002\u5e0c\u671b\u8fd9\u5bf9\u8fd9\u4e9b\u4f01\u4e1a\u4e5f\u6709\u6240\u5e2e\u52a9\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
                                          \u56e0\u4e3a\u5728MySQL\u9886\u57df\u5f15\u8d77\u4e86\u8f70\u52a8\u7684MyRocks\uff0c\u6240\u4ee5\u57282017\u5e745\u670823\u65e5\u53d1\u5e03\u7684MariaDB 10.2.6\u4e2d […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[227],"class_list":["post-28832","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-227"],"yoast_head":"\n\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u5173\u4e8e\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c06-mysql5-6-\u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a-myrocks-\u5728-mariadb-\u4e2d\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d\" \/>\n<meta property=\"og:description\" content=\"\u5173\u4e8e\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c06-mysql5-6-\u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a-myrocks-\u5728-mariadb-\u4e2d\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-20T21:37:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-12T02:20:42+00:00\" \/>\n<meta name=\"author\" content=\"\u79d1, \u96c5\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u79d1, \u96c5\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/\",\"name\":\"\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-08-20T21:37:24+00:00\",\"dateModified\":\"2025-08-12T02:20:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a\"},\"description\":\"\u5173\u4e8e\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d\u7684\u6280\u672f\u6587\u7ae0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a\",\"name\":\"\u79d1, \u96c5\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g\",\"caption\":\"\u79d1, \u96c5\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keya\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d - Blog - Silicon Cloud","description":"\u5173\u4e8e\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d\u7684\u6280\u672f\u6587\u7ae0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c06-mysql5-6-\u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a-myrocks-\u5728-mariadb-\u4e2d\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d","og_description":"\u5173\u4e8e\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d\u7684\u6280\u672f\u6587\u7ae0","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c06-mysql5-6-\u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a-myrocks-\u5728-mariadb-\u4e2d\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-08-20T21:37:24+00:00","article_modified_time":"2025-08-12T02:20:42+00:00","author":"\u79d1, \u96c5","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u79d1, \u96c5","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/","name":"\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-08-20T21:37:24+00:00","dateModified":"2025-08-12T02:20:42+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a"},"description":"\u5173\u4e8e\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d\u7684\u6280\u672f\u6587\u7ae0","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5c06 MySQL5.6 \u4e2d\u7684\u8868\u683c\u8f6c\u6362\u4e3a MyRocks \u5728 MariaDB \u4e2d"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a","name":"\u79d1, \u96c5","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g","caption":"\u79d1, \u96c5"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keya\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%86-mysql5-6-%e4%b8%ad%e7%9a%84%e8%a1%a8%e6%a0%bc%e8%bd%ac%e6%8d%a2%e4%b8%ba-myrocks-%e5%9c%a8-mariadb-%e4%b8%ad%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28832","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=28832"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28832\/revisions"}],"predecessor-version":[{"id":111394,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28832\/revisions\/111394"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=28832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=28832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=28832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}