Hi !
murthy gandikota wrote:
Hi
[[...]] Mysql is storing data in the /usr partition of Redhat 9.
> The /usr partition is about 50% full.
> Within a year it will outlast the available space on /usr.
The MySQL data should all be below "/usr/local", right ?
It is trivial in Linux (or any Unix) to create a file system on some new
partition and to mount this anywhere in the hierarchy,
you are not limited to the top level like in Windows.
Create a new partition and put "/usr/local" there.
This will also have advantages when you upgrade the OS.
The /var partition on the same machine has lots of free space.
If you don't have un-allocated disk space for a new partition,
*and* you can't get another disk (monetary or hardware restrictions),
*and* there is plenty of free space in "/var",
then a re-partitioning that splits the current "/var" into two (one for
a reduced "/var", one for "/usr/local") would work.
I am thinking if it is possible to store the data in the /var paritition,
> that would be a temporary fix until I can move the whole operation
> on to a bigger disk which could take a year
Well, a symbolic link putting "/usr/local" into "/var" might also work,
but it will not provide you with the additional advantages of having
"/usr/local" in a file system of its own.
> (given the company bottom line :).
Are your restrictions really so tight that you can't afford a new disk ?
I know this is money, but the admin work time (both DBMS and OS) to get
around disk space issues is costly as well, so I assume the disk to be
cheaper (at current prices and wages).
Can someone please tell me how to manage multiple disk partitions
> in mysql?
It is no different from general Linux/Unix file system handling,
mounting, and symbolic links - you can get there without changing path
names.
> BTW, the mysql is version 4 or something like that.
IMO: Time for an upgrade !
I propose to get a new disk, copy the data there, and then upgrade.
As RedHat 9 is quite old as well, this sounds like a complete system
upgrade:
- Get a new disk into the machine,
- install a current Linux there,
using a partition scheme that has sufficient space for MySQL data,
- install a current (5.0) MySQL in it,
- migrate the MySQL data and any user data,
- after verifying it all works, remove the old disk
(archive it, or use it for other purposes).
HTH,
Joerg
--
Joerg Bruehe, Senior Production Engineer
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]