Hi,
One RAL RB got hit again by the MySQL database size and needs maintenance, but I'd like to know other opinions vis-à-vis this issue. There are several URLs pointing to this issue of "...4GB database file size..."
So is it about the size of the whole /var/lib/mysql/lbserver20 directory or about the size of the largest file there (usually long_fields.MYD)?
The long_fields.MYD size is usually ~40% of the whole lbserver20 directory size (at any time) so it does make a difference whether to consider 4GB for the whole lbserver20 directory (and long_fields.MYD ~1.8GB) or for the long_fields.MYD (and lbserver20 ~9GB)
I personally considered the 4GB limit for long_fields.MYD
Cheers,
Catalin
|