epg2vdr: DB > 4,6 GB und merge-Dauer > 100 Sekunden - ist das normal?

Aug 25 18:53:09 SERVER epgd: 811 DVB pending, mergeepg done after 11.091 seconds
Aug 25 18:54:10 SERVER epgd: 547 DVB pending, mergeepg done after 9.531 seconds
Aug 25 18:55:12 SERVER epgd: 1402 DVB pending, mergeepg done after 9.824 seconds
Aug 25 18:56:13 SERVER epgd: 1593 DVB pending, mergeepg done after 9.589 seconds
Aug 25 18:57:47 SERVER epgd: 819 DVB pending, mergeepg done after 9.632 seconds
Aug 25 18:58:49 SERVER epgd: 542 DVB pending, mergeepg done after 9.631 seconds
Aug 25 18:59:51 SERVER epgd: 636 DVB pending, mergeepg done after 9.807 seconds
Aug 25 19:01:55 SERVER epgd: 590 DVB pending, mergeepg done after 10.271 seconds
Aug 25 19:03:00 SERVER epgd: 626 DVB pending, mergeepg done after 12.857 seconds
Aug 25 19:05:32 SERVER epgd: 881 DVB pending, mergeepg done after 9.737 seconds
Aug 25 19:09:40 SERVER epgd: 556 DVB pending, mergeepg done after 9.802 seconds
Aug 25 19:11:12 SERVER epgd: 538 DVB pending, mergeepg done after 9.715 seconds
Aug 25 19:17:25 SERVER epgd: 765 DVB pending, mergeepg done after 9.902 seconds
Aug 25 19:22:36 SERVER epgd: 571 DVB pending, mergeepg done after 10.922 seconds
Aug 25 19:28:16 SERVER epgd: 531 DVB pending, mergeepg done after 10.273 seconds
Aug 25 19:32:24 SERVER epgd: 527 DVB pending, mergeepg done after 10.116 seconds
Aug 25 19:41:11 SERVER epgd: 616 DVB pending, mergeepg done after 10.001 seconds
Aug 25 19:45:19 SERVER epgd: 511 DVB pending, mergeepg done after 9.846 seconds
Aug 25 19:47:23 SERVER epgd: 600 DVB pending, mergeepg done after 9.934 seconds

~# mysqltuner.pl 
>>  MySQLTuner 1.7.19 - Major Hayden <major@mhtx.net>
>>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
>>  Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script
[OK] Logged in using credentials from Debian maintenance account.
[OK] Currently running supported MySQL version 10.3.22-MariaDB-1ubuntu1-log
[OK] Operating on 64-bit architecture

-------- Log file Recommendations ------------------------------------------------------------------
[OK] Log file /var/log/mysql/error.log exists
[--] Log file: /var/log/mysql/error.log(10K)
[OK] Log file /var/log/mysql/error.log is readable.
[OK] Log file /var/log/mysql/error.log is not empty
[OK] Log file /var/log/mysql/error.log is smaller than 32 Mb
[!!] /var/log/mysql/error.log contains 73 warning(s).
[!!] /var/log/mysql/error.log contains 6 error(s).
[--] 0 start(s) detected in /var/log/mysql/error.log
[--] 0 shutdown(s) detected in /var/log/mysql/error.log

-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE 
[--] Data in MyISAM tables: 174.9M (Tables: 29)
[--] Data in InnoDB tables: 8.0G (Tables: 67)
[OK] Total fragmented tables: 0

-------- Analysis Performance Metrics --------------------------------------------------------------
[--] innodb_stats_on_metadata: OFF
[OK] No stat updates during querying INFORMATION_SCHEMA.

-------- Security Recommendations ------------------------------------------------------------------
[OK] There are no anonymous accounts for any database users
[OK] All database users have passwords assigned
[--] There are 620 basic passwords in the list.

-------- CVE Security Recommendations --------------------------------------------------------------
[--] Skipped due to --cvefile option undefined

-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 2d 6h 29m 21s (12M q [64.916 qps], 321 conn, TX: 19G, RX: 1G)
[--] Reads / Writes: 75% / 25%
[--] Binary logging is disabled
[--] Physical Memory     : 11.6G
[--] Max MySQL memory    : 6.9G
[--] Other process memory: 0B
[--] Total buffers: 5.5G global + 31.3M per thread (40 max threads)
[--] P_S Max memory usage: 84M
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 5.9G (51.07% of installed RAM)
[OK] Maximum possible memory usage: 6.9G (58.96% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 1% (189K/12M)
[OK] Highest usage of available connections: 25% (10/40)
[OK] Aborted connections: 0.00%  (0/321)
[OK] Query cache is disabled by default due to mutex contention on multiprocessor machines.
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 13K sorts)
[OK] No joins without indexes
[OK] Temporary tables created on disk: 5% (2K on disk / 43K total)
[OK] Thread cache hit rate: 55% (142 created / 321 connections)
[OK] Table cache hit rate: 80% (394 open / 490 opened)
[OK] table_definition_cache(400) is upper than number of tables(346)
[OK] Open file limit used: 4% (172/4K)
[OK] Table locks acquired immediately: 100% (471K immediate / 471K locks)

-------- Performance schema ------------------------------------------------------------------------
[--] Memory used by P_S: 84.7M
[--] Sys schema is installed.

-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is enabled.
[--] Thread Pool Size: 4 thread(s).
[--] Using default value is good enough for your version (10.3.22-MariaDB-1ubuntu1-log)

-------- MyISAM Metrics ----------------------------------------------------------------------------
[OK] Key buffer used: 91.0% (13M used / 14M cache)
[OK] Key buffer size / total MyISAM indexes: 14.0M/78.0M
[OK] Read Key buffer hit rate: 99.7% (4M cached / 10K reads)
[OK] Write Key buffer hit rate: 98.5% (170K cached / 168K writes)

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[!!] InnoDB buffer pool / data size: 5.0G/8.0G
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 550.0M * 2/5.0G should be equal to 25%
[OK] InnoDB buffer pool instances: 5
[--] Number of InnoDB Buffer Pool Chunk : 40 for 5 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[OK] InnoDB Read buffer efficiency: 99.93% (750903926 hits/ 751408294 total)
[OK] InnoDB Write log efficiency: 96.12% (5430875 hits/ 5650093 total)
[OK] InnoDB log waits: 0.00% (0 waits / 219218 writes)

-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is enabled.
[OK] Aria pagecache size / total Aria indexes: 18.0M/1B
[!!] Aria pagecache hit rate: 94.3% (37K cached / 2K reads)

-------- TokuDB Metrics ----------------------------------------------------------------------------
[--] TokuDB is disabled.

-------- XtraDB Metrics ----------------------------------------------------------------------------
[--] XtraDB is disabled.

-------- Galera Metrics ----------------------------------------------------------------------------
[--] Galera is disabled.

-------- Replication Metrics -----------------------------------------------------------------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] Binlog format: MIXED
[--] XA support enabled: ON
[--] Semi synchronous replication Master: OFF
[--] Semi synchronous replication Slave: OFF
[--] This is a standalone server

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
Control warning line(s) into /var/log/mysql/error.log file
Control error line(s) into /var/log/mysql/error.log file
Variables to adjust:
innodb_buffer_pool_size (>= 8.0G) if possible.

# tuning-primer.sh 

-- MYSQL PERFORMANCE TUNING PRIMER --
- By: Matthew Montgomery -

MySQL Version 10.3.22-MariaDB-1ubuntu1-log x86_64

Uptime = 2 days 6 hrs 36 min 15 sec
Avg. qps = 64
Total Questions = 12743777
Threads Connected = 9

Server has been running for over 48hrs.
It should be safe to follow these recommendations

To find out more information on how each of these
runtime variables effects performance visit:                                                                                                    
http://dev.mysql.com/doc/refman/10.3/en/server-system-variables.html
Visit http://www.mysql.com/products/enterprise/advisors.html
for info about MySQL's Enterprise Monitoring and Advisory Service

SLOW QUERIES
The slow query log is NOT enabled.
Current long_query_time = 3.000000 sec.
You have 190883 out of 12743868 that take longer than 3.000000 sec. to complete
Your long_query_time seems to be fine

BINARY UPDATE LOG
The binary update log is NOT enabled.
You will not be able to do point in time recovery
See http://dev.mysql.com/doc/refman/10.3/en/point-in-time-recovery.html

WORKER THREADS
Current thread_cache_size = 4
Current threads_cached = 1
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine

MAX CONNECTIONS
Current max_connections = 40
Current threads_connected = 9
Historic max_used_connections = 10
The number of used connections is 25% of the configured maximum.
Your max_connections variable seems to be fine.

INNODB STATUS
Current InnoDB index space = 658 M
Current InnoDB data space = 7.33 G
Current InnoDB buffer pool free = 1 %
Current innodb_buffer_pool_size = 5.00 G
Depending on how much space your innodb indexes take up it may be safe
to increase this value to up to 2 / 3 of total system memory

MEMORY USAGE
Max Memory Ever Allocated : 5.19 G
Configured Max Per-thread Buffers : 692 M
Configured Max Global Buffers : 5.02 G
Configured Max Memory Limit : 5.70 G
Physical Memory : 11.62 G
Max memory limit seem to be within acceptable norms

KEY BUFFER
Current MyISAM index space = 78 M
Current key_buffer_size = 14 M
Key cache miss rate is 1 : 391
Key buffer free ratio = 9 %
You could increase key_buffer_size
It is safe to raise this up to 1/4 of total system memory;
assuming this is a dedicated database server.

QUERY CACHE
Query cache is supported but not enabled
Perhaps you should set the query_cache_size                                                                                                     

SORT OPERATIONS
Current sort_buffer_size = 10 M
Current read_rnd_buffer_size = 4 M
Sort buffer seems to be fine

JOINS
Current join_buffer_size = 3.00 M
You have had 0 queries where a join could not use an index properly
Your joins seem to be using indexes properly

OPEN FILES LIMIT
Current open_files_limit = 4171 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine

TABLE CACHE
Current table_open_cache = 2048 tables
Current table_definition_cache = 400 tables
You have a total of 179 tables
You have 428 open tables.
The table_cache value seems to be fine

TEMP TABLES
Current max_heap_table_size = 512 M
Current tmp_table_size = 512 M
Of 44462 temp tables, 4% were created on disk
Created disk tmp tables ratio seems fine

TABLE SCANS
Current read_buffer_size = 128 K
Current table scan ratio = 18 : 1
read_buffer_size seems to be fine

TABLE LOCKING
Current Lock Wait ratio = 0 : 12744402
Your table locking seems to be fine