I have encountered a problem for quite long time, but got no idea what is the root cause
the "Thread cache hit rate" and "Innodb index hit rate" keeps reaching 100%, my configuration is thread_cache_size = 2G and innodb_buffer_pool_size = 2G already.
the phpmyadmin usually logged out continously like every 2-3 minutes.
this is the sql log,
`2021-09-26 1:49:10 2880 [Warning] Aborted connection 2880 to db: 'video_stream_net' user: 'video_stream_net' host: 'localhost' (Got an error reading communication packets)
2021-09-26 1:50:10 2985 [Warning] Aborted connection 2985 to db: 'video_animedono' user: 'video_animedono' host: 'localhost' (Got an error reading communication packets)
2021-09-26 1:59:55 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2021-09-26 1:59:55 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-09-26 1:59:55 0 [Note] InnoDB: FTS optimize thread exiting.
2021-09-26 1:59:55 0 [Note] InnoDB: Starting shutdown...
2021-09-26 1:59:55 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2021-09-26 1:59:55 0 [Note] InnoDB: Buffer pool(s) dump completed at 210926 1:59:55
2021-09-26 1:59:57 0 [Note] InnoDB: Shutdown completed; log sequence number 14642893499; transaction id 4133803
2021-09-26 1:59:57 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-09-26 1:59:57 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete
2021-09-26 1:59:58 0 [Note] InnoDB: Using Linux native AIO
2021-09-26 1:59:58 0 [Note] InnoDB: Uses event mutexes
2021-09-26 1:59:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-26 1:59:58 0 [Note] InnoDB: Number of pools: 1
2021-09-26 1:59:58 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
2021-09-26 1:59:58 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2021-09-26 1:59:58 0 [Note] InnoDB: Initializing buffer pool, total size = 25232932864, chunk size = 134217728
2021-09-26 1:59:58 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-26 1:59:58 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-09-26 1:59:58 0 [Note] InnoDB: 128 rollback segments are active.
2021-09-26 1:59:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-26 1:59:58 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-26 1:59:58 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2021-09-26 1:59:58 0 [Note] InnoDB: 10.5.6 started; log sequence number 14642893499; transaction id 4133805
2021-09-26 1:59:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-26 1:59:58 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2021-09-26 1:59:58 0 [Note] Server socket created on IP: '::'.
2021-09-26 1:59:58 0 [Note] Reading of all Master_info entries succeeded
2021-09-26 1:59:58 0 [Note] Added new Master_info '' to hash table
2021-09-26 1:59:58 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.5.6-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2021-09-26 1:59:59 0 [Note] InnoDB: Buffer pool(s) load completed at 210926 1:59:59
2021-09-26 1:59:59 6 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2021-09-26 2:01:38 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2021-09-26 2:01:38 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-09-26 2:01:38 0 [Note] InnoDB: FTS optimize thread exiting.
2021-09-26 2:01:38 0 [Note] InnoDB: Starting shutdown...
2021-09-26 2:01:38 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2021-09-26 2:01:38 0 [Note] InnoDB: Buffer pool(s) dump completed at 210926 2:01:38
2021-09-26 2:01:40 0 [Note] InnoDB: Shutdown completed; log sequence number 14643951558; transaction id 4134200
2021-09-26 2:01:40 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-09-26 2:01:40 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete`
can someone please help to resolve this problem