Mutlu
Nov 30 2006, 10:11 AM
| | I'm sorry about this topic. I'm a new user and my english is not very good. I want to learn the max capacity of mysql db. |
Comment/Reply (w/o sign-up)
yordan
Nov 30 2006, 10:45 AM
There is no real limit to a database capacity. I have created Oracle databases with several tens of terabytes, no problem. The only real limitation is the physical disk storage you have. Then, there are some small differences due to small implementation differences from one database manager to another one, or some bugs in one manager and not on another one. I know people having really huge databases work with Oracle, they are afraid working with mysql or postgres.
Comment/Reply (w/o sign-up)
Innila
Nov 30 2006, 12:11 PM
Hi Mutlu, why are sorry for ur topic, actually this is a common query people have. So nothing wrong in it. There is no particular limit set for Data storage. The database capacity depends on the physical disk storage. So depending on ur hard disk capacity, ur DB storage may vary. I think u wont use such a huge volume of Data so that ur out of memory. Another thing Mutlu, dont worry abt ur English knowledge, ur regular posting in Astahost may help ur Writing skill. Cheer up dude!!!
Comment/Reply (w/o sign-up)
yordan
Nov 30 2006, 01:49 PM
QUOTE dont worry abt ur English knowledge, ur regular posting in Astahost may help ur Writing skill. But you should not use this kind of working. Reading words like "ur" helps nobody learn English. 
Comment/Reply (w/o sign-up)
Melanova
Dec 1 2006, 12:28 AM
So does the mysql db count against our total space?
Comment/Reply (w/o sign-up)
Houdini
Dec 1 2006, 02:40 AM
Yes it does but read below...it is not a real concern. The content will be you main concern. A properly maintained MySQL Database can be rather small, depending on what you are storing with any database unless you are a massive company with millions of entries you should not have to really worry about the size of your MySQL Database. If for example you use a forum like this one then you will be just fine with the limitations of the disk space offered. As fields are tokenized and fit into a set framework with any database management system. For all intents and purposes you should be just fine with 150 meg offered or even the initial start package. Most forum software and also CMS (Content Management Systems) available will offer pruning of messages posted to your site on a basis that you control. Duplicate messages and stuff like that are usually not allowed with good software and keep data storage to just that data that is not also repeated. You do need to keep in mind that data stored either in files or in a database management system (DBMS) will take up space but as stated above a good system like MySQL wil be just fine for your stuff unless you start actually putting BLOB (binary large object) instead of a link to that data (binary like movies or music) which also take up space. All said, you should not even worry about the database, it will take care of itself and just do those things that make you site one that has people attracted to it.
Comment/Reply (w/o sign-up)
unimatrix
Dec 1 2006, 07:08 AM
The limit of a MySQL database depends on the size of your wallet. How much storage and horsepower can you afford? That being said, there does come a point where MySQL begins to degrade in performance. But that number is far larger than any database I've ever deployed.
Comment/Reply (w/o sign-up)
yordan
Dec 1 2006, 10:19 AM
@Mutlu : now you have to give us an info. I think each one of us had a different understanding of your question. I understood that you wanted to know what the biggest possible database we could imagine. The answer is : "almost no limit". Maybe I am wrong ? Maybe your question was precisely on astahost, asking how big could be the amount of database storage you are allowed on your free astahost account ? Then the answer is : "rather small, but you can mage to survive with it".
Comment/Reply (w/o sign-up)
kubeed
Dec 2 2006, 02:08 PM
as i see my brothers in forum has said to you has discussion to you on the system oracle you have asked about my sql data base but it not limited always on calculate the space you have install the mysql on it
Comment/Reply (w/o sign-up)
BuffaloHELP
Dec 3 2006, 08:08 AM
QUOTE(Melanova @ Nov 30 2006, 07:28 PM) 
So does the mysql db count against our total space?
No, the size of your database does not count towards your hosting disk space. Basically, think of database as free hosting place for your data files that is an extra add-on to your hosting pace. Therefore you can create how large or how many database you'd like as long as you are well within AstaHost Free Web Hosting, No Ads AUP and TOS. Not bad for free hosting place, huh? 
Comment/Reply (w/o sign-up)
yordan
Dec 3 2006, 11:09 PM
QUOTE(borlafu @ Dec 4 2006, 12:03 AM)
Are you sure? I think the size of the databese is added to your disk usage. At least it sould for security reasons...
If you look at your cpanel General account information, you will see the exhausted part of your quotas. You will see someting like : QUOTE
Disk usage 64.29 / 150.00 MB
SQL Disk usage 1.59 MB
Disk space available 85.71 MB
So, it seems that today the SQL disk usage is a courtesy of astahost, they kindly take it apart from our general disk usage. So, we should not abuse, else they will change their mind!
Comment/Reply (w/o sign-up)
Similar Topics
Keywords : maximum, capacity, astahost, mysql, database
- Login System
I want to make a login system using Mysql. I am amateur in these thing (12)
Free Or Opensource Database/schema Browser?
Alternatives to TOAD or PL/SQL Developer (6) I was wondering if there were any alternatives to TOAD or PL/SQL Developer that allows you to browse
through a database(s), the different schema objects, and perhaps the stored
procedure/function/packakge editors. One thing I have tried is to the use the Data Tool Plugins set
for my Eclipse but that brings my machine's performance to crawl. One a further note, I am
basically looking for Windows environment, with connections to remoate databases.....
Mysql Overhead
(3) Sometimes in a table especially if i do alot of things in it i start seeing overhead then a size
near it? what is overhead? and is it essential to optimize the table to fix it? I know its just a
press of a button but i'd like to know what happens when i optimize a table. Also when you make
a new table you can limit the size of VARCHAR to a number, that number would be the number
characters allowed in that column per entry. I'd like to know how the limit works for texts, is
it in KB? or number of characters? Cuz i made a messaging system. And i remember reading s....
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 ....
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?....
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....
Mysql Multiple Tables
(3) It is good practice to use multiple tables to sort out big amounts of data. But once you do that it
becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command
structure that they have added. You can select multiple tables within one sql query. Example of a
basic sql query CODE $sql = "SELECT * FROM table WHERE row=1"; If you noticed that I selected
all of the rows in the table. Normally you will try to not select the entire table from the database
unless you absolutely want all of the table. I would recommend against it; just gra....
Any Website Provide Free Host Mysql Host?
(4) any website provide free host mysql host? i need it because i am using 000webhost.com now but it
only provide 2 mysql database... can i know where or how can i get more databases regards....
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!....
Space Needed For Database
(10) 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....
Mysql On Computer
XD (9) I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if
there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i
want and upload it when i get hosted =)....
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....
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 ....
Accessing Ms Access Database From A Centralized Location?
(10) 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....
Login System Using A Mysql Db
How do i do this? (5) Hi guys, ive got a registration system that looks something like the one below: Firstname:
Lastname: Then i have inset.php, which looks like the following: $con =
mysql_connect("localhost","autobot","abc123"); if (!$con) { die('Could not connect: ' .
mysql_error()); }mysql_select_db("my_db", $con);$sql="INSERT INTO person (username, password) VALUES
('$_POST ','$_POST ')";if (!mysql_query($sql,$con)) { die('Error: ' .
mysql_error()); } echo "1 record added";mysql_close($con) ?> Now my question is, how do i creat....
Mysql And Php
When trying to install Joomla (16) I don't know if this is the correct forum, but here is my question: I'm trying to test
Joomla and some forums in my computer, I have already installed MySQL with the GUI tools, Apache,
and PHP with the MySQL and MySQLi extensions, but when I'm trying to install Joomla I get this
error: Required Settings Check: ------------------------------------- PHP version >= 4.1.0
Yes - zlib compression support Available - XML support Available - MySQL support
Unavailable configuration.php Writeable Session save path Unwriteable Not ....
Navcat For MySQL
is Navcat any good? (9) Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
played around with the demo. Has any one used it beore, if so please let me know if its worth
buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
and functionality. Regards....
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....
MySQL, Multiple Tables
(27) Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always
learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there
needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two
together? I could probably figure this out faster if someone explained and posted sample SQL code
that shows how the two are linked together. Thanks!! F....
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?....
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....
What Are The Alternatives To MySQL
(7) Hi. i'm interested in alternatives to MySql combined with php. what database else can i use to
create a webbased managment system with a lot of entries. maybe more than mysql can handle fast
enough. it should be more powerful than mysql and should have nearly the same features. i hope
there is a webbased administration program like phpmysqladmin thanks for your help ! greetings c.....
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.....
Recover Tables From A MySQL .frm File
(9) I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
innodb....
MySQL Database Problems
(8) 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....
Error In Installing MySQL Server
MySQL server cannot be started (9) I try to upgrade my MySQL server from 4.018 to 4.1.10a. Firstly, I downloaded mysql-4.1.10a (not the
essential one) for win XP Then I install the new version after the old version was uninstalled.
After the installation process, Instance Configurator comes up to help for the configuration. But an
error occured when it try to start the MySQL service. Error messageis "cannot create windows
service for MySQL. Error:0" So my MySQL server cannot be started. It is running win XP on my
computer. Does anybody can tell me what is wrong?. Thanks (sorry for my bad english)....
How Can I Import Csv Files To My MySQL Database?
I was able to export but where's import? (3) 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?....
MySQL Datetime --> VB.NET Datetime Conversion Prob
Any solutions ?? (4) Hi, Can anyone provide me with a quick example of fetching a MySQL Datetime Field and converting it
into native VB.NET DateTime format ?? Say for example my db contains a couple of fields: Field1,
Field2, DateField... one of which is the default MySQL DateTime. Say I'm using the following
code to connect... CODE ConnectionString = "....." QueryString = "SELECT * FROM SomeTable" Dim
myConnection As New MySql.Data.MySqlClient.MySqlConnection(ConnectionString) Dim myCommand As New
MySql.Data.MySqlClient.MySqlCommand(QueryString, myConnection) Dim myReader As MySq....
MySQL Realtime Replication
how to replicate mysql in realtime (4) i dont know if this might be useful to ppl here, but this is a very good knowledge for serious
siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to
do realtime replication. the idea is that there are master server and slave server. both are having
the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!)
you'll never have to manually copy the database file of wasting your time to manually use the
mysqldump command. here are the links; http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.h....
MySQL - Trouble With Bulk Insert Statements
(3) I'm trying to insert about 500 rows into mysql, but I keep getting errors. If I copy and paste
too many (about 50) insert statements at a time I get errors sometimes. I sometimes even get errors
but then the row is skipped so I don't know there was an error (I'm using linux and SSH).
What's the best way to get my insert statements to put the data in MySQL? Is there anyway that I
can have it tell me if there where any errors all the statements are executed? Thanks for your
help.....
Looking for maximum, capacity, astahost, mysql, database
|
See Also,
*SIMILAR VIDEOS*
Searching Video's for maximum, capacity, astahost, mysql, database
|
advertisement
|
|
