Suspicious behaviour of the delete process

[Andreas J. Koenig]

I have running mogilefsd from subversion rev. 421 for a week now.

The database shows me

+----------------+---------+-------------+
| Name           | Rows    | Data_length |
+----------------+---------+-------------+
| file           |   54606 |     5414532 | 
| file_on        | 2858547 |    22868376 | 
| file_to_delete | 1273273 |     8912911 | 
+----------------+---------+-------------+

and the delete process uses quite a lot of CPU:

% ps auxww|grep mogi
www-data 21708  0.5  0.7  27744 24576 ?        S    Oct04  49:35 /usr/bin/perl /usr/local/bin/mogilefsd --daemon --no_schema_check
www-data 21709  0.0  0.3  12964  9440 ?        S    Oct04   0:02 /usr/local/bin/mogilefsd [checker]
www-data 21710  0.3  0.3  13992 10820 ?        S    Oct04  31:30 /usr/local/bin/mogilefsd [replicate]
www-data 21711  0.3  0.3  13992 10824 ?        S    Oct04  31:24 /usr/local/bin/mogilefsd [replicate]
www-data 21712  0.3  0.3  14036 10900 ?        S    Oct04  30:10 /usr/local/bin/mogilefsd [replicate]
www-data 21713  0.3  0.3  13992 10840 ?        S    Oct04  31:08 /usr/local/bin/mogilefsd [replicate]
www-data 21714  0.3  0.3  13992 10816 ?        S    Oct04  29:43 /usr/local/bin/mogilefsd [replicate]
www-data 21721  0.0  0.3  14564 11384 ?        S    Oct04   5:59 /usr/local/bin/mogilefsd [queryworker]
www-data 21729  0.0  0.8  28252 25148 ?        S    Oct04   6:01 /usr/local/bin/mogilefsd [queryworker]
www-data 21734  0.0  0.7  27560 24416 ?        S    Oct04   6:03 /usr/local/bin/mogilefsd [queryworker]
www-data 21736  0.4  0.3  14196 11076 ?        S    Oct04  36:05 /usr/local/bin/mogilefsd [monitor]
www-data 26444  0.0  1.3  44180 40964 ?        S    Oct05   5:39 /usr/local/bin/mogilefsd [queryworker]
www-data  2762  0.0  0.9  31144 28044 ?        S    Oct05   5:33 /usr/local/bin/mogilefsd [queryworker]
www-data  8298  0.0  1.1  38068 34964 ?        S    Oct09   1:32 /usr/local/bin/mogilefsd [queryworker]
www-data  8299  0.0  1.0  36780 33676 ?        S    Oct09   1:33 /usr/local/bin/mogilefsd [queryworker]
www-data  8300  0.0  1.0  35492 32388 ?        S    Oct09   1:35 /usr/local/bin/mogilefsd [queryworker]
www-data 29688 33.9  0.9  32908 29740 ?        R    Oct09 441:30 /usr/local/bin/mogilefsd [delete]
www-data 29689  0.0  0.9  32908 29804 ?        S    Oct09   1:15 /usr/local/bin/mogilefsd [queryworker]
www-data 29754  0.0  0.9  31616 28512 ?        S    Oct09   1:15 /usr/local/bin/mogilefsd [queryworker]
www-data  4996  0.0  0.9  31616 28516 ?        S    08:52   0:09 /usr/local/bin/mogilefsd [queryworker]
www-data  4997  0.0  0.9  31616 28512 ?        S    08:52   0:08 /usr/local/bin/mogilefsd [queryworker]
www-data  4998  0.0  0.9  31616 28512 ?        S    08:52   0:08 /usr/local/bin/mogilefsd [queryworker]
www-data  4999  0.0  0.8  30328 27228 ?        S    08:52   0:09 /usr/local/bin/mogilefsd [queryworker]
www-data  5004  0.0  0.8  29036 25932 ?        S    08:52   0:08 /usr/local/bin/mogilefsd [queryworker]
www-data  5005  0.0  0.8  29036 25932 ?        S    08:52   0:08 /usr/local/bin/mogilefsd [queryworker]
www-data  5006  0.0  0.7  27744 24644 ?        S    08:52   0:08 /usr/local/bin/mogilefsd [queryworker]
www-data  5007  0.0  0.7  27744 24640 ?        S    08:52   0:09 /usr/local/bin/mogilefsd [queryworker]
www-data  5008  0.0  0.7  27744 24640 ?        S    08:52   0:08 /usr/local/bin/mogilefsd [queryworker]
www-data  5036  0.0  0.7  27744 24640 ?        S    08:52   0:08 /usr/local/bin/mogilefsd [queryworker]



My impression is that there is a bad proportion between the number of
rows in file and in file_on. I wonder why file_to_delete is so large
and why the delete process uses so much CPU.

Please advise what I should do to debug the situation and what might
be going wrong and how a sane relation between the three tables should
look like.

Thanks!
-- 
andreas