Professional Web Applications Themes

Troubleshooting file size issues - MySQL

I'm running MySQL on my production servers here. "--version" says "mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686)". OS is RedHat Enterprise ES version 4. Over the weekend our /mysql partition filled up completely. I was able to delete some unused databases, shut down mysql, move the data files to a partition with more space, and restart mysql. I'm now trying to figure out where all the disk space is going. I can see the per-database directories, and it looks like the files in those directories are believable sizes. Our largest customer database directories are 295 MB, 95 MB, 67 ...

  1. #1

    Default Troubleshooting file size issues

    I'm running MySQL on my production servers here. "--version" says "mysql
    Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686)". OS is RedHat
    Enterprise ES version 4.

    Over the weekend our /mysql partition filled up completely. I was able to
    delete some unused databases, shut down mysql, move the data files to a
    partition with more space, and restart mysql. I'm now trying to figure out
    where all the disk space is going.

    I can see the per-database directories, and it looks like the files in
    those directories are believable sizes. Our largest customer database
    directories are 295 MB, 95 MB, 67 MB, and 28 MB. In the /mysql dir itself,
    though, is where the really big files live. We're looking at stuff like:
    -rw-rw---- 1 mysql root 18874368 Nov 7 01:02 ibdata1
    -rw-rw---- 1 mysql ident 26318883 Nov 7 08:52 www2-bin.000048
    -rw-rw---- 1 mysql ident 262168698 Jul 14 23:38 www2-bin.000021
    -rw-rw---- 1 mysql ident 407044096 Nov 6 18:21 www2-bin.000033
    -rw-rw---- 1 mysql ident 753588172 Mar 28 2005 www4-bin.045
    -rw-rw---- 1 mysql ident 836282364 Oct 2 09:06 www2-bin.000027
    -rw-rw---- 1 mysql ident 980598866 Sep 7 14:55 www2-bin.000025
    -rw-rw---- 1 mysql ident 1073741871 Mar 5 2005 www4-bin.043
    -rw-rw---- 1 mysql ident 1073741876 Feb 3 2005 www4-bin.041
    -rw-rw---- 1 mysql ident 1073741877 Oct 26 17:28 www2-bin.000031
    -rw-rw---- 1 mysql ident 1073741888 Mar 18 2005 www4-bin.044
    -rw-rw---- 1 mysql ident 1073741898 Feb 19 2005 www4-bin.042
    -rw-rw---- 1 mysql ident 1073741918 Jul 13 10:52 www2-bin.000020
    -rw-rw---- 1 mysql ident 1073741930 Jul 4 04:41 www2-bin.000019
    -rw-rw---- 1 mysql ident 1073741980 Jul 28 10:22 www2-bin.000022
    -rw-rw---- 1 mysql ident 1073741985 Oct 14 00:00 www2-bin.000030
    -rw-rw---- 1 mysql ident 1073742139 Nov 3 20:13 www2-bin.000032

    I'd like to figure out what's in those blasted bin files, and whether I
    can get rid of them. Any pointers to where I can find that doented?
    I've searched everyplace I can think of to look, but running on 2 hours
    sleep in the last 2 days means I'm not firing on all cylinders :)

    Dan M Guest

  2. #2

    Default Re: Troubleshooting file size issues

    On Mon, 07 Nov 2005 08:52:46 -0800, Dan M wrote:
    > I'm running MySQL on my production servers here. "--version" says "mysql
    > Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686)". OS is RedHat
    > Enterprise ES version 4.
    >
    > Over the weekend our /mysql partition filled up completely. I was able to
    > delete some unused databases, shut down mysql, move the data files to a
    > partition with more space, and restart mysql. I'm now trying to figure out
    > where all the disk space is going.
    Never mind - I just found
    [url]http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/RESET_MASTER.html[/url]

    Those are my binary logs.

    Dan M Guest

Similar Threads

  1. Troubleshooting locked file
    By Martinobodo in forum Macromedia Contribute General Discussion
    Replies: 0
    Last Post: June 11th, 12:40 PM
  2. File Size issues with placed graphics
    By barbarapress@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 4
    Last Post: July 6th, 12:55 AM
  3. Troubleshooting DataDirect SequeLink ODBC service issues
    By Tom Jordahl in forum Coldfusion Server Administration
    Replies: 2
    Last Post: March 24th, 05:46 PM
  4. CAN I CHANGE SIZE (PIXELS) OF A PROJECTOR TO REDUCE THE FILE SIZE?
    By JB in forum Macromedia Director Basics
    Replies: 0
    Last Post: August 3rd, 06:04 PM
  5. (Tiny) Size issues with laptop WUXGA screen
    By rkach webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: July 7th, 11:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139