Olaf,
That's a very broad question depending upon your exact requirements
to be honest. So long as you've considered file size limitations and
you've opted for a decent RAID system there's not too much more to worry
about, try and buy the fastest disks possible obviously i.e. 15,000 RPM
one
Olaf,
Thanks for the detailed answer.
So basically the limitations come from the OS and the file system used.
What is the best file system to use for mysql (not considering the filesize
limitations)?
Thanks
Olaf
The "best" is probably ZFS if you really are intent on make things huge,
http:/
samchk -dv tbl_name. If your large table is read-only,
> you can use myisampack to compress it. myisampack usually compresses a table
> by at least 50%, so you can have, in effect, much bigger tables.
>
> Thanks
>
> Visolve DB Team
>
> - Original Message -----
> Fr
. myisampack usually compresses a table by at
least 50%, so you can have, in effect, much bigger tables.
Thanks
Visolve DB Team
- Original Message -
From: "Olaf Stein" <[EMAIL PROTECTED]>
To:
Sent: Friday, December 29, 2006 4:14 AM
Subject: Max size and row numbers
Hey everyone
I have more of a general question regarding your experience with large
tables.
I currently have a table (MyISAM, 6 columns, lots of reading access, some
writing) with about 70.000.000 records, using 2.5GB of diskspace. I am
running MySQL 5.0.* on a RedHat Enterprise AS 4 system (2 CP