Slow start with MySQL and NAS

[Andrey Goreev]

Sorry I don't see anything that could slow down the startup there.
I guess this would need to be reviewed by someone who knows MySQL well.

On Wednesday, October 25, 2017 12:00:33 AM MDT, Christoph Huckle wrote:
> Starting the appimage the output is
>
> -- digiKam AppImage Bundle                                      
>                                                       
> -- Use 'help' as CLI argument to know all available options 
>                                                           
> QtAV 1.12.0(Jul 20 2017, 17:39:32) 
>                                                                                    
> Multimedia framework base on Qt and FFmpeg. 
>                                                                           
> Distributed under the terms of LGPLv2.1 or later. 
>                                                                     
> Shanghai University->S3 Graphics->Deepin->PPTV, Shanghai, China 
> Copyright (C) 2012-2016 Wang Bin (aka. Lucas Wang) 
> wbsecg1 at gmail.com 
> Donate: http://qtav.org/donate.html 
>                                                                                   
> Source: https://github.com/wang-bin/QtAV 
>                                                                              
> Home page: http://qtav.org 
>                                                                                            
> capi::version: 0.6.0 
>                                                                                                  
> Cannot connect to server socket err = Datei oder Verzeichnis 
> nicht gefunden                                           
> Cannot connect to server request channel 
> jack server is not running or cannot be started 
> JackShmReadWritePtr::~JackShmReadWritePtr - Init not done for 
> 4294967295, skipping unlock 
> JackShmReadWritePtr::~JackShmReadWritePtr - Init not done for 
> 4294967295, skipping unlock 
> QFSFileEngine::open: No file name specified 
> QFSFileEngine::open: No file name specified
>
> and then it takes long
> with
>
> "applications.menu"  not found in 
>  ("/home/christoph/.config/menus", "/etc/xdg/menus")  
>
> QFSFileEngine::open: No file name specified
>
> the main window appears
>
> Andrey Goreev <aegoreev at gmail.com> schrieb am Di., 24. Okt. 
> 2017 um 15:41 Uhr:
> When you are on Ubuntu try opening digikam in the terminal and 
> then watch its output when start-up stalls. 
>
> That should give an idea on what exactly slows down the start-up.
>
> Sent from my Samsung Galaxy smartphone.
>
> -------- Original message --------
> From: Christoph Huckle <chrihuc at gmail.com>
> Date: 2017-10-24 7:16 AM (GMT-07:00)
> To: digiKam - Home Manage your photographs as a professional 
> with the power of open source <digikam-users at kde.org>
> Subject: Re: Slow start with MySQL and NAS
>
> Thanks, the "Remove obsolete core..." was disabled anyway. Now 
> I've disabled the scan for new items. 
> This did not improve the situation. The start takes still long 
> in the step "Loading Database"
>
> Remco Viëtor <remco.vietor at wanadoo.fr> schrieb am Mo., 23. Okt. 
> 2017 um 17:37 Uhr:
> On lundi 23 octobre 2017 16:11:15 CEST Christoph Huckle wrote:
>> Hey All,
>>
>> I'm experiencing slow starts on my setup.
>> All my pictures (>60k) are stored on a local NAS, the MySQL database is on
>> the same server.
>> Startup time is heavily depending on network performance.
>> With 1Gb LAN connection max 5min, with wireless lan up to 30min.
>>
>> Tested on Ubuntu 17.10, Win10, MacOS. All behave similar.
>>
>> Please let me know how I can provide more helpful information.
>>
>
> Digikam is probably looking for new items in the collection, and/or cleaning
> the database. Both of these can be disabled in the 
> configuration dialog, under
> "Miscellaneous": "Scan for new items at startup" and "Remove obsolete core
> database objects" (both are marked as "(makes startup slower)").
>
> Remco
>
>

-- 
Thanks,
Andrey