Hi Martin,
Thank you for your tips,
here are the result of the sql commands:
mysql> select count(*) from File where jobid=16435;
+----------+
| count(*) |
+----------+
| 2828311 |
+----------+
1 row in set (32.97 sec)
mysql> select count(*) from File where jobid=16435 and not filenameid=(select filenameid from Filename where name='');
+----------+
| count(*) |
+----------+
| 2679647 |
+----------+
1 row in set (18.54 sec)
I tried do do a dump and restore but i keep getting an error that MySql could not find the tables to drop when i was trying to restore the dump?
I am presently running the restore. .
this is the top from the bacula server
last pid: 5749; load averages: 0.14, 0.03,
0.01 15:12:09
54 processes: 53 sleeping, 1 on cpu
CPU states: 90.7% idle, 7.2% user, 2.1% kernel, 0.0% iowait, 0.0% swap
Memory: 4096M real, 3404M free, 213M swap in use, 4951M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
669 root 4 59 0 18M 14M sleep 123:00 7.35% bacula-dir
5696 alarose 1 59 0 3176K 2376K cpu/0 0:04 0.05% top
this is the top from mysql server
last pid: 16156; load averages: 0.22, 0.10,
0.15 15:12:49
48 processes: 46 sleeping, 1 zombie, 1 on cpu
CPU states: 98.0% idle, 1.0% user, 1.0% kernel, 0.0% iowait, 0.0% swap
Memory: 2048M real, 908M free, 1360M swap in use, 2062M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
16145 mysql 10 59 0 1084M 235M sleep 0:30 8.05% mysqld
16154 root 1 59 0 3168K 2392K cpu/0 0:02 0.10% top
as you can see both servers are not very busy.
I will post the result of choosing * once the restore is done.
many thanks
Friday, November 14, 2008 4:48 PM
From:
"Martin Simmons"
<martin AT lispworks DOT com>
To:
bacula-users AT lists.sourceforge DOT net
It would be useful to run these
two sql commands to see what is in the
catalog:
select count(*) from file where jobid=16435;
select count(*) from file where jobid=16435 and not filenameid=(select
filenameid from filename where name='');
Also, what happens if you do 'mark *' at the restore prompt? It should
print
the number of files actually marked, which might be different from the number
it claims were inserted.
I don't think the director limits the memory itself, so it will grow up to
whatever size the OS allows. Try running top while building the tree and
see
what size it says for bacula-dir.
__Martin
>>>>> On Fri, 14 Nov 2008 08:50:21 -0800 (PST), Louis-Andre
Larose said:
>
> Hi,
>
|
