On Thu, Dec 06, 2001 at 03:21:55AM -0800, Michael Turley wrote:
> We are concerned that around 43500 records seem to
> take up about 15M of disk space. We envisage that the
> number of records will potentially reach 10 million
> records (if not 10s of millions) which would
> (according to simple maths) mean that the Linux 2G
> file size limit would be broken.
Use a version of the linux kernel (and the associated tools)
without the 2GB limitation?
Use a *BSD - they don't regard 2GB as anything special...
> Has anyone had any problems trying to scale MySQL to
> something this large? Apart from suggesting a
> different database or advice on database design would
> anyone like to share some relevant tips?
I think you'd get more responses on the MySQL list. :-)
Is your schema appropriately normalised?
What does the as_alert table look like?
(mysqldump -d database as_alert)
Wesley.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
