0
It all depends on the type of MySQL database you wish to use and also the operating system the server has. Most of the restraints are due to the max file size the operating system can store. The limits are done by table size rather than the database size as a whole.
- Win 32 w/ FAT/FAT32 - 2GB/4GB
- Win 32 w/ NTFS - 2TB (possibly larger)
- Linux 2.2-Intel 32-bit - 2GB (LFS: 4GB)
- Linux 2.4+ - (using ext3 file system) 4TB
- Solaris 9/10 - 16TB
- MacOS X w/ HFS+ - 2TB
- NetWare w/NSS file system - 8TB
InnoDB tables are often split up into multiple files to allow larger tables, this is known as a tablespace. The maximum table space is 64TB.
MyISAM tables default size is at 4GB, but this can be changed to a maximum of 65,536TB.
Wiki User
∙ 13y ago
Wiki User
∙ 14y agoIt all depends on what type of MySQL database you are using, and what operating system you are using.
Depending on what you are using it could be Gigabytes, Terabytes or even Petabytes in size. Either way for the average user your probably not going to run out of space unless your working on a huge project with billions of rows of information.
Add your answer:
Earn +20 pts
What is a default storage of mySql database?
MyISAM was the default storage engine for MySQL 5.1 and prior versions. From MySQL 5.5 InnoDB has become the default storage engine.
How do you create a new database in MySQL?
The MySQL command is "CREATE DATABASE [dbname]" with "[dbname]" replaced with your desired database name.
What type of database is used in Friendster?
MYSQL database
How do you convert an Excel database to a Mysql database?
1. For every sheet you have in Excel, create a matching table in MySQL database 2. Export excel data to a CSV file 3. Load the CSV files into MySQL database using one of the following: 3.1 mysqlimport - Loads tables from text files in various formats 3.2 LOAD DATA INFILE command 3.3 Create the tables with CSV storage engine, replace the CSV file in the database directory
What is MyISAM in MySQL?
MyISAM is the default table engine in the MySQL database.
What database does the WAMP server refer to when it?
WAMP stands for Windows Apache Mysql PHP. Mysql is the default database in WAMP
What is wikipedia's database website?
Wikipedia uses MySQL as its database.
How do you copy a database of mysql in wamp server from one computer to another?
You have several options: * copy the database files from mysql/data/<database_name> to a new mysql Installation * use mysqldump utility to export the data from your database and load it into the new mysql installation * setup replication
What company is the developer of the MySQL database?
The developer of the MySQL database software was MySQL AB, which was bought by Sun 2008 for one billion dollars. Oracle then acquire sun and hence MySQL and is currently responsible for the continuing development.
How do you put today's date into MySQL database?
Use: $todaysdate = date("d/m/y"); And then just send that to the MySQL database
What are four database programs?
Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.
Why did Google change their database from Oracle to MySQL?
Google don't use Oracle or MySQL, they use their own database software known as Bigtable.
