Hi,
1) In MySQL, the size of the table limits to the storage engine and the file
system size. [minimum -default -2GB]
2) As of our understanding, keeping in multiple tables is a good practice,
that too with perfect normalization. If multiple tables, table sizes are in
hand, limit of file system. File volume size is a notable parameter when
moving for multiple tables.
3) Regular backups. Enable log-bin; in case of recovery, use mysqlbinlog.
Thanks
ViSolve DB Team
----- Original Message -----
From: "Raman Kheterpal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
Sent: Monday, January 22, 2007 2:46 PM
Subject: Query about MySQL
Hi All
I got your mail id from one of the forums.
can u plz tell me tht wht is the capacity of storage of MySQL DB. acutally
we are in the process of making a project on LAMP technology, but the
databse is too large..say 17220000 records....
this much of records will remain in one table only... Can you please tell
me .
- Is mysql is able to manage this huge amount of data.
- Can we put this much of data in single table database OR keeping the
data in multiple tables is the good practice.
- What precautions I have to taking while managing this much of data in
MySQL....etc etc
kindly see the matter n reply me in this regards
Thanx in advance
raman
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
