-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Alan Brown wrote:
| On Mon, 18 Aug 2008, Ryan Novosielski wrote:
|
|> The problem is, dbcheck never seems to finish. I'm not sure if it ever
|> will, but it cannot be completed in the nearly 72 hours on the weekend
|> that I can allow it to run before it starts to impact production
|> backups. Here is what it's doing:
|
| The first time I ran dbcheck (without all indexes on the file table) it
| took the best part of 4 days to run and found 11+ million orphan entries

Is there any way to tell if it's actually making any progress? I guess
probably not.

This looks wrong to me:

mysql> show index from File;
+-------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name       | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| File  |          0 | PRIMARY        |            1 | FileId      | A
~       |     3579983 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId          |            1 | JobId       | A
~       |         130 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId          |            2 | PathId      | A
~       |      275383 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId          |            3 | FilenameId  | A
~       |     3579983 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | file_jobid_idx |            1 | JobId       | A
~       |         130 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | file_jpf_idx   |            1 | JobId       | A
~       |         130 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | file_jpf_idx   |            2 | FilenameId  | A
~       |     1789991 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | file_jpf_idx   |            3 | PathId      | A
~       |     3579983 |     NULL | NULL   |      | BTREE      |         |
+-------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
8 rows in set (0.00 sec)

It looks like I ended up with 3 indexes on the JobId, 2 for PathId and 2
for FilenameId, but maybe there is something that makes them different
that I don't realize? I'm not very good with this part of MySQL. Since
it's not clear to me if Key_name is arbitrary or means something (and
none of the documentation really says), I wasn't sure if a different
name there alone meant something.

| have you tweaked your my.cnf to ensure you're not using the default mysql
| limits which are designed for a 64Mb multiuser machine?

Ah! No, I have not -- this may in fact be my problem. I'll take a look
and see what ground can be gained in that area.

Let me know what you can about the above stuff, and thank you very much
for responding!

- --
~ ---- _  _ _  _ ___  _  _  _
~ |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer II
~ |$&| |__| |  | |__/ | \| _| |novosirj AT umdnj DOT edu - 973/972.0922 (2-0922)
~ \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIqY5Rmb+gadEcsb4RAk/oAKCDoa4WwE1Yt0z2vhiFYMMxzUS7WQCdG/eF
1zpoWedyruzb69HaUraoyEQ=
=vN+3
-----END PGP SIGNATURE-----

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users