myInterview.co

we have good collection of interview questions with answers


What is maximum size of a database in MySQL?


sql database interview questions and answers

common interview question for fresher and experiences.prepare your job interview with us. get your dream job.most frequently asked interview questions.best interview questions. sql database for interview questions and answers for fresher and experience. improve interview skills.improve interview confidence.sql database best interview questions. start your sql database job interview right now and get your dream jobs. preparation job interview any place and any time.also our android application available here.





Note: any question and answer correct or incorrect give you vote. also you know correct answer then you can post your answer or give vote in answer.

my favorites

add to favorite


What is maximum size of a database in MySQL?

If the operating system or filesystem places a limit on the number of files in a directory, MySQL is bound by that constraint.The efficiency of the operating system in handling large numbers of files in a directory can place a practical limit on the number of tables in a database. If the time required to open a file in the directory increases significantly as the number of files increases, database performance can be adversely affected.
The amount of available disk space limits the number of tables. MySQL 3.22 had a 4GB (4 gigabyte) limit on table size. With the MyISAM storage engine in MySQL 3.23, the maximum table size was increased to 65536 terabytes (2567 – 1 bytes). With this larger allowed table size, the maximum effective table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits.The InnoDB storage engine maintains InnoDB tables within a tablespace that can be created from several files. This allows a table to exceed the maximum individual file size. The tablespace can include raw disk partitions, which allows extremely large tables. The maximum tablespace size is 64TB.
The following table lists some examples of operating system file-size limits. This is only a rough guide and is not intended to be definitive. For the most up-to-date information, be sure to check the documentation specific to your operating system.Operating System File-size 
LimitLinux 2.2-Intel 32-bit 2GB (LFS: 4GB) 
Linux 2.4+ (using ext3 filesystem) 4TB 
Solaris 9/10 16TB
NetWare w/NSS filesystem 8TB
Win32 w/ FAT/FAT32 2GB/4GB
Win32 w/ NTFS 2TB (possibly larger)
MacOS X w/ HFS+ 2TB

best mysql interview question.
jayvik 0 0


More Answer

Post your Answer



sql database popular interview questions and answers


favorite 0
votes 0
answers 1
views 582

favorite 0
votes 0
answers 0
views 525

favorite 0
votes 0
answers 0
views 435

favorite 0
votes 0
answers 1
views 413

favorite 0
votes 0
answers 0
views 388
sql database 2013-07-05 07:06:31 sql database

favorite 0
votes 0
answers 0
views 383
sql database 2013-04-30 17:45:23 sql database

favorite 0
votes 0
answers 0
views 359
sql database 2013-05-04 11:18:22 sql database

favorite 0
votes 0
answers 0
views 349

favorite 0
votes 0
answers 0
views 337

favorite 0
votes 0
answers 0
views 330

favorite 0
votes 0
answers 0
views 321

favorite 0
votes 0
answers 6
views 307

favorite 0
votes 0
answers 0
views 299

favorite 0
votes 0
answers 0
views 294

favorite 0
votes 0
answers 0
views 283


favorite 0
votes 0
answers 0
views 281

favorite 0
votes 0
answers 0
views 275

favorite 0
votes 0
answers 0
views 275
sql database 2013-05-04 11:17:13 sql database

favorite 0
votes 0
answers 1
views 274


sql database best Interview Questions have been designed especially to get you acquainted with the nature of questions you may encounter during your interview for the subject of sql database Programming Language. here some questions that helpful for your interview.

Like Our fb page touch with us.