压缩/数据大小 [英] compacting / data size
问题描述
大家好！
我（仍然）正在进行一些测试（发现我的问题），我想知道大小的b $ b我有数据来计算增长。
作为测试我添加了一些数据，1.69 Gb确切地说是一个数据库，工作
用它，然后我删除了66％的应用程序。当它删除它增长到1.97
Gb。
我想schrik那，因为它永远不会再持有那么多的
数据。
但更重要的是 - 我想知道实际数据中有多少。
重点是，那个我想删除更多的数据，并再次查看尺寸
（数据）。
我该怎么做？
Sonnich
Hi all!
I am (still) running some tests (dispite my problems), and I''d like to
know the size of data I have in order to calculate growth.
As a test I added some data, 1.69 Gb to be exact to a database, working
with it, then I deleted app 66% of it. When deleting it grew to 1.97
Gb.
I''d like to schrik that, as it will never again hold that amount of
data.
But more important - I''d like to know how much of that is actual data.
The point is, that Id like to delete even more data, and see the size
(of data) again.
How do I do that?
Sonnich
推荐答案
" Sonnich" <所以************ @ elektrobit.com>在消息中写道
news：11 ********************** @ v46g2000cwv.googlegr oups.com ...
"Sonnich" <so************@elektrobit.com> wrote in message
news:11**********************@v46g2000cwv.googlegr oups.com...
作为一个测试我添加了一些数据，1.69 Gb确切地说是一个数据库，用它工作，然后我删除了66％的应用程序。删除时增长到1.97 Gb。
As a test I added some data, 1.69 Gb to be exact to a database, working
with it, then I deleted app 66% of it. When deleting it grew to 1.97 Gb.
了解OPTIMIZE TABLE，回收可用空间并对数据进行碎片整理
文件。
http：// dev .mysql.com / doc / refman / 5.0 / ... ize-table.html
问候，
Bill K.
Read about OPTIMIZE TABLE, to reclaim free space and defragment the data
file.
http://dev.mysql.com/doc/refman/5.0/...ize-table.html
Regards,
Bill K.
Bill Karwin写道：
Bill Karwin wrote:
" Sonnich" <所以************ @ elektrobit.com>在消息中写道
新闻：11 ********************** @ v46g2000cwv.googlegr oups.com ...
"Sonnich" <so************@elektrobit.com> wrote in message
news:11**********************@v46g2000cwv.googlegr oups.com...
作为一个测试我添加了一些数据，1.69 Gb确切地说是一个数据库，用它工作，然后我删除了66％的应用程序。删除时增长到1.97 Gb。
As a test I added some data, 1.69 Gb to be exact to a database, working
with it, then I deleted app 66% of it. When deleting it grew to 1.97 Gb.
阅读OPTIMIZE TABLE，回收可用空间并对数据进行碎片整理。
我之前尝试过这个，结果是不存在的。我的数据库是
1.97 GB，并且仍然存在。我可以释放超过一个GB，我只需要知道如何
。
我读过它，写了optimize table mytable，桌子还在，
看着这里提到的页面，看着NG还没有结束
我还有任何解决方案。
我该怎么办？
BR
Sonnich
I have tried this before, and the result is none-existing. My DB is
1.97 GB, and remains. I can free up more than one GB, I just need to
know how.
I read about it, wrote "optimize table mytable", the table remains,
looking at the page mentioned here and looking in the NG has not brough
me to any solution yet.
What exactly should I do?
BR
Sonnich
Sonnich写道：
Sonnich wrote:
Bill Karwin写道：
Bill Karwin wrote:
" Sonnich" <所以************ @ elektrobit.com>在消息中写道
新闻：11 ********************** @ v46g2000cwv.googlegr oups.com ...
"Sonnich" <so************@elektrobit.com> wrote in message
news:11**********************@v46g2000cwv.googlegr oups.com...
作为一个测试我添加了一些数据，1.69 Gb确切地说是一个数据库，用它工作，然后我删除了66％的应用程序。删除时增长到1.97 Gb。
As a test I added some data, 1.69 Gb to be exact to a database, working
with it, then I deleted app 66% of it. When deleting it grew to 1.97 Gb.
阅读OPTIMIZE TABLE，回收可用空间并对数据进行碎片整理。
http://dev.mysql.com/doc/refman/5.0/。 ..ize-table.html
我之前尝试过这个，结果是不存在的。我的数据库是1.97 GB，并且仍然存在。我可以释放超过一个GB，我只需要知道如何。
我读到它，写了优化表mytable，表格仍然是，
看在这里提到的页面，看着NG还没有找到任何解决方案。
我该怎么办？
BR
Sonnich
I have tried this before, and the result is none-existing. My DB is
1.97 GB, and remains. I can free up more than one GB, I just need to
know how.
I read about it, wrote "optimize table mytable", the table remains,
looking at the page mentioned here and looking in the NG has not brough
me to any solution yet.
What exactly should I do?
BR
Sonnich
数据库中有多少个表？你有没有优化所有这些？
Marc
How many tables are there in the database? Did you optimize all of them?
Marc
这篇关于压缩/数据大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
