Astahost.com   Mar 11, 2010
Open Discussion & Free Web Hosting > Computers & Tech > Databases
Pages: 1, 2

Space Needed For Database

free web hosting
Open Discussion & Free Web Hosting > Computers & Tech > Databases

Space Needed For Database

khalilov
Iam assuming the information in the databases i will create will be stored in the 500 MB space i get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest present when you add/edit a row in a table.

Also what are the ranges of tinyint,smallint,mediumint and big int

Comment/Reply (w/o sign-up)

faulty.lee
QUOTE(khalilov @ Jul 21 2008, 08:25 PM) *
Iam assuming the information in the databases i will create will be stored in the 500 MB space i get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest present when you add/edit a row in a table.

Also what are the ranges of tinyint,smallint,mediumint and big int

You can refer to the MySQL documentation for that matter ->http://dev.mysql.com/doc/refman/5.0/en/sto...quirements.html

I would just show you a simple calculation, and 500MB is plenty of space to put your data.

Let's take a worse case scenario, say you have 20 columns to store your data, and all of them are varchar(255).
255 characters can store quite a lot of things. The sentence above is only 112 characters. So,
20columns x 255+1bytes = 5120bytes = 5kB per row.
5MB of space can give 1000 rows, and 500MB will give you 100'000 rows. That's quite a lot to store. In fact, you normally won't fill up as much in each columns, it could easily give you double or triple of that figure.

If you really need to store that much of data, I would actually recommend you to try paid database service, or paid hosting with database. They normally offer few GB of space for a very affordable annual fee.

Btw, I don't think the space used up by the database is shared with your disk space quota. If not mistaken I read it some where, and I saw the MySQL space allocation is diff compare to my disk space quota. That was few months back, I took a look just now(I seldom go to the cPanel), found that it's much diff now, so that rules might not applies anymore.

 

 

 


Comment/Reply (w/o sign-up)

Quatrux
The given 500 MB for this free hosting is also used for the Databases, you can have ~500 MB of information in your SQL databases, as I remember earlier in older CPanel versions, the stats on left menu bar in CPanel showed how much space currently the Database is using, but I just tried to search for it, it doesn't show that anymore, so I guess phpMyAdmin can show it, if you really need to..

Comment/Reply (w/o sign-up)

yordan
What will you do with your database ? Will you really have 500.000 rows in your table ?
I think that if your site really has 500k visitors, you can negociate more space from Xisto without any problem.

Comment/Reply (w/o sign-up)

TavoxPeru
QUOTE(khalilov @ Jul 21 2008, 07:25 AM) *
Iam assuming the information in the databases i will create will be stored in the 500 MB space i get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest present when you add/edit a row in a table.

Also what are the ranges of tinyint,smallint,mediumint and big int

The url given by faulty.lee shows in detail all the data type storage requirements, but if you need it quickly here there are:
  • DATE: 3 bytes.
  • FLOAT: 4 bytes.
  • TINYINT: 1 byte.
  • SMALLINT: 2 bytes.
  • BIGINT: 8 bytes.
  • VARCHAR(x): x+1 bytes, usually 0 to 255 bytes.
  • TEXT: Maximum 64Kb.
Take into account that for the VARCHAR(x) and the TEXT data types this value depends if it is a binary string or a non-binary string -for the first one it represents the declared column lenght in bytes and for the second one in characters- and which character set you will use with them, because some character sets are multi-bytes like UTF-8 (up to three bytes per character) or UCS2 (up to two bytes per character).

BTW, i don't think that you can reach the 500MB limit unless you will use your database to store images or binary data like music or video.

Best regards,

Comment/Reply (w/o sign-up)

khalilov
lol XD

In that case 500 megs will keep me happy for a long time tongue.gif, thx XD

Edit: Is there a limit to how many columns a table can have btw?

Comment/Reply (w/o sign-up)

faulty.lee
A quick search in google return this result -> There is a hard limit of 4096 columns per table, but the effective maximum may be less for a given table.

You can read the detail here -> http://dev.mysql.com/doc/refman/5.0/en/col...ount-limit.html

MySQL is is not a really a hobbyist's toys. It's ready for prime time production environment. So, for normal hobbyist requirement, i guess MySQL is much more than enough for layman like us, tongue.gif hehe

Comment/Reply (w/o sign-up)

yordan
QUOTE(faulty.lee @ Jul 22 2008, 04:29 PM) *
A quick search in google return this result -> There is a hard limit of 4096 columns per table, but the effective maximum may be less for a given table.

The space effectively used depend on the number of rows, not the number of columns in a single row.

Comment/Reply (w/o sign-up)

Jeigh
Yea it's like yordan said, all you can know from the design of a database table is the maximum and minimum size each entry, or table row, can have. For example if you are storing user information and you know the minimum size of each of 5 columns data types is 10 bytes, and the max is 100 bytes, you would effectively know each row is 50-500 byts of data. That said, the number of columns is only limited by the way in which you use the database so it could, in theory, increase to gigantic proportions regardless if there are 1 or 1000 fields in the table.

Comment/Reply (w/o sign-up)

Darasen
The 500 MB offered by Astahost should be more than sufficient. If your database requires more than that chances are that your site is doing well enough to purchase space. If you are even approaching the the column limit on a table the chances are that your data model needs some serious work.

Comment/Reply (w/o sign-up)


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Pages: 1, 2
Similar Topics

Keywords : Needed Database

  1. Connecting To A Remote Database - (10)
    I wondered if anyone here can help. I have a database on a remote server (A). I want to access it
    through a php script on a different server C. I have allowed access on (A) in Cpanel - mysql dbases
    - Remote Access by putting the IP address of server C The host of server (A) has also whitelisted
    the IP of server C. Though I am having trouble connecting from server C which is with a different
    webhost. any ideas how to get round this? I have though of SSH forwarding, but I think this can
    only be used to connect a client - e.g. my pc to the remote server A. I do not ha...
  2. How Can I Import Csv Files To My MySQL Database? - I was able to export but where's import? (7)
    I am having hard times finding that import csv in the mysql phpmyadmin. I once worked on some csv
    files and someone imported it on the mysql server. I was not able to ask him. Does someone know how
    can I import csv files in mysql server?...
  3. MySQL Database Problems - (10)
    My friends have a little forum running here . The problem is that quite often we get the following
    message when we try to open the page: QUOTE Warning: mysql_connect(): Can't connect to
    local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in
    /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 48 Warning: mysql_error(): supplied
    argument is not a valid MySQL-Link resource in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on
    line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
    /home/vhosts/roh...
  4. Accessing Ms Access Database From A Centralized Location? - (11)
    Hi I am a manager at a trading/wholesaling company (and have no programming background). I
    customized the Northwind sample access database to make invoices and keep accounts for my company.
    We now opening another office at a distant location. So, the order entry will be done at two
    points(we plan to use the same Access database). I am not able to figure out how to access the same
    MS Access database from two different location(as LAN can't be used). Moreover, we can't
    afford to pay huge sums to the software developers. Can intranet or uploading the database t...
  5. MS Access Validation Rule - Desperate help needed (7)
    I have to create a whole project using Microfost Access. I have a field which will eventaually
    contain details of a a list of people's DOBs. I have added an input mask, so that it it displays
    the place holder __/__/____ However, how can I validate this field. For example, not it is possible
    to type 30/10/1991 . How can this be changed so that it validates it correctly?...
  6. MySQL Output Database Question - (19)
    I am new to MySql and have just created a database after using a script. My problem is not the
    script, but what it says about putting it into the output file. I cant figure out the right terms
    to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
    'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
    please help me out?...
  7. How To Understand A Database Schema - A very nice and simple tutorial (9)
    Yesterday while i'm seaching for a data model and database schema at the Library of Free Data
    Models for a new project of a friend of mine i found there this nice and simple tutorial on How to
    Understand a Database Schema . As its name says, this tutorial will help you to better understand a
    Database Schema and covers the following basics topics that every Database Schema must define:
    QUOTE Primary and Foreign Keys. One-to-Many and Many-to-Many Relationships. Inheritance.
    "Rabbit's Ears", (Recursive relationships). The Scope of this tutorial is ...
  8. MS-database To MySQL - I'd like to batch them (6)
    Hi, maybe one of you already came across this, so I ask. I'll continue searching on. I've
    got two vocable trainers, one is Windows-native, the other one is on the web. While I can't
    control the output of the Windows-thing (so I can't export them to a *csv or something), I can
    write an import script. But since I'm not that great with Regular Expressions and don't know
    anything about *.mdb (that is MS SQL, isn't it?) files, I would need some finished thing to make
    out the field information and put it in arrays or something more readable. It wou...
  9. Database Access On Remote Server W/jsp - (2)
    Hello: I am new to JAVA and server-side applications and have a dumb question. I have set up
    Tomcat on my machine and created a JSP program to query an Access database using a DSN-Less
    connection. If I publish the page to a webserver and include the .MDB file will it work? I'm
    not sure exactly what needs to be packaged with my Java application to make it work. Since I
    don't have a remote server that supports .jsp I cannot really test it. I'm assuming that
    JDBC driver would be bundled with my site but not sure. Thanks!...
  10. Mirror My MySQL Database To Another Mysql Server - (7)
    Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
    server?or create a small php script to do this? The reason is because, we all know that database is
    very improtant if we have dynamic website. I have my forum hosted and i want to automatically
    mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
    that i forgot to backup my database..also i have one central backup database. Thanks for the
    help..Im looking forward for this posibility....
  11. Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database - (6)
    Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a
    good practice to directly store images and other binary files in a MySQL database. Any one with
    help? Thanks...
  12. Best Database - (16)
    What is the best free database if some one trying built a social networking website? And how to
    operate it with dreamweaver 8?...
  13. Free Or Opensource Database/schema Browser? - Alternatives to TOAD or PL/SQL Developer (6)
  14. Some Useful Database Links. - (7)
    I thought I would take a moment to point the users here to some of the database resources available
    for reference and learning. First I will start with actually designing the database. This site by
    R937 covers the basics of database design. The author is professional database guru and a frequent
    helper at the at DB forums listed below. The Library of Free Data Models is an excellent
    resource for finding data models for projects you may have or as examples of well put together data
    models. With around 500 data models the chances are you find something at least cl...
  15. Mysql Database Entry By Excel Sheets - (2)
    Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
    mysql database. Thanks...
  16. Mysql Database Management - (1)
    Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
    to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
    following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#,
    City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a
    bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. Consider that
    BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20. B2:BOOK2:from ...
  17. Integrate Access Database Onto Intranet Site - Looking to integrate access database into my intranet site (5)
    Hey guys, im new here and am looking for answers /tongue.gif" style="vertical-align:middle"
    emoid=":P" border="0" alt="tongue.gif" /> Firstly, i have designed a database using M$ access, it
    consists of multiple forms which i plan to host on an intranet website, i need to be able to add
    records directly from the form on the intranet website aswell as being able to edit/review current
    entries on forms in the database. My question is, how would i go about integrating these forms onto
    the intranet website? i plan on keeping the database and the intranet site on the same d...
  18. Database - prblem with it (1)
    i have free script but it is working fine on a lot of sites i tried to use it to my web site ....i
    edit its config.php right and but my database name and my user name and password every thing right
    and when i try to install it it gives me this error can`t connect to database please choose file
    from this mobile.sql can any body help plz coz i tried huderd of times and no thing happend...
  19. Permission Problem With Mysql Database Creation - Please Help! (8)
    I seem to have a problem with accessing my database with proper permissions. I have set the my
    database correctly giving my db username all priviliges yet i seem to be unable to even log on with
    this username with a denied access error. Any ideas on resolving this?...
  20. Need Help In Database Auto_increment - (9)
    i am creating a game and i set when someone registers than he gets id...in "extra" i have set it to
    be "auto_increment" but whenever new player signs up he gets number bigger than 210...(my first id
    was 211,next was 212,third was 213,fourth got 214) how to set it to go from 1 to infinite? thnx...
  21. Embedded Database - Embedded Data base at client side, (7)
    Hi, Now its the era of Embedded databases, no more db servers, no more host,Because with embedded
    db you can get all those options, what you are used to get with DB Servers. Some of Embedded DB Are
    1) Cloudscape From IBM (NOW Derby from ASF) 2) HSQLDB (OpenSource) and many more Feel the power of
    EDB Cheers Arunkumar.H.G...
  22. Need Advice On Creating Online Music Database - ps - dont know anything about databases! (6)
    I need to create a database of around 1000 music albums that I can put on my site, with the ability
    to search the database according to several different criteria. Being a complete and total NOOB to
    the world of databases, can anyone point me in the direction of some software that will let me
    create a good-looking and functional database, but that isn't too complicated for me to use?!
    Sounds like a tall order I know, be grateful if anyone can help though. Thanks!
    Notice from microscopic^earthling: Topic edited to reflect content...
  23. The Best Database - What do you think is the best database? (48)
    Ive been planning to create a online application which requires tons of stuff from database. Ive
    been using interbase, at first it was good but after a month i find it not user friendly at all...
    Its to hard to code in php.. Can any of you guys give me a good database which is easy to use?...
  24. phpBB Database Transfer - Anyone here knows how to? (10)
    Hello, i'm a newbie in using phpBB and I still lack knowledge in mySQL database. How do I
    transfer the datas(users,configs, all of them) contained in my current forum to another one in
    phpBB? I hope someone can help, a short but detailed tutorial would be good. Example is, if I want
    to move to a new host and I want to transfer all the accounts on my old forum to the new one. Thanks
    in advance, hope anyone here knows how to....
  25. My Sql Database Help? - (3)
    Ok, i am new at web design, i dont know too much about it... I was working on a website for about
    a month this is what i got, My Web , like i said, i dont know much.. i used FrontPage and did all
    of that, my current host is AFMU which uses MySQL, but the way it is set up I dont know how to
    acquire the URL of the database or any information i dont know what it means at all.. i just want to
    do a simple login feature, i mean this is my first website and i am learning so I think it would be
    a great feature to add in and learn. i can create data bases from there but do n...
  26. Database Size? - So how big is everybody's MySQL database? (10)
    Well I know that MySQL databases can get rather big, so I was just wondering how big everybodies
    databases were? Do you have really big ones, or are they relatively small? Also what do you store in
    them? (just text, or binary data as well)...
  27. How Many Concurrent Users For Oracle Database? - This is to analyse and get perfect result for How many concurrent use (1)
    Hi friends, How many concurrent users can practically access the oracle database?
    they say tht the figure is hundreds of thousands users...is there any exact figure? or does the
    number of concurrent users depend on any other factors as wel? I think depend on parameter
    1.session 2.processes session Specific connection of a user to an Oracle instance through a user
    process. A session lasts from the time the user connects until the time the user disconnects or
    exits the database application. Multiple sessions can be created and exist concurrently for ...
  28. Database Programming In Vba 6.0 - (1)
    hi , i need some sample program in database.thanks...
  29. Need Info On Database Programming Courses - Oracle Database Programming (2)
    I know Database Programming on MS-ACCESS, now i am planning to go for some other Database
    Programming courses, People told me to go for Oracle or VisualAge. Can anyone told me to start with
    which one and how long is the course period and which one is easy and is it similar to ms access or
    somthig different....
  30. Coders Wanted - Any one with php,mysql,c++ & javascript experiance come (not all n (7)
    I am mainly looking for someone who has experiance in Php, Html & Mysql but if you are experianced
    in C++ & javascript that would be a great help: i am currently working on a game called Medi-Evil
    Quest this is a 3d morpg and hopefully will become a mmorpg but to do so i will need more than just
    4 coders i beileve i would only need another 6 coders tops so if you are experianced in coding and
    want to get involved in this project either email me on Nuzv355g@aol.com or add me on msn at
    jarvis_3@hotmail.com, note i am only 15 but i have alot of experiance and i allready ha...



Looking for space, needed, database


Connecting
To A Remote
Database
How Can I
Import Csv
Files To My
MySQL
Database? I
was able to
export but
where's
import?
MySQL
Database
Problems
Accessing Ms
Access
Database
From A
Centralized
Location?
MS Access
Validation
Rule
Desperate
help needed
MySQL Output
Database
Question
How To
Understand A
Database
Schema A
very nice
and simple
tutorial
MS-database
To MySQL
I'd like
to batch
them
Database
Access On
Remote
Server W/jsp
Mirror My
MySQL
Database To
Another
Mysql Server
Is It A Good
Practice To
Store Image
Or Other
Binary Files
Directly In
A Mysql
Database
Best
Database
Free Or
Opensource
Database/sch
ema Browser?
Alternatives
to TOAD or
PL/SQL
Developer
Some Useful
Database
Links.
Mysql
Database
Entry By
Excel Sheets
Mysql
Database
Management
Integrate
Access
Database
Onto
Intranet
Site Looking
to integrate
access
database
into my
intranet
site
Database
prblem with
it
Permission
Problem With
Mysql
Database
Creation
Please
Help!
Need Help In
Database
Auto_increme
nt
Embedded
Database
Embedded
Data base
at client
side,
Need Advice
On Creating
Online Music
Database ps
- dont know
anything
about
databases
3;
The Best
Database
What do you
think is the
best
database?
phpBB
Database
Transfer
Anyone here
knows how
to?
My Sql
Database
Help?
Database
Size? So how
big is
everybody
9;s MySQL
database?
How Many
Concurrent
Users For
Oracle
Database?
This is to
analyse and
get perfect
result for
How many
concurrent
use
Database
Programming
In Vba 6.0
Need Info On
Database
Programming
Courses
Oracle
Database
Programming
Coders
Wanted Any
one with
php,mysql,c+
+ &
javascript
experiance
come (not
all n

See Also,

*SIMILAR VIDEOS*
Searching Video's for space, needed, database
advertisement




Space Needed For Database

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com



Creative Commons License