The custom scan after the last LMS scan I did took around 1.5 hours.
This is around half the time it took before I started using the
auto-vacuum and large buffer size.
I then deleted the indices, restarted LMS, and did another full scan.
There's no change. A few seconds here or there at most.
Later I will reduce the buffer to 20MB and report.
The Custom Scan 'info' output is below. It still took almost exactly
1.5 hours. I include this in case Erland is interested.
Code:
--------------------
[14-05-06 18:53:37.5855] Plugins::CustomScan::Scanner::fullRescan (678)
Performing rescan
[14-05-06 18:53:37.6016] Plugins::CustomScan::Scanner::fullRescan (690)
Starting scanning with Custom Tag
[14-05-06 18:53:37.6027] Plugins::CustomScan::Scanner::fullRescan (690)
Starting scanning with Rating Tag
[14-05-06 18:53:37.6037] Plugins::CustomScan::Scanner::fullRescan (690)
Starting scanning with Mixed Tag
[14-05-06 18:53:37.6050] Plugins::CustomScan::Scanner::refreshData (1944)
Refresh triggered by module: LastFM
[14-05-06 18:53:37.6058] Plugins::CustomScan::Scanner::refreshData (1955)
CustomScan: Synchronizing Custom Scan data, please wait...
[14-05-06 18:53:37.6066] Plugins::CustomScan::Scanner::refreshData (1957)
Starting to update musicbrainz id's in custom scan artist data based on names
[14-05-06 18:53:37.6166] Plugins::CustomScan::Scanner::refreshData (1981)
Finished updating musicbrainz id's in custom scan artist data based on names,
updated 0 items : It took 0.009859 seconds
[14-05-06 18:53:37.6185] Plugins::CustomScan::Scanner::refreshData (1987)
Starting to update custom scan artist data based on musicbrainz ids
[14-05-06 18:53:37.6201] Plugins::CustomScan::Scanner::refreshData (2010)
Finished updating custom scan artist data based on musicbrainz ids, updated 0
items : It took 0.001563 seconds
[14-05-06 18:53:37.6214] Plugins::CustomScan::Scanner::refreshData (2017)
Starting to update custom scan artist data based on names
[14-05-06 18:53:37.6229] Plugins::CustomScan::Scanner::refreshData (2040)
Finished updating custom scan artist data based on names, updated 0 items : It
took 0.001406 seconds
[14-05-06 18:53:37.6238] Plugins::CustomScan::Scanner::refreshData (2047)
Starting to update musicbrainz id's in custom scan album data based on titles
[14-05-06 18:53:37.6253] Plugins::CustomScan::Scanner::refreshData (2071)
Finished updating musicbrainz id's in custom scan album data based on titles,
updated 0 items : It took 0.001434 seconds
[14-05-06 18:53:37.6262] Plugins::CustomScan::Scanner::refreshData (2077)
Starting to update custom scan album data based on musicbrainz ids
[14-05-06 18:53:37.6277] Plugins::CustomScan::Scanner::refreshData (2100)
Finished updating custom scan album data based on musicbrainz ids, updated 0
items : It took 0.001453 seconds
[14-05-06 18:53:37.6286] Plugins::CustomScan::Scanner::refreshData (2106)
Starting to update custom scan album data based on titles
[14-05-06 18:53:37.6301] Plugins::CustomScan::Scanner::refreshData (2129)
Finished updating custom scan album data based on titles, updated 0 items : It
took 0.001406 seconds
[14-05-06 18:53:37.6310] Plugins::CustomScan::Scanner::refreshData (2135)
Starting to update musicbrainz id's in custom scan track data based on urls
[14-05-06 18:53:52.4797] Plugins::CustomScan::Scanner::refreshData (2159)
Finished updating musicbrainz id's in custom scan track data based on urls,
updated 0 items : It took 14.84864 seconds
[14-05-06 18:53:52.5375] Plugins::CustomScan::Scanner::refreshData (2165)
Starting to update custom scan track data based on musicbrainz ids
[14-05-06 18:53:56.1836] Plugins::CustomScan::Scanner::refreshData (2261)
Finished updating custom scan track data based on musicbrainz ids, updated 1157
items : It took 3.646018 seconds
[14-05-06 18:53:56.2403] Plugins::CustomScan::Scanner::refreshData (2267)
Starting to update custom scan track data based on urls
[14-05-06 18:56:56.7353] Plugins::CustomScan::Scanner::refreshData (2290)
Finished updating custom scan track data based on urls, updated 473284 items :
It took 180.494953 seconds
[14-05-06 18:56:56.8511] Plugins::SrvrPowerCtrl::Watchdog::OnWakeupWatchdog
(647) Wakeup Call!!
[14-05-06 18:56:56.9982] Plugins::CustomScan::Scanner::refreshData (2297)
Start optimizing SQLite database
[14-05-06 18:57:17.3130] Plugins::CustomScan::Scanner::refreshData (2303)
Finished optimizing SQLite database : It took 20.314617 seconds
[14-05-06 18:57:17.3138] Plugins::CustomScan::Scanner::refreshData (2305)
CustomScan: Synchronization finished
[14-05-06 18:57:18.4164] Plugins::TrackStat::Storage::refreshTracks (1237)
TrackStat: Synchronizing TrackStat data, please wait...
[14-05-06 18:57:24.4583] Plugins::TrackStat::Storage::refreshTracks (1886)
TrackStat: Synchronizing TrackStat data finished
[14-05-06 18:57:30.4800] Plugins::CustomScan::Scanner::fullRescan (678)
Performing rescan
[14-05-06 18:57:30.4933] Plugins::CustomScan::Scanner::fullRescan (681)
CustomScan: Scanning already in progress, wait until its finished
[14-05-06 18:57:30.4947] Plugins::TrackStat::Storage::refreshTracks (1237)
TrackStat: Synchronizing TrackStat data, please wait...
[14-05-06 18:57:35.2576] Plugins::TrackStat::Storage::refreshTracks (1886)
TrackStat: Synchronizing TrackStat data finished
[14-05-06 18:57:37.2727] Plugins::CustomScan::Scanner::initTrackScan (1318)
Clearing track data for mixedtag
[14-05-06 18:57:37.7588] Plugins::CustomScan::Scanner::initTrackScan (1356)
Start clearing track data with drop
[14-05-06 18:58:21.7715] Plugins::CustomScan::Scanner::initDatabase (96)
CustomScan: Creating database tables
[14-05-06 18:58:21.7771] Plugins::CustomScan::Scanner::executeSQLFile (498)
Executing SQL file
/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbcreate.sql
[14-05-06 18:58:21.8012] Plugins::CustomScan::Scanner::initDatabase (439)
Creating indexes
[14-05-06 18:58:21.8026] Plugins::CustomScan::Scanner::executeSQLFile (498)
Executing SQL file
/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbindex.sql
[14-05-06 18:58:50.4562] Plugins::CustomScan::Scanner::initTrackScan (1396)
Deleted track data after 73.183448 seconds
[14-05-06 18:58:50.4572] Plugins::CustomScan::Scanner::initTrackScan (1318)
Clearing track data for ratingtag
[14-05-06 18:58:50.4648] Plugins::CustomScan::Scanner::initTrackScan (1336)
Start clearing track data with delete
[14-05-06 18:58:53.1434] Plugins::CustomScan::Scanner::initTrackScan (1396)
Deleted track data after 2.686274 seconds
[14-05-06 18:58:53.1443] Plugins::CustomScan::Scanner::initTrackScan (1318)
Clearing track data for customtag
[14-05-06 18:58:53.3012] Plugins::CustomScan::Scanner::initTrackScan (1356)
Start clearing track data with drop
[14-05-06 18:58:58.7119] Plugins::CustomScan::Scanner::initDatabase (96)
CustomScan: Creating database tables
[14-05-06 18:58:58.7133] Plugins::CustomScan::Scanner::executeSQLFile (498)
Executing SQL file
/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbcreate.sql
[14-05-06 18:58:58.7248] Plugins::CustomScan::Scanner::initDatabase (439)
Creating indexes
[14-05-06 18:58:58.7262] Plugins::CustomScan::Scanner::executeSQLFile (498)
Executing SQL file
/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbindex.sql
[14-05-06 18:58:58.9773] Plugins::CustomScan::Scanner::initTrackScan (1396)
Deleted track data after 5.832959 seconds
[14-05-06 18:58:58.9852] Plugins::CustomScan::Scanner::initTrackScan (1406)
Got 24687 tracks
[14-05-06 18:59:04.6256] Slim::Networking::IO::Select::__ANON__ (131) Error:
Select task failed calling Slim::Networking::Async::HTTP::_http_read_body:
illegal file descriptor or filehandle (either no attached file descriptor or
illegal value): at /usr/share/perl5/Slim/Networking/IO/Select.pm line 134.
; fh=Slim::Networking::Async::Socket::HTTP=GLOB(0xb342f28)
[14-05-06 20:20:03.0309]
Plugins::CustomScan::Modules::MixedTag::exitScanTrack (227) MixedTag: Creating
ARTIST tag data
[14-05-06 20:20:03.0620]
Plugins::CustomScan::Modules::MixedTag::exitScanTrack (231) MixedTag: Creating
ALBUMARTIST tag data
[14-05-06 20:20:26.2835]
Plugins::CustomScan::Modules::MixedTag::exitScanTrack (235) MixedTag: Creating
TRACKARTIST tag data
[14-05-06 20:21:01.7244]
Plugins::CustomScan::Modules::MixedTag::exitScanTrack (239) MixedTag: Creating
CONDUCTOR tag data
[14-05-06 20:21:10.1032]
Plugins::CustomScan::Modules::MixedTag::exitScanTrack (243) MixedTag: Creating
COMPOSER tag data
[14-05-06 20:21:22.2081]
Plugins::CustomScan::Modules::MixedTag::exitScanTrack (247) MixedTag: Creating
BAND tag data
[14-05-06 20:21:34.1983]
Plugins::CustomScan::Modules::MixedTag::exitScanTrack (251) MixedTag: Creating
ALBUM tag data
[14-05-06 20:21:48.0198]
Plugins::CustomScan::Modules::MixedTag::exitScanTrack (255) MixedTag: Creating
GENRE tag data
[14-05-06 20:22:08.0191]
Plugins::CustomScan::Modules::MixedTag::exitScanTrack (259) MixedTag: Creating
YEAR tag data
[14-05-06 20:22:24.1135]
Plugins::CustomScan::Modules::MixedTag::exitScanTrack (275) MixedTag: Creating
CustomTag based tag data
[14-05-06 20:23:47.2887]
Plugins::CustomScan::Modules::MixedTag::exitScanTrack (292) MixedTag: Finished
creating tag data
[14-05-06 20:23:47.2919] Plugins::SrvrPowerCtrl::Watchdog::OnWakeupWatchdog
(647) Wakeup Call!!
[14-05-06 20:23:47.4725] Plugins::CustomScan::Scanner::exitScan (1014)
Optimizing SQLite database
[14-05-06 20:23:56.5500] Plugins::CustomScan::Scanner::exitScan (1041) Rescan
finished
--------------------
LMS 7.9 on VortexBox Midi running Xubuntu 14.04, FLACs 16->24 bit,
44.1->192kbps. Wired Touch + EDO, coax to Musical Fidelity M1 CLiC.
Wireless Xubuntu 14.04 laptop controls LMS via Chromium. Meridian
Explorer USB DAC to listen via Squeezelite on Vortexbox & other PCs as
required. Spare Touch in loft.
------------------------------------------------------------------------
PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642
View this thread: http://forums.slimdevices.com/showthread.php?t=101469
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
