Professional Web Applications Themes

disk usage of mysql db - MySQL

I know that I can gauge the disk space usage of my tables with : show table status; and look at the Data_length column for each table, which is in bytes. But does anyone know of another way to gauge the disk usage of MySQL dbs via the prompt? -- Jack Vamvas ___________________________________ Need an IT job? http://www.ITjobfeed.com...

  1. #1

    Default disk usage of mysql db

    I know that I can gauge the disk space usage of my tables with :

    show table status;
    and look at the Data_length column for each table, which is in bytes.

    But does anyone know of another way to gauge the disk usage of MySQL dbs via
    the prompt?


    --

    Jack Vamvas
    ___________________________________
    Need an IT job? http://www.ITjobfeed.com




    Jack Guest

  2. #2

    Default Re: disk usage of mysql db

    On Fri, 18 May 2007 12:49:37 +0100, Jack Vamvas wrote: 

    du(1) from the appropriate directory.

    --
    "Every new technology carries with it an opportunity to invent a new
    crime." --Laurence Urgenson (an assistant chief US attorney),
    speaking in 1987 about the first arrests for what was later called
    cellphone cloning.
    Peter Guest

  3. #3

    Default Re: disk usage of mysql db

    Peter H. Coffin wrote: 
    >
    > du(1) from the appropriate directory.
    >[/ref]
    a variation of du that has served me well:
    du -h -d1
    from the data directory.

    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

Similar Threads

  1. Scratch disk & Memory usage
    By Patti Anderson in forum Adobe Photoshop Elements
    Replies: 9
    Last Post: March 29th, 07:07 PM
  2. Disk usage oddity
    By Phil Stovell in forum Ubuntu
    Replies: 4
    Last Post: February 21st, 11:30 AM
  3. Perl module disk usage, for embedded system.
    By Makavy in forum PERL Modules
    Replies: 0
    Last Post: December 5th, 04:38 PM
  4. Oracle disk contention/ cpu usage
    By Mike Ross in forum Oracle Server
    Replies: 1
    Last Post: January 11th, 09:28 AM

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