On 26.7.2010 12:43, AlannY wrote:
I have a huge database with several tables. Some tables have statistics
information. And it's very huge. I don't want to loose any of this data.
But hard drives on my single server are not eternal. Very soon, there will
be no left space. And the most awful this, that it's a 1U server, and I
can't install new hard drive.
What can I do to enlarge space, without loosing data and performance?
Absolutely nothing quick and easy. In fact, about the only thing you can
do which won't cause a (long term) data loss and performance degradation
is a full backup, installing bigger drives to replace the old ones, and
Some other ideas which might help you if you don't want to swap drives,
but generally require a lot of work and you *will* lose either data or
* use a file system which supports compression (NTFS on Windows, ZFS on
FreeBSD & Solaris, don't know any on Linux)
* move unneeded data out from the database and into a separate,
compressed data storage format (e.g. move statistical data into gzipped
csv or text files or something to that effect)
* buy external storage (NAS, or even an external USB drive), move the
database to it
* use an external data storage service like amazon s3 (actually, this is
a bad idea since you will need to completely rewrite your database and
* decide that you really don't need some of the data and just delete it.