RE: Disk Full Problem....

From: Srinivas Koppisetti (skoppisetti_at_gjusa.com)
Date: 02/20/04

  • Next message: Saqib Ali: "Re: HP DL 360 and RedHat 3.x ES" 
    To: "redhat-list@redhat.com" <redhat-list@redhat.com>
Date: Fri, 20 Feb 2004 13:41:09 -0500

    Ed,

    Thanks.. We tried to delete as much as possible but still the database is
    occupying max space on the volume.

    Can we move mysql data files to a different volume and ask the endine to
    pick the data files from there. If so I need some more help on how to do
    that.

    -----Original Message-----
    From: Ed Wilts [mailto:ewilts@ewilts.org]
    Sent: Friday, February 20, 2004 1:37 PM
    To: redhat-list@redhat.com
    Subject: Re: Disk Full Problem....

    On Fri, Feb 20, 2004 at 01:26:43PM -0500, Srinivas Koppisetti wrote:
    > Ed,
    > We store log infomation for our web servers in the Mysql instance. This
    > database has grown a lot in past 2 weeks.
    >
    > Andrew, no we do not have lvm installed on the server.
    >
    > We tried to move the studd around our db is 3.3GB and the total volume is
    > 4GB looks like there are some binaries in there too.

    Do you have another disk you can move the database to? It's not that
    hard to tell MySQL to use a database from another disk. The default is
    /var/lib/mysql/

    In an emergency basis, you might be able to clean up some space in some
    of your other large directories. For example, clean up /var/log and
    /var/spool/up2date (the rpm and hdr files can be safely deleted - you
    can always download them again if you need to).
      

    -- 
Ed Wilts, Mounds View, MN, USA
mailto:ewilts@ewilts.org
Member #1, Red Hat Community Ambassador Program
-- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list
=========================================================================== 
This electronic transmission contains confidential information intended only 
for the person(s) named.  Any use, distribution, copying, or disclosure by 
any other person is strictly prohibited.  If you received this transmission 
in error, please notify the sender by return e-mail and delete all copies of 
this message. 
=========================================================================== 
-- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list
  • Next message: Saqib Ali: "Re: HP DL 360 and RedHat 3.x ES"

    Relevant Pages

    • RE: FreeBSD 5.3 MySQL Performance
      ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
      (freebsd-questions)
    • RE: Disk Full Problem....
      ... the data files to that volume and create symbolic links and see if that ... Subject: Disk Full Problem.... ... > Can we move mysql data files to a different volume and ask the endine to ... I have not verified that mysql follows ...
      (RedHat)
    • Is transaction log file reuseable after data file is Restored?
      ... We have a database that is set to Simple recovery mode and is backed up ... disk and the log file is on a different disk. ... During the day the disk controller on the disk with the data files has ...
      (microsoft.public.sqlserver.server)
    • Re: Mysql database migration.
      ... > database (mysql) and choose the database i want to move. ... > my disk and be able to copy this database into another sql server. ...
      (perl.dbi.users)
    • Re: MySQL Database problem (probably already solved in a message, but this is somewhat urgent)
      ... MySQL server has a database with a table, ... columns, an FSR column, and a password column. ... checked if the supposed arrays that were returned were actually arrays ...
      (comp.lang.php)