Dmitry

Implementation of the first stage of automatic application of the config. Implemented application of the config when running the script with the "-a" parameter.

InnoDB flush log at each commit should be disabled innodb_flush_log_at_trx_commit = 0

"DiskIO":null,"FileSystem":null,"IOP":{"IOPRead":0,"IOPWrite":0},

Many events on restart

1

The Releem portal displays many events when the MySQL service is restarted. 

The agent is marked as disabled 20 minutes after data acquisition is stopped. During this period, the user can set a task for an apply that will not be completed.

environment: line 47: crontab: command not found and not show support message

MySQL restart termination

2

The MariaDB service has a stop timeout of 900 seconds. A termination error may occur in a large database mariadb.service: State 'stop-sigterm' timed out. Skipping SIGKILL.

Query optimization is not performed

1

releem-agent[9353]: ERROR : [Worker] - 2024/10/09 06:31:39 runner.go:129: Error 1055 (42000): Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'performance_schema.events_statements_history.SQL_TEXT' which is not...

Index creation error

1

CREATE INDEX idx_order_item_name ON wp_woocommerce_order_items(order_item_name) ALGORITHM=INPLACE LOCK=NONE MariaDB server says: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY