Isn't the limit of 4G imposed at instalation/configuration time?
Is there a way to let /var/lib/mysql/lbserver20/ grow to infinity, as
you say? How do you define it?
Cheers
Goncalo
Maarten Litmaath wrote:
> On Wed, 28 Nov 2007, Condurache, C (Catalin) wrote:
>
>
>> On a lcg-RB system every time when the lbserver20 database (MyISAM
>> format) gets nearly 4GB (in fact long_fields.MYD file), I am physically
>> moving the database in /var/lib/mysql/lbserver20 (for archiving
>> purposes) and recreating a new schema.
>>
>
> Why not let the DB grow indefinitely? We do that with our RBs.
> For example:
>
> [root@rb114 root]# ls -lh /var/lib/mysql/lbserver20/ | grep MYD
> -rw-rw---- 1 mysql c3 0 Dec 19 2006 acls.MYD
> -rw-rw---- 1 mysql c3 4.3G Nov 29 22:17 events.MYD
> -rw-rw---- 1 mysql c3 254M Nov 29 22:17 jobs.MYD
> -rw-rw---- 1 mysql c3 51G Nov 29 22:17 long_fields.MYD
> -rw-rw---- 1 mysql c3 0 Dec 19 2006 server_state.MYD
> -rw-rw---- 1 mysql c3 14G Nov 29 22:17 short_fields.MYD
> -rw-rw---- 1 mysql c3 18G Nov 29 22:17 states.MYD
> -rw-rw---- 1 mysql c3 0 Dec 19 2006 status_tags.MYD
> -rw-rw---- 1 mysql c3 13K Nov 23 20:28 users.MYD
>
|