SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Evangelist runeveryday's Avatar
    Join Date
    Jul 2009
    Posts
    437
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    the database's size ?

    when i used phpmyadmin to backup my database,i found in phpmyadmin,the dababase's size is 8.4 MB.but i backed it to the local,its size is 10 MB,why they are different ?
    Outdoor tools online store and wargame tools shop
    with best quality and service.
    comp molle tactical vest tactical clothing etc sell

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,072
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    The difference will probably be the size of the index for the database.
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  3. #3
    SitePoint Evangelist runeveryday's Avatar
    Join Date
    Jul 2009
    Posts
    437
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    i can't understand what you have said.
    Outdoor tools online store and wargame tools shop
    with best quality and service.
    comp molle tactical vest tactical clothing etc sell

  4. #4
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,072
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    Run this query, it should explain it a bit better.

    Code SQL:
    SELECT concat( table_schema,  '.', TABLE_NAME ) TABLE_NAME, concat( round( data_length /  ( 1024 *1024  ) , 2  ) ,  'M'  ) data_length, concat( round( index_length /  ( 1024 *1024  ) , 2  ) ,  'M'  ) index_length, concat( round( round( data_length +  index_length )  / ( 1024 *1024  ) , 2  ) ,  'M'  ) total_size
    FROM information_schema.TABLES
    WHERE table_schema =  '#database_name#'

    Substitute #database_name# for the name of whatever database you want to find out how big it is (the sizes given are in MB).
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  5. #5
    SitePοint Troll disgracian's Avatar
    Join Date
    Aug 2006
    Location
    Samsara
    Posts
    451
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I don't know about MySQL, but some database systems will pre-allocate hard drive space based on growth rules.

    Cheers,
    D.


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
  •