 |
 |
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? It seems that this affects the EGEE - QA measurement tools, which started to have problems collecting data. Thanks a lot and best regards, Torsten <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> <> <> <> Torsten Harenberg [log in to unmask] <> <> Bergische Universitaet <> <> FB C - Physik Tel.: +49 (0)202 439-3521 <> <> Gaussstr. 20 Fax : +49 (0)202 439-2811 <> <> 42097 Wuppertal <> <> <> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>