On Thu, 6 Jan 2005, Torsten Harenberg wrote:
> Dear all,
>
> a happy new year to you all!
>
> After a hint from Genevieve Romier, I realized that the MySQL database of
> our RB got really large:
>
> [root@grid-rb lbserver20]# pwd
> /var/lib/mysql/lbserver20
> [root@grid-rb lbserver20]# du -sh .
> 9.4G .
>
> I couldn't make a "select * from events;" - mysql died allthough that
> machine has 1GB of ram.
>
> But to have some numbers:
>
> mysql> select count(*) from events;
> +----------+
> | count(*) |
> +----------+
> | 7130631 |
> +----------+
> 1 row in set (0.00 sec)
>
> mysql> select count(*) from short_fields;
> +----------+
> | count(*) |
> +----------+
> | 40715553 |
> +----------+
> 1 row in set (0.00 sec)
>
> What it the proposed way to proceed on this? Is this normal?
David Smith has had to deal with the same problem on the testzone RB
lxn1188.cern.ch; I suppose he will be able to respond tomorrow.
It was already on our to-do list to significantly enlarge the default
limitations on various tables and to define the necessary indexes.
|