+ Reply to Thread
Results 1 to 5 of 5

Thread: MySQL storage

  1. #1
    moinkhan is offline x10Hosting Member moinkhan is an unknown quantity at this point
    Join Date
    Feb 2009
    Posts
    21

    MySQL storage

    Before I get too far ahead with the development of my site (Free Hosting, Ad Free) I wanted to know:

    (1) If x10Hosting places any storage cap for MySQL databases, or is it part of overall account storage limit?
    (2) How many tables can a DB have?
    (3) How big a table can be? Any storage limitation? Any number of records limitation?

  2. #2
    Livewire's Avatar
    Livewire is offline Abuse Compliance Officer Livewire is a glorious beacon of lightLivewire is a glorious beacon of light
    Join Date
    Jun 2005
    Location
    Behind a keyboard.
    Posts
    8,998

    Re: MySQL storage

    1) Part of disc space used.

    2) Far as I know there's no limit, or its a limit so high your database will begin to be slow to run queries on before you get there.

    3) See 2; if the tables are designed well, it'll be a very high number before you notice slowdown. If it's designed poorly, you could begin bogging down at as few as 1000. If it's not, you could easily get upwards of 50,000 records (I've got a table at 60,345 records, it's taking 0.0340 sec to complete a search on the FileEntry field).



    So the two key's I've learned:

    1: PLAN IT OUT! Especially the database part - make sure you know what goes where first, so it's organized in a way to make searching easy.

    2: Watch your disc space usage - if you run a big forum and it gets popular, it'll eat that up faster than I eat up a bag of Oreo's, and take it from me, I eat them little buddies up fast ^_^


    TOS breakers will be suspended regardless of race, creed, national origin, hair color, or favorite food. Thanks for your understanding!

  3. #3
    garrettroyce's Avatar
    garrettroyce is offline Generally Helpful Member garrettroyce is a glorious beacon of lightgarrettroyce is a glorious beacon of light
    Join Date
    Apr 2008
    Location
    IL, USA
    Posts
    3,746

    Re: MySQL storage

    Awesome, Livewire, I actually laughed out loud when I read your post :P

    SQL by design is an extremely well optimized storage. As Livewire said, as long as you do your part to design the database well and use efficient queries, the number of records can be astronomical in your database without an issue. Imagine the database for this forum here, or even Google.com's database of probably billions of pages.
    gjr.gr - coming soon: secrets of OCD coding from a self taught tinkerer

  4. #4
    moinkhan is offline x10Hosting Member moinkhan is an unknown quantity at this point
    Join Date
    Feb 2009
    Posts
    21

    Re: MySQL storage

    Thanks, Livewire. I'll keep that in mind. Even without being popular, I will face challenge with storage, because I am dealing with user submitted blobs (images).

  5. #5
    lemon-tree's Avatar
    lemon-tree is offline x10 Minion lemon-tree has a spectacular aura about
    Join Date
    Nov 2007
    Posts
    1,420

    Re: MySQL storage

    You could always just store a reference to the files in the database instead of the files themselves, which would be kept in an external folder. That might speed up query times.

+ Reply to Thread

Similar Threads

  1. [PHP] MySQL and PHP
    By Bryon in forum Tutorials
    Replies: 43
    Last Post: 03-24-2011, 07:27 AM
  2. Which is better postgresql or MySQL?
    By Kurai Kumo in forum Scripts & 3rd Party Apps
    Replies: 11
    Last Post: 12-10-2009, 08:17 AM
  3. Replies: 14
    Last Post: 09-29-2008, 07:07 PM
  4. New Site-Suggestions?
    By mnoutside in forum Review My Site
    Replies: 9
    Last Post: 08-27-2008, 07:01 AM
  5. Have a problem with my forum
    By tikloos in forum Scripts & 3rd Party Apps
    Replies: 43
    Last Post: 01-19-2006, 01:14 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
x10hosting free hosting for the masses
dedicated servers