• <i id='5HCPs'><tr id='5HCPs'><dt id='5HCPs'><q id='5HCPs'><span id='5HCPs'><b id='5HCPs'><form id='5HCPs'><ins id='5HCPs'></ins><ul id='5HCPs'></ul><sub id='5HCPs'></sub></form><legend id='5HCPs'></legend><bdo id='5HCPs'><pre id='5HCPs'><center id='5HCPs'></center></pre></bdo></b><th id='5HCPs'></th></span></q></dt></tr></i><div id='5HCPs'><tfoot id='5HCPs'></tfoot><dl id='5HCPs'><fieldset id='5HCPs'></fieldset></dl></div>
  • <legend id='5HCPs'><style id='5HCPs'><dir id='5HCPs'><q id='5HCPs'></q></dir></style></legend>

    <tfoot id='5HCPs'></tfoot>

  • <small id='5HCPs'></small><noframes id='5HCPs'>

      <bdo id='5HCPs'></bdo><ul id='5HCPs'></ul>

      1. 无需重启服务器即可清除 MySQL 查询缓存

        时间:2023-06-03

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

          <tbody id='LaNLp'></tbody>

          1. <tfoot id='LaNLp'></tfoot>

                <bdo id='LaNLp'></bdo><ul id='LaNLp'></ul>

                  <legend id='LaNLp'><style id='LaNLp'><dir id='LaNLp'><q id='LaNLp'></q></dir></style></legend>

                  <i id='LaNLp'><tr id='LaNLp'><dt id='LaNLp'><q id='LaNLp'><span id='LaNLp'><b id='LaNLp'><form id='LaNLp'><ins id='LaNLp'></ins><ul id='LaNLp'></ul><sub id='LaNLp'></sub></form><legend id='LaNLp'></legend><bdo id='LaNLp'><pre id='LaNLp'><center id='LaNLp'></center></pre></bdo></b><th id='LaNLp'></th></span></q></dt></tr></i><div id='LaNLp'><tfoot id='LaNLp'></tfoot><dl id='LaNLp'><fieldset id='LaNLp'></fieldset></dl></div>
                  本文介绍了无需重启服务器即可清除 MySQL 查询缓存的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  有没有什么办法可以在不重启mySQL服务器的情况下清除mysql查询缓存?

                  Is there any way to clear mysql query cache without restarting mySQL server?

                  推荐答案

                  我相信你可以用...

                  RESET QUERY CACHE;
                  

                  ...如果您运行的用户具有重新加载权限.或者,您可以通过以下方式对查询缓存进行碎片整理...

                  ...if the user you're running as has reload rights. Alternatively, you can defragment the query cache via...

                  FLUSH QUERY CACHE;
                  

                  查看查询缓存状态和MySQL 手册的维护部分了解更多信息.

                  See the Query Cache Status and Maintenance section of the MySQL manual for more information.

                  这篇关于无需重启服务器即可清除 MySQL 查询缓存的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:ALTER TABLE 添加复合主键 下一篇:如何使用 Sequelize CLI 从 Sequelize 模型自动生成迁移?

                  相关文章

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

                  <legend id='MsQ7e'><style id='MsQ7e'><dir id='MsQ7e'><q id='MsQ7e'></q></dir></style></legend>
                  <tfoot id='MsQ7e'></tfoot>

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

                    • <bdo id='MsQ7e'></bdo><ul id='MsQ7e'></ul>