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

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

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

      <tfoot id='PBlhd'></tfoot>
      1. Google Cloud SQL 无缘无故地增加大小直到磁盘满

        Google Cloud SQL increasing size until full disk with no reason(Google Cloud SQL 无缘无故地增加大小直到磁盘满)
          <tfoot id='KI5T0'></tfoot>
          <i id='KI5T0'><tr id='KI5T0'><dt id='KI5T0'><q id='KI5T0'><span id='KI5T0'><b id='KI5T0'><form id='KI5T0'><ins id='KI5T0'></ins><ul id='KI5T0'></ul><sub id='KI5T0'></sub></form><legend id='KI5T0'></legend><bdo id='KI5T0'><pre id='KI5T0'><center id='KI5T0'></center></pre></bdo></b><th id='KI5T0'></th></span></q></dt></tr></i><div id='KI5T0'><tfoot id='KI5T0'></tfoot><dl id='KI5T0'><fieldset id='KI5T0'></fieldset></dl></div>

            <tbody id='KI5T0'></tbody>
          • <small id='KI5T0'></small><noframes id='KI5T0'>

                  <bdo id='KI5T0'></bdo><ul id='KI5T0'></ul>
                  <legend id='KI5T0'><style id='KI5T0'><dir id='KI5T0'><q id='KI5T0'></q></dir></style></legend>
                • 本文介绍了Google Cloud SQL 无缘无故地增加大小直到磁盘满的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我不知道如何解释这个问题,但我会尝试.

                  I don't know how to explain this well, but I will try.

                  • 我使用具有 20 GB 磁盘大小的 Google Cloud SQL 第二版.
                  • 我有几个 wp.总大小为 166.5 MB 的数据库.

                  现在我的存储空间使用量为 9.52 GB!(使用 166.5 MB SQL 数据...)并且增加速度仍然更快...

                  And right now my Storage usage is 9.52 GB! (With 166.5 MB SQL data...) and increasing still going faster...

                  怎么办?!

                  更新:

                  我解决了这个问题:

                  • 我在存储桶中进行了导出
                  • 我创建了一个新的 Cloud SQL 实例
                  • 从存储桶导入
                  • 并删除有问题的实例.

                  (并从我的应用程序更改了 ip)

                  (And changed ip from my applications)

                  我不知道问题从何而来,但可能是二进制日志的存储开销".

                  I don't know sure where problem come from but could be a "Storage overhead from binary logs".

                  下次将检查二进制日志:mysql>显示二进制日志;

                  Next time will check binary logs with : mysql> SHOW BINARY LOGS;

                  我认为 Google 缺少的是清除二进制日志!(一个简单的方法!)

                  What I think Google is missing is a purge binary logs! (an easy way!)

                  更新最终版:

                  启用二进制日志后,您的云 SQL 存储将不断扩展.

                  With binary logs active, storage of your cloud SQL will expand continuously.

                  对于处于相同情况的任何人,您可以编辑实例并取消选中二进制日志,之后当前的二进制日志将被清除.

                  For anyone in the same situation, you can edit the instance and uncheck binary logs, after that the current binary logs will purge.

                  抱歉我的菜鸟问题!:D(我是服务器管理的初学者.)

                  Sorry for my noob problem! :D (I'm a beginner in Server administration.)

                  谢谢Vadim

                  推荐答案

                  如果您启用了二进制日志,mysql 将记录所有更改,这是复制或时间点恢复所需的.

                  If you have binary logs enabled, mysql will make a record of all changes, which is required for replication or point-in-time recovery.

                  如果您不需要这些功能,您可以禁用二进制日志,这将从您的实例中清除所有现有日志.

                  If you have no need for these features, you can disable binary logs which will purge any existing logs from your instance.

                  如果启用二进制日志,它们将不会无限增长.早于最早自动备份(7 天)的二进制日志会自动清除.

                  If binary logs are enabled, they will not grow indefinitely. Binary logs older than the oldest automatic backup (7 days) are purged automatically.

                  这篇关于Google Cloud SQL 无缘无故地增加大小直到磁盘满的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                  相关文档推荐

                  Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)(超出最大存储过程、函数、触发器或视图嵌套级别(限制 32))
                  How to debug stored procedure in VS 2015?(如何在 VS 2015 中调试存储过程?)
                  Set the variable result, from query(设置变量结果,来自查询)
                  What is dynamic SQL?(什么是动态 SQL?)
                  Mysql - How to quit/exit from stored procedure(Mysql - 如何退出/退出存储过程)
                  How to find a text inside SQL Server procedures / triggers?(如何在 SQL Server 程序/触发器中查找文本?)

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

                      <tfoot id='BhHL5'></tfoot>

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

                            <tbody id='BhHL5'></tbody>