My DB had those indexes already. Here is what I have ATM:
--Snip--
mysql> show indexes from File \G
*** 1. row ***
Table: File
Non_unique: 0
Key_name: PRIMARY
Seq_in_index: 1
Column_name: FileId
Collation: A
Cardinality: 1
Another things you want to change in a default MySQL installation
is the max size of the tables - especially if you're like me and
backup a *lot* of files then the "File" table will run into
a 2/4GB limit quite quickly...
For details, see:
http://jeremy.zawodny.com/blog/archives/000796.html
-
Hi Ronan,
Did you add some indices manually to your mySQL db? Looks like the first
(concurrent) jobs run fast until the first finishes and updates the DB.
If the DB structure is still unmodified since Installation, this could be
the problem - but I'm not sure.
These changes can (should) be made
