Package: bacula-director-mysql Version: 1.36.2-2sarge1 Severity: wishlist The /usr/share/bacula-director/make_mysql_tables file contains this note regarding the "File" table:
# Possibly add one or more of the following indexes # to the above File table if your Verifies are # too slow. # # INDEX (JobId), # INDEX (PathId), # INDEX (FilenameId), # INDEX (JobId, PathId, FilenameId) It does not only affect 'verifies' but also list and restore actions. In my setup I have roughly a million files on a file server. Without indices it takes ~10 minutes when I try to restore files before I get a chance to select which files to restore. With an index it's done in seconds. Thus I'd like to suggest adding these indices right away from the start. Christoph -- System Information: Debian Release: 3.1 Architecture: i386 (i686) Kernel: Linux 2.6.10 Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8) Versions of packages bacula-director-mysql depends on: ii bacula-common 1.36.2-2sarge1 Network backup, recovery and verif ii bacula-director-common 1.36.2-2sarge1 Network backup, recovery and verif ii debconf 1.4.30.13 Debian configuration management sy ii libc6 2.3.2.ds1-22 GNU C Library: Shared libraries an ii libgcc1 1:3.4.3-13 GCC support library ii libmysqlclient14 4.1.11a-4sarge2 mysql database client library ii libssl0.9.7 0.9.7e-3 SSL shared libraries ii libstdc++5 1:3.3.5-13 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-8 Wietse Venema's TCP wrappers libra ii mysql-client 4.0.24-10sarge1 mysql database client binaries ii zlib1g 1:1.2.2-4.sarge.2 compression library - runtime -- debconf information: * bacula-director-mysql/db_host: localhost * bacula-director-mysql/remove_catalog_on_purge: false * bacula-director-mysql/create_tables: true * bacula-director-mysql/mysql_root_username: root * bacula-director-mysql/db_user: bacula -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
