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