<tfoot id='9KusB'></tfoot>
  • <legend id='9KusB'><style id='9KusB'><dir id='9KusB'><q id='9KusB'></q></dir></style></legend>
      <bdo id='9KusB'></bdo><ul id='9KusB'></ul>
    <i id='9KusB'><tr id='9KusB'><dt id='9KusB'><q id='9KusB'><span id='9KusB'><b id='9KusB'><form id='9KusB'><ins id='9KusB'></ins><ul id='9KusB'></ul><sub id='9KusB'></sub></form><legend id='9KusB'></legend><bdo id='9KusB'><pre id='9KusB'><center id='9KusB'></center></pre></bdo></b><th id='9KusB'></th></span></q></dt></tr></i><div id='9KusB'><tfoot id='9KusB'></tfoot><dl id='9KusB'><fieldset id='9KusB'></fieldset></dl></div>
    1. <small id='9KusB'></small><noframes id='9KusB'>

        加速 mysql 转储和导入

        时间:2023-06-02
          <bdo id='09JGc'></bdo><ul id='09JGc'></ul>
          • <legend id='09JGc'><style id='09JGc'><dir id='09JGc'><q id='09JGc'></q></dir></style></legend>
                <tbody id='09JGc'></tbody>

                <tfoot id='09JGc'></tfoot>

                1. <i id='09JGc'><tr id='09JGc'><dt id='09JGc'><q id='09JGc'><span id='09JGc'><b id='09JGc'><form id='09JGc'><ins id='09JGc'></ins><ul id='09JGc'></ul><sub id='09JGc'></sub></form><legend id='09JGc'></legend><bdo id='09JGc'><pre id='09JGc'><center id='09JGc'></center></pre></bdo></b><th id='09JGc'></th></span></q></dt></tr></i><div id='09JGc'><tfoot id='09JGc'></tfoot><dl id='09JGc'><fieldset id='09JGc'></fieldset></dl></div>

                  <small id='09JGc'></small><noframes id='09JGc'>

                2. 本文介绍了加速 mysql 转储和导入的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  是否有任何记录在案的技术来加速 mySQL 转储和导入?

                  Are there any documented techniques for speeding up mySQL dumps and imports?

                  这将包括 my.cnf 设置、使用 ramdisks 等.

                  This would include my.cnf settings, using ramdisks, etc.

                  只寻找记录在案的技术,最好有显示潜在加速的基准.

                  Looking only for documented techniques, preferably with benchmarks showing potential speed-up.

                  推荐答案

                  http://www.maatkit.org/ 有一个 mk-parallel-dump 和 mk-parallel-restore

                  http://www.maatkit.org/ has a mk-parallel-dump and mk-parallel-restore

                  如果您一直希望使用多线程 mysqldump,请不要再希望了.此工具并行转储 MySQL 表.它是一个更智能的 mysqldump,既可以作为 mysqldump 的包装器(具有合理的默认行为),也可以作为 SELECT INTO OUTFILE 的包装器.它专为处理非常大数据的高性能应用程序而设计,其中速度非常重要.它利用多个 CPU 和磁盘来更快地转储您的数据.

                  If you’ve been wishing for multi-threaded mysqldump, wish no more. This tool dumps MySQL tables in parallel. It is a much smarter mysqldump that can either act as a wrapper for mysqldump (with sensible default behavior) or as a wrapper around SELECT INTO OUTFILE. It is designed for high-performance applications on very large data sizes, where speed matters a lot. It takes advantage of multiple CPUs and disks to dump your data much faster.

                  mysqldump 中还有各种潜在的选项,例如在导入转储时不创建索引 - 而是在完成时将它们集中起来.

                  There are also various potential options in mysqldump such as not making indexes while the dump is being imported - but instead doing them en-mass on the completion.

                  这篇关于加速 mysql 转储和导入的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:在关系数据库中存储树结构的已知方法有哪些? 下一篇:MySQL - 在 WHERE 子句中使用 COUNT(*)

                  相关文章

                      • <bdo id='gA813'></bdo><ul id='gA813'></ul>
                      <tfoot id='gA813'></tfoot>
                    1. <legend id='gA813'><style id='gA813'><dir id='gA813'><q id='gA813'></q></dir></style></legend>

                      <small id='gA813'></small><noframes id='gA813'>

                    2. <i id='gA813'><tr id='gA813'><dt id='gA813'><q id='gA813'><span id='gA813'><b id='gA813'><form id='gA813'><ins id='gA813'></ins><ul id='gA813'></ul><sub id='gA813'></sub></form><legend id='gA813'></legend><bdo id='gA813'><pre id='gA813'><center id='gA813'></center></pre></bdo></b><th id='gA813'></th></span></q></dt></tr></i><div id='gA813'><tfoot id='gA813'></tfoot><dl id='gA813'><fieldset id='gA813'></fieldset></dl></div>