Am I pushing the database too far?

[bobfa]

I have MoOde running on my USBridge Sig.  Most of the time it works great, BUT I think I am pushing it past its limits.  Database access things kind of hang up.  Searching is the worst.  

I have 80099 tracks in the database on my NAS. (6055 hours and 30 min of music)


I am starting a project to see what my library has that is in Qobuz and then archive the music in my library.


I assume that I am running it up against the wall???

[Tim Curtis]

Could be hitting some resource limits with 80K tracks. Post details about your configuration.

- Any WiFi repeaters?

- Powerline adapters?
- Brand of uSD card?
- Any OS tweeks?

Code:

sudo /var/www/command/sysinfo.sh

-Tim

[swizzle]

The problem with big databases is big lists which take up a lot of resources. I’ve looked briefly into moving to a system that doesn’t keep the entire list in memory at a time but that also means we couldn’t do some things that moode currently does so it doesn’t seem worth it right now.

For search in tag/cover views iirc there was a bug that made it lag which I believe was addressed for 6.4.

There’s no getting around the size of the library necessitating more work though, how well your device performs with a big library will depend on how fast your device is.

[bobfa]

Could be hitting some resource limits with 80K tracks. Post details about your configuration.

- Any WiFi repeaters?

- Powerline adapters?
- Brand of uSD card?
- Any OS tweeks?

Code:

sudo /var/www/command/sysinfo.sh

-Tim

The USBridge Sig is direct ethernet to my Ubiquity network
Sandisk Extreme Plus 32gb V30 card
No OS tweaks.

WiFi for control points ins 802.11 A/C

Log file

S Y S T E M   P A R A M E T E R S

moOde release = 6.3.0 2019-10-02
Raspbian OS = 10.1
Linux kernel = 4.19.75-v8+ #1270
Platform = Pi-CM3+ 1GB v1.0
Architecture = aarch64 (64-bit)
System uptime = up 20 hours, 13 minutes
Timezone = America/Chicago
Current time = 2019-11-21 13:04:24

Host name = moode
Ethernet address = 192.168.1.169
Ethernet MAC = 00:17:f7:00:a7:d5
WLAN address = unassigned
WLAN MAC = no adapter
WLAN country = US

SoC identifier = bcm2837 
Core count = 4
Kernel timer freq = 250 Hz
SDCard freq = 50 MHz
USB boot = not available
Warranty = OK

Root size = 29G
Root used = 10%
Root available = 26G
Root expand = expanded
Memory free = 121 MB
Memory used = 279 MB
SoC temperature = 49.4°C

CPU governor = ondemand
Onboard WiFi = None
Onboard BT = None
HDMI output = On
Eth addr wait = On
Max USB current = Off
USB (UAC2) fix = Off
Pi-3B+ eth fix = Off
SSH term server = Off

PHP-FPM version = 7.3.9
NGINX version = 1.14.2
SQLite3 version = 3.27.2
Hostapd version = 2.8-devel
WiringPi version = 2.50
RPi.GPIO version = 0.7.0

A U D I O   P A R A M E T E R S

Audio device = USB audio device
Interface = USB
Hardware volume = None
Mixer name = PCM
Audio source = Local
Output device = Local
Resume MPD = No
Volume knob = 0
Volume mute = Unmuted
Saved MPD vol = 0
Preamp volume = 0
ALSA version = 1.1.8-1+rpt1
SoX version = 0.1.2-3

Bluetooth controller = Off
Pairing agent = Off
Airplay receiver = Off
Spotify receiver = Off
Squeezelite = Off
UPnP client = On
DLNA server = Off
GPIO button handler = Off
UPnP browser = On

Auto-shuffle = Off
Autoplay = Off
Rotary encoder = Off
Encoder params = 100 2 3 23 24
Polarity inversion = Off
Crossfeed = Off
Crossfade = Off
Parametric EQ = Off
Graphic EQ = Off
MPD httpd = Off

A P P E A R A N C E   S E T T I N G S

Theme = Fern
Accent color = Emerald
Alpha blend = 1.0
Adaptive background = No
Background image = No
Cover backdrop = No
Cover blur = 20px
Cover scale = 1.25
CoverView auto-display = Never
CoverView style = Animated
Auto-shuffle filter = None
Extra metadata = Yes
Playback history = No

L I B R A R Y   S E T T I N G S

Instant play action = Clear/Play
Show genres column = No
Album grouping = by Artist
Compilation identifier = Various Artists
Recently added = 1 Month
Ignore articles = a,an,the
UTF8 character filter = No
Hi-res thumbs = Auto
Cover search pri = Embedded cover
Pixel ratio = 2

M P D   S E T T I N G S

Version = 0.20.23
Volume control = disabled
ALSA device = hw:1
SoX resampling = disabled
SoX quality = very high
SoX multithreading = off
DSD over PCM (DoP) = no
Replaygain = off
Replaygain preamp = 0
Volume normalization = No
Audio buffer = 4096 (kb)
Output buffer size = 131072 (kb)

B L U E T O O T H   S E T T I N G S

Bluetooth ver = 5.50
Bluealsa ver = 1.3.1
Speaker sharing = No
Resume MPD = No
PCM buffer time = 500000 (μs)

A I R P L A Y   S E T T I N G S

Version = 3.3.2
Friendly name = Moode Airplay
ALSA device = hw:1
Interpolation = soxr
Output bit depth = S16
Output sample rate = 44100
Session interruption = no
Session timeout = 120 (ms)
Audio buffer = 0.0 (secs)
Resume MPD = No

S P O T I F Y   S E T T I N G S

Friendly name = Moode Spotify
ALSA device = plughw:1
Bit rate = 160
Initial volume = 0
Volume curve = Logarithmic
Volume normalization = No
Normalization pregain = 0
Resume MPD = No

S Q U E E Z E L I T E   S E T T I N G S

Version = 1.8.7-1052 "DSD/SRC enabled"
Friendly name = Moode
ALSA device = hw:1
ALSA params = 80:4::1
Output buffers = 40000:100000
Task priority = 45
Codec list = flac,pcm,mp3,ogg,aac,alac,dsd
Other options = -W -D 500 -R E -S /var/local
Resume MPD = No

L O C A L   D I S P L A Y   S E T T I N G S

Local UI display = On
Mouse cursor = On
Screen blank = 600 Secs
Brightness = 255
Pixel aspect ratio = Default
Rotate screen = 0 Deg

M O O D E   S T A R T U P   L O G

20191120 165138 worker: -- Start
20191120 165138 worker: Successfully daemonized
20191120 165138 worker: Integrity check (passed)
20191120 165138 worker: Session loaded
20191120 165138 worker: Debug logging (off)
20191120 165138 worker: ALSA volume (None)
20191120 165139 worker: -- System
20191120 165141 worker: Host name     (moode)
20191120 165141 worker: moOde release (6.3.0 2019-10-02)
20191120 165141 worker: Raspbian OS   (10.1)
20191120 165141 worker: Linux kernel  (4.19.75-v8+ #1270)
20191120 165141 worker: Platform      (Pi-CM3+ 1GB v1.0)
20191120 165141 worker: Architecture  (aarch64)
20191120 165141 worker: MPD version   (0.20.23)
20191120 165141 worker: CPU governor  (ondemand)
20191120 165141 worker: USB boot not available
20191120 165141 worker: File system expanded
20191120 165141 worker: HDMI port on
20191120 165142 worker: File check (OK)
20191120 165142 worker: -- Network
20191120 165142 worker: eth0 exists
20191120 165142 worker: eth0 (192.168.1.169)
20191120 165142 worker: wlan0 does not exist
20191120 165142 worker: -- Audio
20191120 165142 worker: ALSA outputs unmuted
20191120 165142 worker: ALSA card number (1)
20191120 165142 worker: Audio output (USB audio device)
20191120 165143 worker: Supported audio formats (U8, S16_LE)
20191120 165143 worker: ALSA mixer name (PCM)
20191120 165143 worker: MPD volume control (disabled)
20191120 165143 worker: Hdwr volume controller not detected
20191120 165143 worker: -- Services
20191120 165143 worker: Reset renderer active state
20191120 165143 worker: MPD conf updated
20191120 165143 worker: MPD started
20191120 165148 worker: MPD accepting connections
20191120 165148 worker: Configure MPD outputs
20191120 165148 worker: MPD output 1 ALSA default (on)
20191120 165148 worker: MPD output 2 ALSA crossfeed (off)
20191120 165148 worker: MPD output 3 ALSA parametric eq (off)
20191120 165148 worker: MPD output 4 ALSA graphic eq (off)
20191120 165148 worker: MPD output 5 ALSA polarity inversion (off)
20191120 165148 worker: MPD output 6 ALSA bluetooth (off)
20191120 165148 worker: MPD output 7 HTTP stream (off)
20191120 165148 worker: MPD crossfade (off)
20191120 165148 worker: Audio source (Local)
20191120 165148 worker: Output device (Local)
20191120 165148 worker: UPnP renderer started
20191120 165148 worker: UPnP browser started
20191120 165148 worker: USB auto-mounter (udisks-glue)
20191120 165148 worker: -- Music sources
20191120 165148 worker: USB sources (none attached)
20191120 165149 worker: NAS and UPnP sources (mountall initiated)
20191120 165149 worker: -- Miscellaneous
20191120 165149 worker: Saved MPD vol level (0)
20191120 165149 worker: Preamp volume level (0)
20191120 165149 worker: MPD volume level (0) restored
20191120 165149 worker: ALSA volume level (None)
20191120 165149 worker: Auto-play (Off)
20191120 165149 worker: LocalUI started
20191120 165149 worker: Maintenance interval (6 hrs)
20191120 165149 worker: Screen saver activation (Never)
20191120 165149 worker: Session permissions (OK)
20191120 165149 worker: Watchdog started
20191120 165149 worker: Ready
20191120 230604 worker: Maintenance completed
20191120 233857 watchdog: PHP restarted (fpm child limit > 40)
20191120 233932 worker: Job rescanmpddb
20191121 001533 watchdog: MPD restarted (check syslog for errors)
20191121 052010 worker: Maintenance completed
20191121 113344 worker: Maintenance completed

[Tim Curtis]

Looks ok. Might want to switch back to the 32-bit kernel.

What kind of clients are u using?

[bobfa]

where I see the issue is  on the moode ui.

I forgot I switched to 64 bit.  I will switch back.  Oh check the UI I think it showed me on 32 when I was on 64 or i read it wrong.


The control apps I am using seem to have a variety of issues.  

I am using MConnect HD on my ipad and samsung tablets.  Bubble on an android phone.  Mconnect on my iPhone.

My library is on a QNAP 450 series NAS on the same wired network.  

MConnect is almost intolerable as it seems to reload the database over and over and over.  I am using Plex on the QNAP should I try something else for UPnP there?

I do not think I should put a drive on the USBridge Sig.  I think Ioan suggested that was a bad idea.

[Tim Curtis]

The symptoms suggest bugs or performance issues in these other client apps. Contact their maintainers for support. I can only support moOde's built-in WebUI.

[bobfa]

I found the PROBLEM.

I have an external display hooked up to the USBridge Sig. That display is 4K. I turned the local UI Off and things work perfectly fine! The WebUI performance is great.

[suzywong]

One wonders when the OP finds time to listen to his 80000+ tracks...................

How many years is 6000 hours? 

[bobfa]

At Least my Hoarding Habit does not take up physical space.