Re: [Bacula-users] Unneeded database index

2013-08-16 Thread Radosław Korzeniewski
Hello, 2013/8/13 azurIt > > No statement from developers regarding this? > > Wrong list... :) Developers are on bacula-devel, not bacula-users. best regards -- Radosław Korzeniewski rados...@korzeniewski.net -- Get 100

Re: [Bacula-users] Unneeded database index

2013-08-13 Thread azurIt
>Zitat von azurIt : > >> Hi, >> >> i'm having some MySQL performance difficulties so i started to >> search what can i do better. My table 'File' had these indexes >> created: >> CREATE INDEX file_jobid_idx on File (JobId); >> CREATE INDEX file_jpf_idx on File (JobId, PathId, FilenameId); >> >>

Re: [Bacula-users] Unneeded database index

2013-08-08 Thread lst_hoe02
Zitat von azurIt : > Hi, > > i'm having some MySQL performance difficulties so i started to > search what can i do better. My table 'File' had these indexes > created: > CREATE INDEX file_jobid_idx on File (JobId); > CREATE INDEX file_jpf_idx on File (JobId, PathId, FilenameId); > > Which loo

[Bacula-users] Unneeded database index

2013-08-08 Thread azurIt
Hi, i'm having some MySQL performance difficulties so i started to search what can i do better. My table 'File' had these indexes created: CREATE INDEX file_jobid_idx on File (JobId); CREATE INDEX file_jpf_idx on File (JobId, PathId, FilenameId); Which looks correct according to documentation: h