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