+- Moode Forum (https://moodeaudio.org/forum)
+-- Forum: moOde audio player (https://moodeaudio.org/forum/forumdisplay.php?fid=3)
+--- Forum: Support (https://moodeaudio.org/forum/forumdisplay.php?fid=7)
+--- Thread: Am I pushing the database too far? (/showthread.php?tid=1910)
Pages:
1
2
Am I pushing the database too far? - bobfa - 11-21-2019
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???
RE: Am I pushing the database too far? - Tim Curtis - 11-21-2019
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
RE: Am I pushing the database too far? - swizzle - 11-21-2019
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.
RE: Am I pushing the database too far? - bobfa - 11-21-2019
(11-21-2019, 11:12 AM)Tim Curtis Wrote: Could be hitting some resource limits with 80K tracks. Post details about your configuration.The USBridge Sig is direct ethernet to my Ubiquity network
- Any WiFi repeaters?
- Powerline adapters?
- Brand of uSD card?
- Any OS tweeks?
Code:sudo /var/www/command/sysinfo.sh
-Tim
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
RE: Am I pushing the database too far? - Tim Curtis - 11-21-2019
Looks ok. Might want to switch back to the 32-bit kernel.
What kind of clients are u using?
RE: Am I pushing the database too far? - bobfa - 11-22-2019
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.
RE: Am I pushing the database too far? - Tim Curtis - 11-22-2019
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.
RE: Am I pushing the database too far? - bobfa - 11-22-2019
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.
RE: Am I pushing the database too far? - suzywong - 11-22-2019
One wonders when the OP finds time to listen to his 80000+ tracks...................
How many years is 6000 hours?
RE: Am I pushing the database too far? - bobfa - 11-22-2019
At Least my Hoarding Habit does not take up physical space.