SEO

#1 (**permalink**) 02-28-2008, 05:38 AM

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

#2 (**permalink**) 02-28-2008, 05:39 AM

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@teri.res.in>
To: <sujayk@andale.com>
Cc: <praj@yahoo-inc.com>; <kharajge@sify.com>; <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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode