 |
 |
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 >