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" <ramank@stripped>
To: <sujayk@stripped>
Cc: <praj@stripped>; <kharajge@stripped>; <mysql@stripped>
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
