Technik wrote:

> My queries for the ninth and tenth option of dbcheck are diffrent.
> eliminate_orphaned_path_records
> eliminate_orphaned_filename_records

By "orphaned filename records" I have no claims.

bacula 2.2.8

Now sql queries that will never finished :

8) Check for orphaned File records
EXPLAIN SELECT File.FileId, Job.JobId FROM File LEFT OUTER JOIN Job ON
(File.JobId = Job.JobId)
WHERE Job.JobId IS NULL LIMIT 300000

9) Check for orphaned Path records
SELECT DISTINCT Path.PathId,File.PathId FROM Path LEFT OUTER JOIN File
ON (Path.PathId=File.PathId) WHERE File.PathId IS NULL LIMIT 300000


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
       |     8251910 |     NULL | NULL   |      | BTREE      |
|
| File  |          1 | JobId         |            1 | JobId       | A
       |        3641 |     NULL | NULL   |      | BTREE      |
|
| File  |          1 | idxPathId     |            1 | PathId      | A
       |       24199 |     NULL | NULL   |      | BTREE      |
|
| File  |          1 | idxFilenameId |            1 | FilenameId  | A
       |      187543 |     NULL | NULL   |      | BTREE      |
|
| File  |          1 | idxJPF        |            1 | JobId       | A
       |        3641 |     NULL | NULL   |      | BTREE      |
|
| File  |          1 | idxJPF        |            2 | PathId      | A
       |      434311 |     NULL | NULL   |      | BTREE      |
|
| File  |          1 | idxJPF        |            3 | FilenameId  | A
       |     8251910 |     NULL | NULL   |      | BTREE      |
|
+-------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+


-- 
with best regards

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