Re: Disk parition full

2007-02-27 Thread Joerg Bruehe
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 U

Re: Disk parition full

2007-02-27 Thread Filip Krejci
Hi, in case you have MyIsam tables you can also use LVM. Nils Meyer napsal(a): Hi Murthy, murthy gandikota wrote: Can someone please tell me how to manage multiple disk partitions in mysql? BTW, the mysql is version 4 or something like that. When using InnoDB you can just add another tabl

Re: Disk parition full

2007-02-27 Thread Nils Meyer
Hi Murthy, murthy gandikota wrote: Can someone please tell me how to manage multiple disk partitions in mysql? BTW, the mysql is version 4 or something like that. When using InnoDB you can just add another tablespace on /var [1]. With MyISAM it gets a bit more difficult, at least in pre 5.

Disk parition full

2007-02-26 Thread murthy gandikota
Hi I have looked up earlier postings on disk partitions and mysql and couldn't find any discussion threads. 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 /var partition on the