Re: MySQL server is taking all my hardrive space
Most likely, binary logs are populating the space. Read http://dev.mysql.com/doc/mysql/en/PURGE_MASTER_LOGS.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL server is taking all my hardrive space
Hello, I have a server with 18Gb of space. I have ran du to figure out how the harddrive is being used and I realized that the directory that is taking the most space is /var/lib/mysql I know that now I have much less database records than I used to have and I have the same database structure having not change any index or table. So I think there must be a bug and somehow the mysql server is consuming my entire harddrive. I have also ran show table status to see the actual physical size of each table. They do not correspond to 10Gb, much less in fact, but the dir where MySQL resides /var/lib/mysql is consuming about 10Gb of my hard drive. What can be going wrong here? I am running 4.0.20-Max-log Thanks, C.F. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
More on MySQL server is taking all my hardrive space
Hello, On a further inspection and by reading Paul DuBois' I guess m y system has to many bin logs. How can I get ride of them? Thanks in advance, C.F. C.F. Scheidecker Antunes wrote: Hello, I have a server with 18Gb of space. I have ran du to figure out how the harddrive is being used and I realized that the directory that is taking the most space is /var/lib/mysql I know that now I have much less database records than I used to have and I have the same database structure having not change any index or table. So I think there must be a bug and somehow the mysql server is consuming my entire harddrive. I have also ran show table status to see the actual physical size of each table. They do not correspond to 10Gb, much less in fact, but the dir where MySQL resides /var/lib/mysql is consuming about 10Gb of my hard drive. What can be going wrong here? I am running 4.0.20-Max-log Thanks, C.F. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL server is taking all my hardrive space
Unless you're running InnoDB (with lots of data and indexes) I would assume your trouble has to do with the fact that you are running I am running 4.0.20-Max-log. (Namely the log part) How large are the logs in /var/lib/mysql? j- k- On Wednesday 20 October 2004 22:41, C.F. Scheidecker Antunes said something like: Hello, I have a server with 18Gb of space. I have ran du to figure out how the harddrive is being used and I realized that the directory that is taking the most space is /var/lib/mysql I know that now I have much less database records than I used to have and I have the same database structure having not change any index or table. So I think there must be a bug and somehow the mysql server is consuming my entire harddrive. I have also ran show table status to see the actual physical size of each table. They do not correspond to 10Gb, much less in fact, but the dir where MySQL resides /var/lib/mysql is consuming about 10Gb of my hard drive. What can be going wrong here? I am running 4.0.20-Max-log Thanks, C.F. -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: More on MySQL server is taking all my hardrive space
On Thu, 21 Oct 2004, C.F. Scheidecker Antunes wrote: Hello, On a further inspection and by reading Paul DuBois' I guess m y system has to many bin logs. How can I get ride of them? Assuming you don't need them for replication or point-in-time recovery, you can use the PURGE command. http://dev.mysql.com/doc/mysql/en/PURGE_MASTER_LOGS.html If you do not need the binary logs for anything, and you're not running replication you can remove all of them and restart at binlog.01 with the command RESET MASTER (I'd suggest using the PURGE, though). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]