Re: [SlimDevices: Beta] 7.9 - help me to better understand database andindex usage

Hi, LMS ifo: Code: Logitech Media Server Version: 7.9.0 - 1400659950 @ Fri May 23 04:06:13 UTC 2014 Betriebssystem: Debian - DE - utf8 Plattformarchitektur: x86_64-linux Perl-Version: 5.14.2 - x86_64-linux-gnu-thread-multi Audio::Scan: 0.93 Datenbankversion:

Re: [SlimDevices: Beta] 7.9 - help me to better understand database andindex usage

Thanks guys! There's definitely a pattern in what indices are useful and which not... IMHO about half of them are questionable for one of a few reasons: - indexed column is not used (populated or accessed) at all (eg. track.hash) - indexed column is not used in any search/sort task where the in

Re: [SlimDevices: Beta] 7.9 - help me to better understand database andindex usage

Code: [14-05-17 16:27:05.0195] Slim::Music::Import::runScanPostProcessing (403) Starting Database optimization. [14-05-17 16:27:10.3583] Slim::Utils::SQLiteHelper::vacuum (486) Start VACUUM library.db [14-05-17 16:27:26.1826] Slim::Utils::SQLiteHelper::vacuum (511) V

Re: [SlimDevices: Beta] 7.9 - help me to better understand database andindex usage

Custom Clock Dynamic Playlists License Manager Song Info Song Lyrics SQL Playlist Trackstat Didn't know you could sort by Author on the Plugins page. Just tried it to see :) LMS Version: 7.9 TranquilPC T2-WHS-A3 - WHS 2011 2x Touch, 3x SB3 --

Re: [SlimDevices: Beta] 7.9 - help me to better understand database andindex usage

I have the following installed: Custom Scan Custom Browse Dynamic Playlists License Manager Song Info Song Lyrics TrackStat Can't say that i'm a heavy user though. soulgazer's Profile: http://forums.slimdevices.com/member

Re: [SlimDevices: Beta] 7.9 - help me to better understand database andindex usage

Thanks guys! Is anybody using some of Erland's plugins? If so: which one? ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta

Re: [SlimDevices: Beta] 7.9 - help me to better understand database andindex usage

Code: [14-05-17 12:46:27.3497] main::main (202) Starting Logitech Media Server scanner (v7.9.0, 1400229154, Sat May 17 03:04:59 CUT 2014) perl 5.014001 [14-05-17 12:46:28.3497] Slim::Schema::forceCommit (2126) Warning: Trying to commit transactions before DB is init

Re: [SlimDevices: Beta] 7.9 - help me to better understand database andindex usage

Code: [14-05-17 10:27:21.2773] Slim::Music::Import::runScanPostProcessing (403) Starting Database optimization. [14-05-17 10:27:30.0040] Slim::Utils::SQLiteHelper::vacuum (486) Start VACUUM library.db [14-05-17 10:27:42.5223] Slim::Utils::SQLiteHelper::vacuum (511) V

Re: [SlimDevices: Beta] 7.9 - help me to better understand database andindex usage

Code: [14-05-17 03:16:37.9778] Slim::Music::Import::runScanPostProcessing (403) Starting Database optimization. [14-05-17 03:16:45.2452] Slim::Utils::SQLiteHelper::vacuum (486) Start VACUUM library.db [14-05-17 03:18:03.8557] Slim::Utils::SQLiteHelper::vacuum (511) V

Re: [SlimDevices: Beta] 7.9 - help me to better understand database andindex usage

Code: [14-05-16 06:05:19.3367] main::main (202) Starting Logitech Media Server scanner (v7.9.0, TRUNK, UNKNOWN) perl 5.014001 [14-05-16 06:05:19.9617] Slim::Schema::forceCommit (2126) Warning: Trying to commit transactions before DB is initialized! [14-05-16 06:05

Re: [SlimDevices: Beta] 7.9 - help me to better understand database andindex usage

Code: [14-05-16 11:47:15.6428] main::main (202) Starting Logitech Media Server scanner (v7.9.0, 1400229154, Fri May 16 08:52:23 CUT 2014) perl 5.014001[14-05-16 11:47:16.2318] Slim::Schema::forceCommit (2126) Warning: Trying to commit transactions before DB is initializ

Re: [SlimDevices: Beta] 7.9 - help me to better understand database andindex usage

Code: [14-05-16 07:08:07.4697] Slim::Schema::optimizeDB (433) albumsArtworkIndex: 2280 2 [14-05-16 07:08:07.4700] Slim::Schema::optimizeDB (433) albumsDiscCountIndex: 2280 326 [14-05-16 07:08:07.4702] Slim::Schema::optimizeDB (433)