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
|