Hi, after enable Wordpress URL Rewrite my cpu usage instantly increased 100% with the following code: location / { try_files $uri $uri/ /index.php?$args; } rewrite /wp-admin$ $scheme://$host$uri/ permanent; if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } Can help please? I will pay for it, really urgent.

Update, i got error from php: [03-Jan-2023 23:02:18] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are 15 idle, and 25 total children and this is my FPM setting: pm.max_children = 1000 pm.start_servers = 100 pm.min_spare_servers = 100 pm.max_spare_servers = 250 if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } and my CPU sometime still hit up to 95%, any suggestion? My VPS Spec is 10 Core, 32GB RAM. Should i choose PHP-FPM mode as Static or Dynamic?

My CPU 100% usage after enable Wordpress URL Rewrite, Help Please

x3inspire

Hi, after enable Wordpress URL Rewrite my cpu usage instantly increased 100% with the following code:

location /
{
	 try_files $uri $uri/ /index.php?$args;
}

rewrite /wp-admin$ $scheme://$host$uri/ permanent;

Can help please? I will pay for it, really urgent.

aaPanel_Kern

x3inspire
Hello, use htop/top to check which program is using cpu in real time
You are advised to check whether the cpu usage is caused by wordpress plug-ins.
Or check to see if they've been attacked?

x3inspire

Update, i got error from php:

[03-Jan-2023 23:02:18] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are 15 idle, and 25 total children

and this is my FPM setting:

pm.max_children = 1000
pm.start_servers = 100
pm.min_spare_servers = 100
pm.max_spare_servers = 250

and my CPU sometime still hit up to 95%, any suggestion?

My VPS Spec is 10 Core, 32GB RAM. Should i choose PHP-FPM mode as Static or Dynamic?

x3inspire

aaPanel_Kern

Hi,

https://prnt.sc/ibhzEHilPWxK

It show MariaDB, if i disable .htaccess my CPU became normal but all my pages return 404 error.

aaPanel_Kern

x3inspire
Hello, you use openlitespeed, the rules are the rules of nginx?
Check what causes the slow log of the database. You can also use phpmyadmin to check the process of the database

x3inspire

aaPanel_Kern

I tried everything, from nginx to litespeed.

Both high cpu usage, when i use LiteSpeed .htaccess generated automatically. With nginx, i use URL Rewrite.

Can you take a look please? I will pay for it.

aaPanel_Kern

x3inspire
This is a problem of database occupation. It is recommended to check the slow log of the database and the process inside the database first.

x3inspire

aaPanel_Kern

You mean this log?

`230104 12:23:27 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 12:23:27 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 12:23:27 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 53637 ...
2023-01-04 12:23:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 12:23:27 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 12:23:27 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 12:23:27 0 [Note] InnoDB: Initializing buffer pool, total size = 2147483648, chunk size = 134217728
2023-01-04 12:23:27 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 12:23:27 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 12:23:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 12:23:27 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 12:23:27 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 12:23:27 0 [Note] InnoDB: 10.7.3 started; log sequence number 41367; transaction id 14
2023-01-04 12:23:27 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 12:23:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 12:23:27 0 [Note] InnoDB: Buffer pool(s) load completed at 230104 12:23:27
2023-01-04 12:23:27 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-01-04 12:23:27 0 [Note] Server socket created on IP: '::'.
2023-01-04 12:23:27 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-04 12:23:34 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2023-01-04 12:23:34 0 [Note] InnoDB: FTS optimize thread exiting.
2023-01-04 12:23:34 0 [Note] InnoDB: Starting shutdown...
2023-01-04 12:23:34 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2023-01-04 12:23:34 0 [Note] InnoDB: Buffer pool(s) dump completed at 230104 12:23:34
2023-01-04 12:23:34 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2023-01-04 12:23:34 0 [Note] InnoDB: Shutdown completed; log sequence number 42341; transaction id 15
2023-01-04 12:23:34 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete

230104 12:23:34 mysqld_safe mysqld from pid file /www/server/data/v2202212175510213473.pid ended
230104 12:23:35 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 12:23:35 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 12:23:35 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 54286 ...
2023-01-04 12:23:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 12:23:35 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 12:23:35 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 12:23:35 0 [Note] InnoDB: Initializing buffer pool, total size = 2147483648, chunk size = 134217728
2023-01-04 12:23:35 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 12:23:35 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 12:23:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 12:23:35 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 12:23:35 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 12:23:35 0 [Note] InnoDB: 10.7.3 started; log sequence number 42341; transaction id 14
2023-01-04 12:23:35 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 12:23:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 12:23:35 0 [Note] InnoDB: Buffer pool(s) load completed at 230104 12:23:35
2023-01-04 12:23:35 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-01-04 12:23:35 0 [Note] Server socket created on IP: '::'.
2023-01-04 12:23:35 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
230104 12:23:43 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 12:23:43 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 12:23:43 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 54734 ...
2023-01-04 12:23:43 0 [ERROR] mariadbd: Can't lock aria control file '/www/server/data/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
230104 12:23:45 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 12:23:45 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 12:23:45 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 55244 ...
2023-01-04 12:23:45 0 [ERROR] mariadbd: Can't lock aria control file '/www/server/data/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2023-01-04 12:23:56 11 [Warning] Aborted connection 11 to db: 'unconnected' user: 'unauthenticated' host: 'v2202212175510213473.yourvserver.net' (This connection closed normally without authentication)
2023-01-04 12:24:13 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/www/server/data/aria_log_control'
2023-01-04 12:24:13 0 [ERROR] Plugin 'Aria' init function returned error.
2023-01-04 12:24:13 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2023-01-04 12:24:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 12:24:13 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 12:24:13 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 12:24:13 0 [Note] InnoDB: Initializing buffer pool, total size = 2147483648, chunk size = 134217728
2023-01-04 12:24:13 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 12:24:13 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42341,42341
2023-01-04 12:24:13 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 12:24:13 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2023-01-04 12:24:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 12:24:13 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 12:24:13 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 12:24:13 0 [Note] InnoDB: 10.7.3 started; log sequence number 42353; transaction id 14
2023-01-04 12:24:13 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 12:24:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 12:24:13 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
2023-01-04 12:24:13 0 [ERROR] Failed to initialize plugins.
2023-01-04 12:24:13 0 [ERROR] Aborting
2023-01-04 12:24:15 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/www/server/data/aria_log_control'
2023-01-04 12:24:15 0 [ERROR] Plugin 'Aria' init function returned error.
2023-01-04 12:24:15 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2023-01-04 12:24:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 12:24:15 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 12:24:15 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 12:24:15 0 [Note] InnoDB: Initializing buffer pool, total size = 2147483648, chunk size = 134217728
2023-01-04 12:24:15 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 12:24:15 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 12:24:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 12:24:15 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 12:24:15 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 12:24:15 0 [Note] InnoDB: 10.7.3 started; log sequence number 42365; transaction id 14
2023-01-04 12:24:15 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 12:24:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 12:24:15 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
2023-01-04 12:24:15 0 [ERROR] Failed to initialize plugins.
2023-01-04 12:24:15 0 [ERROR] Aborting
230104 12:24:16 mysqld_safe mysqld from pid file /www/server/data/v2202212175510213473.pid ended
2023-01-04 12:32:12 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2023-01-04 12:32:12 0 [Note] InnoDB: FTS optimize thread exiting.
2023-01-04 12:32:12 0 [Note] InnoDB: Starting shutdown...
2023-01-04 12:32:12 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2023-01-04 12:32:12 0 [Note] InnoDB: Buffer pool(s) dump completed at 230104 12:32:12
2023-01-04 12:32:12 0 [Note] InnoDB: Shutdown completed; log sequence number 42513; transaction id 16
2023-01-04 12:32:12 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete

230104 12:32:25 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 12:32:25 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 12:32:25 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 1393 ...
2023-01-04 12:32:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 12:32:25 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 12:32:25 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 12:32:25 0 [Note] InnoDB: Initializing buffer pool, total size = 2147483648, chunk size = 134217728
2023-01-04 12:32:25 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 12:32:25 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 12:32:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 12:32:25 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 12:32:25 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 12:32:25 0 [Note] InnoDB: 10.7.3 started; log sequence number 42513; transaction id 14
2023-01-04 12:32:25 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 12:32:25 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 12:32:25 0 [Note] InnoDB: Buffer pool(s) load completed at 230104 12:32:25
2023-01-04 12:32:25 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-01-04 12:32:25 0 [Note] Server socket created on IP: '::'.
2023-01-04 12:32:25 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-04 12:33:58 5 [Warning] Aborted connection 5 to db: 'unconnected' user: 'unauthenticated' host: 'v2202212175510213473.yourvserver.net' (This connection closed normally without authentication)
2023-01-04 12:35:19 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2023-01-04 12:35:19 0 [Note] InnoDB: FTS optimize thread exiting.
2023-01-04 12:35:19 0 [Note] InnoDB: Starting shutdown...
2023-01-04 12:35:19 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2023-01-04 12:35:19 0 [Note] InnoDB: Buffer pool(s) dump completed at 230104 12:35:19
2023-01-04 12:35:19 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2023-01-04 12:35:19 0 [Note] InnoDB: Shutdown completed; log sequence number 42525; transaction id 15
2023-01-04 12:35:19 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete

230104 12:35:19 mysqld_safe mysqld from pid file /www/server/data/v2202212175510213473.pid ended
230104 12:35:20 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 12:35:20 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 12:35:20 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 2566 ...
2023-01-04 12:35:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 12:35:20 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 12:35:20 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 12:35:20 0 [Note] InnoDB: Initializing buffer pool, total size = 1073741824, chunk size = 134217728
2023-01-04 12:35:20 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 12:35:20 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 12:35:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 12:35:20 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 12:35:20 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 12:35:20 0 [Note] InnoDB: 10.7.3 started; log sequence number 42525; transaction id 14
2023-01-04 12:35:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 12:35:20 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 12:35:20 0 [Note] InnoDB: Buffer pool(s) load completed at 230104 12:35:20
2023-01-04 12:35:20 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-01-04 12:35:20 0 [Note] Server socket created on IP: '::'.
2023-01-04 12:35:20 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-04 12:44:58 11 [Warning] Access denied for user 'root'@'localhost'
2023-01-04 12:45:24 15 [Warning] Access denied for user 'n5h62nkZbAcnpbWs'@'localhost'
2023-01-04 12:45:29 16 [Warning] Access denied for user 'root'@'localhost'
2023-01-04 12:46:04 9 [Warning] Aborted connection 9 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2023-01-04 12:46:04 13 [Warning] Aborted connection 13 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2023-01-04 12:46:09 17 [Warning] Access denied for user 'root'@'localhost'

Status information:

Current dir: /www/server/data/
Running threads: 0 Cached threads: 3 Stack size: 393216

Key caches:
default
Buffer_size: 536870912
Block_size: 1024
Division_limit: 100
Age_threshold: 300
Partitions: 0
blocks used: 0
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0

handler status:
read_key: 8
read_next: 3
read_rnd 0
read_first: 8
write: 0
delete 0
update: 0

Table status:
Opened tables: 19
Open tables: 13
Open files: 32
Open streams: 4

Alarm status:
Active alarms: 0
Max used alarms: 0
Next alarm time: 0

Memory status:
Non-mmapped space allocated from system: 18931712
Number of free chunks: 81
Number of fastbin blocks: 22
Number of mmapped regions: 14
Space in mmapped regions: 398139392
Maximum total allocated space: 0
Space available in freed fastbin blocks: 1104
Total allocated space: 8204624
Total free space: 10727088
Top-most, releasable space: 25216
Estimated memory (with thread stack): 418250752
Global memory allocated by server: 377071552
Memory allocated by threads: 0

Events status:
LLA = Last Locked At LUA = Last Unlocked At
WOC = Waiting On Condition DL = Data Locked

Event scheduler status:
State : INITIALIZED
Thread id : 0
LLA : n/a:0
LUA : n/a:0
WOC : NO
Workers : 0
Executed : 0
Data locked: NO

Event queue status:
Element count : 0
Data locked : NO
Attempting lock : NO
LLA : init_queue:141
LUA : init_queue:151
WOC : NO
Next activation : never
2023-01-04 12:49:45 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2023-01-04 12:49:45 0 [Note] InnoDB: FTS optimize thread exiting.
2023-01-04 12:49:45 0 [Note] InnoDB: Starting shutdown...
2023-01-04 12:49:45 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2023-01-04 12:49:45 0 [Note] InnoDB: Buffer pool(s) dump completed at 230104 12:49:45
2023-01-04 12:49:46 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2023-01-04 12:49:46 0 [Note] InnoDB: Shutdown completed; log sequence number 42537; transaction id 15
2023-01-04 12:49:46 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete

230104 12:49:46 mysqld_safe mysqld from pid file /www/server/data/v2202212175510213473.pid ended
230104 12:49:47 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 12:49:47 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 12:49:47 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 30053 ...
2023-01-04 12:49:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 12:49:47 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 12:49:47 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 12:49:47 0 [Note] InnoDB: Initializing buffer pool, total size = 1073741824, chunk size = 134217728
2023-01-04 12:49:47 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 12:49:47 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 12:49:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 12:49:47 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 12:49:47 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 12:49:47 0 [Note] InnoDB: 10.7.3 started; log sequence number 42537; transaction id 14
2023-01-04 12:49:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 12:49:47 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 12:49:47 0 [Note] InnoDB: Buffer pool(s) load completed at 230104 12:49:47
2023-01-04 12:49:47 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-01-04 12:49:47 0 [Note] Server socket created on IP: '::'.
2023-01-04 12:49:47 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-04 12:49:56 5 [Warning] Access denied for user 'root'@'localhost'
2023-01-04 12:51:59 10 [Warning] Access denied for user 'root'@'localhost'
2023-01-04 12:53:40 11 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2023-01-04 12:53:59 13 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2023-01-04 12:54:08 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2023-01-04 12:55:52 52 [Warning] Aborted connection 52 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2023-01-04 12:55:52 54 [Warning] Aborted connection 54 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2023-01-04 12:56:36 66 [Warning] Access denied for user 'ustream'@'localhost'
2023-01-04 15:37:38 7749 [Warning] Aborted connection 7749 to db: 'unconnected' user: 'unauthenticated' host: 'v2202212175510213473.yourvserver.net' (This connection closed normally without authentication)
2023-01-04 15:48:53 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2023-01-04 15:48:53 0 [Note] InnoDB: FTS optimize thread exiting.
2023-01-04 15:48:53 0 [Note] InnoDB: Starting shutdown...
2023-01-04 15:48:53 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2023-01-04 15:48:53 0 [Note] InnoDB: Restricted to 16224 pages due to innodb_buf_pool_dump_pct=25
2023-01-04 15:48:53 0 [Note] InnoDB: Buffer pool(s) dump completed at 230104 15:48:53
2023-01-04 15:48:55 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2023-01-04 15:48:55 0 [Note] InnoDB: Shutdown completed; log sequence number 2401366580; transaction id 34179
2023-01-04 15:48:55 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete

230104 15:48:55 mysqld_safe mysqld from pid file /www/server/data/v2202212175510213473.pid ended
230104 15:49:12 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 15:49:12 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 15:49:12 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 1416 ...
2023-01-04 15:49:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 15:49:13 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 15:49:13 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 15:49:13 0 [Note] InnoDB: Initializing buffer pool, total size = 1073741824, chunk size = 134217728
2023-01-04 15:49:13 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 15:49:13 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 15:49:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 15:49:13 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 15:49:13 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 15:49:13 0 [Note] InnoDB: 10.7.3 started; log sequence number 2401366580; transaction id 34180
2023-01-04 15:49:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 15:49:13 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 15:49:13 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-01-04 15:49:13 0 [Note] Server socket created on IP: '::'.
2023-01-04 15:49:13 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-04 15:49:13 21 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2023-01-04 15:49:15 0 [Note] InnoDB: Buffer pool(s) load completed at 230104 15:49:15
2023-01-04 15:51:17 1573 [Warning] Aborted connection 1573 to db: 'unconnected' user: 'unauthenticated' host: 'v2202212175510213473.yourvserver.net' (This connection closed normally without authentication)
2023-01-04 16:02:14 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2023-01-04 16:02:14 0 [Note] InnoDB: FTS optimize thread exiting.
2023-01-04 16:02:14 0 [Note] InnoDB: Starting shutdown...
2023-01-04 16:02:14 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2023-01-04 16:02:14 0 [Note] InnoDB: Restricted to 16224 pages due to innodb_buf_pool_dump_pct=25
2023-01-04 16:02:14 0 [Note] InnoDB: Buffer pool(s) dump completed at 230104 16:02:14
2023-01-04 16:02:14 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2023-01-04 16:02:14 0 [Note] InnoDB: Shutdown completed; log sequence number 2403268781; transaction id 38177
2023-01-04 16:02:14 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete

230104 16:02:14 mysqld_safe mysqld from pid file /www/server/data/v2202212175510213473.pid ended
230104 16:02:15 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 16:02:15 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 16:02:15 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 4847 ...
2023-01-04 16:02:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 16:02:15 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 16:02:15 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 16:02:15 0 [Note] InnoDB: Initializing buffer pool, total size = 1073741824, chunk size = 134217728
2023-01-04 16:02:15 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 16:02:15 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 16:02:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 16:02:15 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 16:02:15 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 16:02:15 0 [Note] InnoDB: 10.7.3 started; log sequence number 2403268781; transaction id 38178
2023-01-04 16:02:15 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 16:02:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 16:02:15 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-01-04 16:02:15 0 [Note] Server socket created on IP: '::'.
2023-01-04 16:02:15 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-04 16:02:16 0 [Note] InnoDB: Buffer pool(s) load completed at 230104 16:02:16
2023-01-04 16:02:16 35 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2023-01-04 16:05:24 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2023-01-04 16:05:24 0 [Note] InnoDB: FTS optimize thread exiting.
2023-01-04 16:05:24 0 [Note] InnoDB: Starting shutdown...
2023-01-04 16:05:24 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2023-01-04 16:05:24 0 [Note] InnoDB: Restricted to 16224 pages due to innodb_buf_pool_dump_pct=25
2023-01-04 16:05:24 0 [Note] InnoDB: Buffer pool(s) dump completed at 230104 16:05:24
2023-01-04 16:05:24 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2023-01-04 16:05:24 0 [Note] InnoDB: Shutdown completed; log sequence number 2403843818; transaction id 39282
2023-01-04 16:05:24 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete

230104 16:05:24 mysqld_safe mysqld from pid file /www/server/data/v2202212175510213473.pid ended
230104 16:05:25 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 16:05:25 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 16:05:25 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 6356 ...
2023-01-04 16:05:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 16:05:25 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 16:05:25 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 16:05:25 0 [Note] InnoDB: Initializing buffer pool, total size = 1073741824, chunk size = 134217728
2023-01-04 16:05:25 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 16:05:26 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 16:05:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 16:05:26 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 16:05:26 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 16:05:26 0 [Note] InnoDB: 10.7.3 started; log sequence number 2403843818; transaction id 39283
2023-01-04 16:05:26 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 16:05:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 16:05:26 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-01-04 16:05:26 0 [Note] Server socket created on IP: '::'.
2023-01-04 16:05:26 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-04 16:05:26 36 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2023-01-04 16:05:26 0 [Note] InnoDB: Buffer pool(s) load completed at 230104 16:05:26
2023-01-04 16:06:05 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2023-01-04 16:06:05 0 [Note] InnoDB: FTS optimize thread exiting.
2023-01-04 16:06:05 0 [Note] InnoDB: Starting shutdown...
2023-01-04 16:06:05 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2023-01-04 16:06:05 0 [Note] InnoDB: Restricted to 16224 pages due to innodb_buf_pool_dump_pct=25
2023-01-04 16:06:05 0 [Note] InnoDB: Buffer pool(s) dump completed at 230104 16:06:05
2023-01-04 16:06:05 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2023-01-04 16:06:05 0 [Note] InnoDB: Shutdown completed; log sequence number 2403874874; transaction id 39390
2023-01-04 16:06:05 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete

230104 16:06:05 mysqld_safe mysqld from pid file /www/server/data/v2202212175510213473.pid ended
230104 16:07:51 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 16:07:51 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 16:07:51 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 1481 ...
2023-01-04 16:07:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 16:07:51 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 16:07:51 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 16:07:51 0 [Note] InnoDB: Initializing buffer pool, total size = 1073741824, chunk size = 134217728
2023-01-04 16:07:51 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 16:07:51 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 16:07:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 16:07:51 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 16:07:51 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 16:07:51 0 [Note] InnoDB: 10.7.3 started; log sequence number 2403874874; transaction id 39391
2023-01-04 16:07:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 16:07:51 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 16:07:51 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-01-04 16:07:51 0 [Note] Server socket created on IP: '::'.
2023-01-04 16:07:51 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-04 16:07:52 30 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2023-01-04 16:07:54 0 [Note] InnoDB: Buffer pool(s) load completed at 230104 16:07:54
2023-01-04 16:08:08 175 [Warning] Aborted connection 175 to db: 'unconnected' user: 'unauthenticated' host: 'v2202212175510213473.yourvserver.net' (This connection closed normally without authentication)
2023-01-04 16:12:27 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2023-01-04 16:12:27 0 [Note] InnoDB: FTS optimize thread exiting.
2023-01-04 16:12:27 0 [Note] InnoDB: Starting shutdown...
2023-01-04 16:12:27 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2023-01-04 16:12:27 0 [Note] InnoDB: Restricted to 16224 pages due to innodb_buf_pool_dump_pct=25
2023-01-04 16:12:27 0 [Note] InnoDB: Buffer pool(s) dump completed at 230104 16:12:27
2023-01-04 16:12:28 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2023-01-04 16:12:28 0 [Note] InnoDB: Shutdown completed; log sequence number 2404705379; transaction id 41169
2023-01-04 16:12:28 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete

230104 16:12:28 mysqld_safe mysqld from pid file /www/server/data/v2202212175510213473.pid ended
230104 16:12:28 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 16:12:28 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 16:12:28 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 3358 ...
2023-01-04 16:12:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 16:12:29 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 16:12:29 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 16:12:29 0 [Note] InnoDB: Initializing buffer pool, total size = 1073741824, chunk size = 134217728
2023-01-04 16:12:29 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 16:12:29 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 16:12:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 16:12:29 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 16:12:29 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 16:12:29 0 [Note] InnoDB: 10.7.3 started; log sequence number 2404705379; transaction id 41170
2023-01-04 16:12:29 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 16:12:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 16:12:29 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-01-04 16:12:29 0 [Note] Server socket created on IP: '::'.
2023-01-04 16:12:29 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-04 16:12:29 30 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2023-01-04 16:12:29 0 [Note] InnoDB: Buffer pool(s) load completed at 230104 16:12:29
2023-01-04 16:13:14 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2023-01-04 16:13:14 0 [Note] InnoDB: FTS optimize thread exiting.
2023-01-04 16:13:14 0 [Note] InnoDB: Starting shutdown...
2023-01-04 16:13:14 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2023-01-04 16:13:14 0 [Note] InnoDB: Restricted to 16224 pages due to innodb_buf_pool_dump_pct=25
2023-01-04 16:13:14 0 [Note] InnoDB: Buffer pool(s) dump completed at 230104 16:13:14
2023-01-04 16:13:14 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2023-01-04 16:13:14 0 [Note] InnoDB: Shutdown completed; log sequence number 2404910042; transaction id 41573
2023-01-04 16:13:14 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete

230104 16:13:14 mysqld_safe mysqld from pid file /www/server/data/v2202212175510213473.pid ended
230104 16:13:15 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 16:13:15 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 16:13:15 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 4180 ...
2023-01-04 16:13:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 16:13:15 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 16:13:15 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 16:13:15 0 [Note] InnoDB: Initializing buffer pool, total size = 1073741824, chunk size = 134217728
2023-01-04 16:13:15 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 16:13:15 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 16:13:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 16:13:15 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 16:13:15 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 16:13:15 0 [Note] InnoDB: 10.7.3 started; log sequence number 2404910042; transaction id 41574
2023-01-04 16:13:15 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 16:13:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 16:13:15 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-01-04 16:13:15 0 [Note] Server socket created on IP: '::'.
2023-01-04 16:13:15 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-04 16:13:16 31 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2023-01-04 16:13:16 0 [Note] InnoDB: Buffer pool(s) load completed at 230104 16:13:16
2023-01-04 16:18:27 0 [Note] /www/server/mysql/bin/mariadbd (initiated by: unknown): Normal shutdown
2023-01-04 16:18:27 0 [Note] InnoDB: FTS optimize thread exiting.
2023-01-04 16:18:27 0 [Note] InnoDB: Starting shutdown...
2023-01-04 16:18:27 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2023-01-04 16:18:27 0 [Note] InnoDB: Restricted to 16224 pages due to innodb_buf_pool_dump_pct=25
2023-01-04 16:18:27 0 [Note] InnoDB: Buffer pool(s) dump completed at 230104 16:18:27
2023-01-04 16:18:28 0 [Note] InnoDB: Removed temporary tablespace data file: "/www/server/data/ibtmp1"
2023-01-04 16:18:28 0 [Note] InnoDB: Shutdown completed; log sequence number 2405998239; transaction id 43807
2023-01-04 16:18:28 0 [Note] /www/server/mysql/bin/mariadbd: Shutdown complete

230104 16:18:28 mysqld_safe mysqld from pid file /www/server/data/v2202212175510213473.pid ended
230104 16:18:48 mysqld_safe Starting mariadbd daemon with databases from /www/server/data
2023-01-04 16:18:48 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-01-04 16:18:48 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 1480 ...
2023-01-04 16:18:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-01-04 16:18:48 0 [Note] InnoDB: Number of transaction pools: 1
2023-01-04 16:18:48 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-01-04 16:18:48 0 [Note] InnoDB: Initializing buffer pool, total size = 1073741824, chunk size = 134217728
2023-01-04 16:18:48 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 16:18:48 0 [Note] InnoDB: 128 rollback segments are active.
2023-01-04 16:18:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 16:18:48 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 16:18:48 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-01-04 16:18:48 0 [Note] InnoDB: 10.7.3 started; log sequence number 2405998239; transaction id 43808
2023-01-04 16:18:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 16:18:48 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-01-04 16:18:48 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-01-04 16:18:48 0 [Note] Server socket created on IP: '::'.
2023-01-04 16:18:48 0 [Note] /www/server/mysql/bin/mariadbd: ready for connections.
Version: '10.7.3-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2023-01-04 16:18:49 5 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2023-01-04 16:18:49 0 [Note] InnoDB: Buffer pool(s) load completed at 230104 16:18:49
2023-01-04 16:22:09 150 [Warning] Aborted connection 150 to db: 'unconnected' user: 'unauthenticated' host: 'v2202212175510213473.yourvserver.net' (This connection closed normally without authentication)`

aaPanel_Kern

x3inspire

Slow log

x3inspire

aaPanel_Kern

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'ids' AND wp_postmeta.meta_value = '94796' )
AND
( mt1.meta_key = 'temporada' AND mt1.meta_value = '1' )
AND
( mt2.meta_key = 'episodio' AND mt2.meta_value = '1' )
) AND wp_posts.post_type = 'episodes' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 1;

User@Host: root[root] @ localhost []

Thread_id: 18708 Schema: ustream QC_hit: No

Query_time: 6.487243 Lock_time: 0.000132 Rows_sent: 1 Rows_examined: 261353

Rows_affected: 0 Bytes_sent: 87

SET timestamp=1672833903;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'ids' AND wp_postmeta.meta_value = '88396' )
AND
( mt1.meta_key = 'temporada' AND mt1.meta_value = '1' )
AND
( mt2.meta_key = 'episodio' AND mt2.meta_value = '2' )
) AND wp_posts.post_type = 'episodes' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 1;

User@Host: root[root] @ localhost []

Thread_id: 18726 Schema: ustream QC_hit: No

Query_time: 3.807669 Lock_time: 0.000072 Rows_sent: 1 Rows_examined: 165971

Rows_affected: 0 Bytes_sent: 87

SET timestamp=1672833903;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'ids' AND wp_postmeta.meta_value = '18165' )
AND
( mt1.meta_key = 'temporada' AND mt1.meta_value = '5' )
AND
( mt2.meta_key = 'episodio' AND mt2.meta_value = '10' )
) AND wp_posts.post_type = 'episodes' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 1;

User@Host: root[root] @ localhost []

Thread_id: 18616 Schema: ustream QC_hit: No

Query_time: 5.883472 Lock_time: 0.000152 Rows_sent: 1 Rows_examined: 260927

Rows_affected: 0 Bytes_sent: 87

SET timestamp=1672833903;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'ids' AND wp_postmeta.meta_value = '96481' )
AND
( mt1.meta_key = 'temporada' AND mt1.meta_value = '1' )
AND
( mt2.meta_key = 'episodio' AND mt2.meta_value = '3' )
) AND wp_posts.post_type = 'episodes' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 1;

Time: 230104 20:05:04

User@Host: root[root] @ localhost []

Thread_id: 18649 Schema: ustream QC_hit: No

Query_time: 5.842515 Lock_time: 0.000146 Rows_sent: 1 Rows_examined: 253991

Rows_affected: 0 Bytes_sent: 86

SET timestamp=1672833904;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'ids' AND wp_postmeta.meta_value = '66732' )
AND
( mt1.meta_key = 'temporada' AND mt1.meta_value = '1' )
AND
( mt2.meta_key = 'episodio' AND mt2.meta_value = '5' )
) AND wp_posts.post_type = 'episodes' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 1;

Time: 230104 20:05:05

User@Host: root[root] @ localhost []

Thread_id: 18679 Schema: ustream QC_hit: No

Query_time: 4.737722 Lock_time: 0.000089 Rows_sent: 1 Rows_examined: 210155

Rows_affected: 0 Bytes_sent: 87

SET timestamp=1672833905;
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'ids' AND wp_postmeta.meta_value = '85937' )
AND
( mt1.meta_key = 'temporada' AND mt1.meta_value = '2' )
AND
( mt2.meta_key = 'episodio' AND mt2.meta_value = '6' )
) AND wp_posts.post_type = 'episodes' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 1;

aaPanel_Kern

It is recommended to use phpmyadmin to check the process first and check if there is any abnormality

x3inspire

aaPanel_Kern
Can i get the step please?

aaPanel_Kern

x3inspire
Hello, is your problem solved? Open phpmyadmin and use the root user to log in to view the status

x3inspire

aaPanel_Kern
sometime still happen.

aaPanel_Kern

x3inspire
Hello, I suggest you continue to check what causes the problem.