Slow start with MySQL and NAS

[Christoph Huckle]

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.

Regards

Chrsitoph

--

[Remco Viëtor]

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

[Christoph Huckle]

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 <[hidden email]> 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

--

[AndriusWild]

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 <[hidden email]>

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 <[hidden email]>

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 <[hidden email]> 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

--

[Christoph Huckle]

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) [hidden email]
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 <[hidden email]> 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 <[hidden email]>

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 <[hidden email]>

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 <[hidden email]> 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

--

--

[AndriusWild]

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)
> [hidden email]
> 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 <[hidden email]> 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 <[hidden email]>
> 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 <[hidden email]>
> 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 <[hidden email]> 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

[Hans Troost]

Hi Christoph,

Did you ever got a solution for this? If yes, please share your knowledge
with me.

I/m using an Iomega Storecenter 2 for my photo's, a Synology DS918+ (DSM
6.2) for the Mariadb and a W10 laptop as client.
And I have in mind to use it multi-user (2nd will be my wife's Wxx-PC, now
W7 will be W10 soon).

Kind regards, Hans



--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html

[Christoph Huckle]

Hi Hans,

No, I did not find a solution. Right now I just live with the slow start.

Best regards,

Christoph

Hans Troost <[hidden email]> schrieb am Mi., 8. Aug. 2018 um 10:51 Uhr:

Hi Christoph,

Did you ever got a solution for this? If yes, please share your knowledge
with me.

I/m using an Iomega Storecenter 2 for my photo's, a Synology DS918+ (DSM
6.2) for the Mariadb and a W10 laptop as client.
And I have in mind to use it multi-user (2nd will be my wife's Wxx-PC, now
W7 will be W10 soon).

Kind regards, Hans



--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html