[MDEV-20895] Mariadb speed reduced when run out of internet connection Created: 2019-10-24  Updated: 2019-12-09  Resolved: 2019-12-09

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.3.11
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Cristiano Viva Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback, performance
Environment:

Runnning on Synology NAS DS718+
Operating on DSM 6.2.2 update 3


 Description   

My MariaDB Server reduces processing speed and CPU usage when internet link is out.

I dont understand the reason for this.
As all my devices are running on the local network, with hosts on the local LAN, 192.168.0.X.
And I dont use any outside service.

What happens: simply removing the internet connection of my NAS, which is running the Mariadb server, and the time to perform queries are increase arround 10times.

I also noted that the CPU usage by the MariaDB service is also reduced.

With internet a query make the service use like 25% of CPU.
And without internet the same query use like 3% of CPU, and thus the speed to execute it is increased a lot.

Can any one help me with the issue?

 Comments   
Comment by Elena Stepanova [ 2019-11-05 ]

Do settings for bind_address, skip_networking or skip_name_resolve have any effect on the described behavior?

Generated at Thu Feb 08 09:03:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.