Results 1 to 5 of 5
  1. #1

    mysql storage question?

    Hi all

    A hosting company is providing me with 1 Gb space for mysql databases. I want to know that how MUCH is that space for me.?

    I will run a website on this hosting containing one database containing probably 20 tables(7fields max). Each table will contain around 1000 entries.

    Will this 1Gb mysql storage meet this specs?

    regards.

  2. #2
    Join Date
    Feb 2006
    Location
    Kusadasi, Turkey
    Posts
    3,273
    If you don't host images in your database, your DB should be something around 2MB - 20MB.

    1GB of database space is a lot (unless you host files in the DB, which I seriously doubt.)
    Fraud Record - Stop Fraud Clients, Report Abusive Customers.
    █ Combine your efforts to fight misbehaving clients.

    HarzemDesign - Highest quality, well designed and carefully coded hosting designs. Not cheap though.
    █ Large and awesome portfolio, just visit and see!

  3. #3
    The 'show table status' statement in mysql will help you figure out how much if space you're going to use per row. http://dev.mysql.com/doc/refman/5.1/...le-status.html

  4. #4
    ya, thanks. I've checked the storage from phpmyadmin. Thanks all.

  5. #5
    Join Date
    Aug 2007
    Location
    Brighton, UK
    Posts
    63
    Basically - if you go over 1Gb of data; either you have an unusually large data set, or you're storing binary files in your database.

    Storing images and other files in a database, while possible, should be discouraged for performance reasons - it's much quicker to access a file directly on the filesystem than it is to pull it out of a database. If you need to keep a database of files, simply put all the files in one directory and reference them in the database by filename.

Similar Threads

  1. storage question
    By snork300 in forum Colocation and Data Centers
    Replies: 3
    Last Post: 12-18-2008, 10:32 PM
  2. Need PHP, MySql, 10 GB+ storage
    By LegendLength in forum Web Hosting
    Replies: 5
    Last Post: 09-18-2008, 04:05 AM
  3. MySQL storage engine error!
    By IR5 in forum Hosting Security and Technology
    Replies: 5
    Last Post: 04-14-2006, 04:33 PM
  4. Mysql Storage Overhead solution?
    By tabish in forum Hosting Security and Technology
    Replies: 0
    Last Post: 12-19-2005, 03:29 AM
  5. Maximum MySQL storage.
    By DjPaj in forum Web Hosting Lounge
    Replies: 4
    Last Post: 03-27-2002, 02:03 AM

Posting Permissions

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