On Fri, Jun 29, 2007 at 01:39:00PM +0200, LEROY Christine wrote:
> Hello Maarten,
>
> Could you forward links to such recipes (LCG or mysql recipes?)?
> Thanks in advance
> Christine
In order to remove the limitation, you have to login to your RB MySQL
database and run the following 'alter table' commands:
ALTER TABLE short_fields MAX_ROWS=1000000000;
ALTER TABLE long_fields MAX_ROWS=55000000;
ALTER TABLE states MAX_ROWS=9500000;
ALTER TABLE events MAX_ROWS=175000000;
The above commands will take a lot of time and during this time writes and
updates to these tables will not be allowed by MySQL.
I am not sure what Maarten means by 'prevent'.
>
>
>
> -----Message d'origine-----
> De : LHC Computer Grid - Rollout [mailto:[log in to unmask]] De la part de Maarten Litmaath, CERN
> Envoyé : mercredi 27 juin 2007 20:37
> À : [log in to unmask]
> Objet : Re: [LCG-ROLLOUT] 4GB issue on lcg-RB database
>
> On Wed, 27 Jun 2007, Condurache, C (Catalin) wrote:
>
> > 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
>
> The 4 GB is per table. The long_fields table is the first to reach it.
> The recipes show how to remove or (better) prevent that limitation.
--
Kyriakos Ginis
Software Engineering Laboratory
National Technical University of Athens
|