MySQL to peak load CPU

[thejvmshid]

Hi everyone!
I have a next problem:
In idle mode, the MySQL daemon is very CPU intensive

Additional information:
MySQL Process List:

[root@sj45s MySQLTuner-perl-master]# ./mysqltuner.pl

[–] Skipped version check for MySQLTuner script
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password: [OK] Currently running supported MySQL version 8.0.18
[OK] Operating on 64-bit architecture

-------- Log file Recommendations ------------------------------------------------------------------
[OK] Log file /var/log/mysqld.log exists
[–] Log file: /var/log/mysqld.log(530K)
[OK] Log file /var/log/mysqld.log is readable.
[OK] Log file /var/log/mysqld.log is not empty
[OK] Log file /var/log/mysqld.log is smaller than 32 Mb
[!!] /var/log/mysqld.log contains 1585 warning(s).
[!!] /var/log/mysqld.log contains 862 error(s).
[–] 413 start(s) detected in /var/log/mysqld.log
[–] 1) 2019-10-26T12:17:44.921464Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: ‘/var/run/mysqld/mysqlx.sock’ bind-address: ‘::’ port: 33060
[–] 2) 2019-10-26T12:17:44.776177Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: ‘8.0.18’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MySQL Community Server - GPL.
[–] 3) 2019-10-26T12:16:19.723047Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: ‘/var/run/mysqld/mysqlx.sock’ bind-address: ‘::’ port: 33060
[–] 4) 2019-10-26T12:16:19.558177Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: ‘8.0.18’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MySQL Community Server - GPL.
[–] 5) 2019-10-26T12:14:59.664979Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: ‘/var/run/mysqld/mysqlx.sock’ bind-address: ‘::’ port: 33060
[–] 6) 2019-10-26T12:14:59.491282Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: ‘8.0.18’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MySQL Community Server - GPL.
[–] 7) 2019-10-26T12:14:18.197782Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: ‘/var/run/mysqld/mysqlx.sock’ bind-address: ‘::’ port: 33060
[–] 8) 2019-10-26T12:14:18.026779Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: ‘8.0.18’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MySQL Community Server - GPL.
[–] 9) 2019-10-26T12:13:40.540216Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: ‘/var/run/mysqld/mysqlx.sock’ bind-address: ‘::’ port: 33060
[–] 10) 2019-10-26T12:13:40.378904Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: ‘8.0.18’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MySQL Community Server - GPL.
[–] 238 shutdown(s) detected in /var/log/mysqld.log
[–] 1) 2019-10-26T12:17:42.977399Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
[–] 2) 2019-10-26T12:16:17.919112Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
[–] 3) 2019-10-26T12:14:54.453698Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
[–] 4) 2019-10-26T12:14:06.775113Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
[–] 5) 2019-10-26T12:13:38.738951Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
[–] 6) 2019-10-26T12:11:58.624939Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
[–] 7) 2019-10-26T12:10:59.435973Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
[–] 8) 2019-10-26T12:09:28.275158Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
[–] 9) 2019-10-26T12:07:00.885018Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
[–] 10) 2019-10-26T12:06:13.659242Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.

-------- Storage Engine Statistics -----------------------------------------------------------------
[–] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
[–] Data in InnoDB tables: 100.7M (Tables: 66)
[OK] Total fragmented tables: 0

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

-------- Security Recommendations ------------------------------------------------------------------
[–] Skipped due to unsupported feature for MySQL 8

-------- CVE Security Recommendations --------------------------------------------------------------
[OK] NO SECURITY CVE FOUND FOR YOUR VERSION

-------- Performance Metrics -----------------------------------------------------------------------
[–] Up for: 9m 25s (69K q [122.269 qps], 2K conn, TX: 50M, RX: 3M)
[–] Reads / Writes: 98% / 2%
[–] Binary logging is enabled (GTID MODE: OFF)
[–] Physical Memory : 3.6G
[–] Max MySQL memory : 2.7G
[–] Other process memory: 0B
[–] Total buffers: 296.0M global + 16.4M per thread (151 max threads)
[–] P_S Max memory usage: 72B
[–] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 492.8M (13.38% of installed RAM)
[OK] Maximum possible memory usage: 2.7G (75.28% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (0/69K)
[OK] Highest usage of available connections: 7% (12/151)
[OK] Aborted connections: 0.17% (4/2316)
[–] Query cache have been removed in MySQL 8
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 8 sorts)
[!!] Joins performed without indexes: 38
[OK] Temporary tables created on disk: 0% (0 on disk / 15 total)
[OK] Thread cache hit rate: 99% (12 created / 2K connections)
[OK] Table cache hit rate: 89% (682 open / 762 opened)
[OK] table_definition_cache(2000) is upper than number of tables(370)
[OK] Open file limit used: 0% (2/10K)
[OK] Table locks acquired immediately: 100% (8 immediate / 8 locks)
[OK] Binlog cache memory access: 100.00% (378 Memory / 378 Total)

-------- Performance schema ------------------------------------------------------------------------
[–] Memory used by P_S: 72B
[–] Sys schema is installed.

-------- ThreadPool Metrics ------------------------------------------------------------------------
[–] ThreadPool stat is disabled.

-------- MyISAM Metrics ----------------------------------------------------------------------------
[–] MyISAM Metrics are disabled on last MySQL versions.

-------- InnoDB Metrics ----------------------------------------------------------------------------
[–] InnoDB is enabled.
[–] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[OK] InnoDB buffer pool / data size: 256.0M/100.7M
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 32.0M * 2/256.0M should be equal to 25%
[OK] InnoDB buffer pool instances: 1
[–] Number of InnoDB Buffer Pool Chunk : 2 for 1 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: 100.00% (649604392 hits/ 649607586 total)
[!!] InnoDB Write Log efficiency: 51.01% (1665 hits/ 3264 total)
[OK] InnoDB log waits: 0.00% (0 waits / 1599 writes)

-------- AriaDB Metrics ----------------------------------------------------------------------------
[–] AriaDB is disabled.

-------- 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: ROW
[–] XA support enabled: ON
[–] Semi synchronous replication Master: Not Activated
[–] Semi synchronous replication Slave: Not Activated
[–] This is a standalone server

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
Control warning line(s) into /var/log/mysqld.log file
Control error line(s) into /var/log/mysqld.log file
MySQL was started within the last 24 hours - recommendations may be inaccurate
We will suggest raising the ‘join_buffer_size’ until JOINs not using indexes are found.
See https://dev.mysql.com/doc/internals/en/join-buffer-size.html
(specially the conclusions at the bottom of the page).
Variables to adjust:
join_buffer_size (> 12.0M, or always use indexes with JOINs)

MySQL config file:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#Logging
slow-query-log=1
slow-query-log-file=/var/log/slow-log
#MysqlTuner
skip-name-resolve=1
innodb_buffer_pool_size=1024M
innodb_log_file_size=256M
innodb_log_buffer_size=32M
innodb_flush_log_at_trx_commit=1
join_buffer_size=12M
sort_buffer_size=2M
read_buffer_size=2M
read_rnd_buffer_size=2M

Another situation:

I enable slow log and receive next:

SET timestamp=1572173531;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘0’ AND registry_group=‘gateway’ AND registry_family=‘generic’;
Time: 2019-10-27T10:52:11.814910Z
User@Host: playsms[playsms] @ localhost [] Id: 3046
Query_time: 0.000102 Lock_time: 0.000043 Rows_sent: 1 Rows_examined: 1

SET timestamp=1572173531;
SELECT * FROM playsms_gatewayInfobip_config;
Time: 2019-10-27T10:52:11.818170Z
User@Host: playsms[playsms] @ localhost [] Id: 3046
Query_time: 0.000237 Lock_time: 0.000063 Rows_sent: 0 Rows_examined: 204

SET timestamp=1572173531;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘0’ AND registry_group=‘gateway’ AND registry_family=‘jasmin’;
Time: 2019-10-27T10:52:11.822385Z
User@Host: playsms[playsms] @ localhost [] Id: 3046
Query_time: 0.000233 Lock_time: 0.000050 Rows_sent: 14 Rows_examined: 204

SET timestamp=1572173531;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘gateway’ AND registry_family=‘kannel’;
Time: 2019-10-27T10:52:11.826532Z
User@Host: playsms[playsms] @ localhost [] Id: 3046
Query_time: 0.000104 Lock_time: 0.000054 Rows_sent: 1 Rows_examined: 1

SET timestamp=1572173531;
SELECT * FROM playsms_gatewayNexmo_config;
Time: 2019-10-27T10:52:11.829699Z
User@Host: playsms[playsms] @ localhost [] Id: 3046
Query_time: 0.000227 Lock_time: 0.000050 Rows_sent: 0 Rows_examined: 204

SET timestamp=1572173531;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘gateway’ AND registry_family=‘openvox’;
Time: 2019-10-27T10:52:11.834488Z
User@Host: playsms[playsms] @ localhost [] Id: 3046
Query_time: 0.000237 Lock_time: 0.000049 Rows_sent: 0 Rows_examined: 204

SET timestamp=1572173531;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘0’ AND registry_group=‘gateway’ AND registry_family=‘playnet’;
Time: 2019-10-27T10:52:11.839124Z
User@Host: playsms[playsms] @ localhost [] Id: 3046
Query_time: 0.000247 Lock_time: 0.000049 Rows_sent: 0 Rows_examined: 204

SET timestamp=1572173531;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘0’ AND registry_group=‘gateway’ AND registry_family=‘smstools’;
Time: 2019-10-27T10:52:11.843307Z
User@Host: playsms[playsms] @ localhost [] Id: 3046
Query_time: 0.000101 Lock_time: 0.000041 Rows_sent: 1 Rows_examined: 1

SET timestamp=1572173531;
SELECT * FROM playsms_gatewayTelerivet_config;
Time: 2019-10-27T10:52:11.846369Z
User@Host: playsms[playsms] @ localhost [] Id: 3046
Query_time: 0.000092 Lock_time: 0.000042 Rows_sent: 1 Rows_examined: 1

SET timestamp=1572173531;
SELECT * FROM playsms_gatewayTwilio_config;
Time: 2019-10-27T10:52:11.849413Z
User@Host: playsms[playsms] @ localhost [] Id: 3046
Query_time: 0.000094 Lock_time: 0.000040 Rows_sent: 1 Rows_examined: 1

SET timestamp=1572173531;
SELECT * FROM playsms_gatewayUplink_config;
Time: 2019-10-27T10:52:11.868963Z
User@Host: playsms[playsms] @ localhost [] Id: 3046
Query_time: 0.000106 Lock_time: 0.000040 Rows_sent: 10 Rows_examined: 10

SET timestamp=1572173531;
SELECT * FROM playsms_tblGateway;
Time: 2019-10-27T10:52:12.199881Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.000916 Lock_time: 0.000255 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173532;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:12.206367Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.000282 Lock_time: 0.000101 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173532;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:12.282250Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.072363 Lock_time: 0.000128 Rows_sent: 0 Rows_examined: 256513

SET timestamp=1572173532;
SELECT * FROM playsms_tblDLR WHERE flag_processed=‘1’ LIMIT 1000;
Time: 2019-10-27T10:52:12.288912Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.000160 Lock_time: 0.000063 Rows_sent: 10 Rows_examined: 10

SET timestamp=1572173532;
SELECT * FROM playsms_tblGateway;
Time: 2019-10-27T10:52:12.308347Z
User@Host: playsms[playsms] @ localhost [] Id: 3048
Query_time: 0.000457 Lock_time: 0.000110 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173532;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:12.309335Z
User@Host: playsms[playsms] @ localhost [] Id: 3048
Query_time: 0.000203 Lock_time: 0.000075 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173532;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:12.314384Z
User@Host: playsms[playsms] @ localhost [] Id: 3048
Query_time: 0.004721 Lock_time: 0.000074 Rows_sent: 0 Rows_examined: 4860

SET timestamp=1572173532;
SELECT * FROM playsms_tblRecvSMS WHERE flag_processed=‘1’ LIMIT 1000;
Time: 2019-10-27T10:52:12.314946Z
User@Host: playsms[playsms] @ localhost [] Id: 3048
Query_time: 0.000149 Lock_time: 0.000056 Rows_sent: 10 Rows_examined: 10

SET timestamp=1572173532;
SELECT * FROM playsms_tblGateway;
Time: 2019-10-27T10:52:12.323777Z
User@Host: playsms[playsms] @ localhost [] Id: 3049
Query_time: 0.000286 Lock_time: 0.000062 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173532;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:12.327979Z
User@Host: playsms[playsms] @ localhost [] Id: 3049
Query_time: 0.000137 Lock_time: 0.000051 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173532;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:12.331522Z
User@Host: playsms[playsms] @ localhost [] Id: 3049
Query_time: 0.000251 Lock_time: 0.000052 Rows_sent: 0 Rows_examined: 204

SET timestamp=1572173532;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘0’ AND registry_group=‘features’ AND registry_family=‘mailsms’;
Time: 2019-10-27T10:52:12.335521Z
User@Host: playsms[playsms] @ localhost [] Id: 3049
Query_time: 0.000114 Lock_time: 0.000038 Rows_sent: 10 Rows_examined: 10

SET timestamp=1572173532;
SELECT * FROM playsms_tblGateway;
Time: 2019-10-27T10:52:12.445301Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.152431 Lock_time: 0.000072 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173532;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘blocked’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:12.586793Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.135570 Lock_time: 0.000072 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173532;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘dev’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:12.730881Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.136297 Lock_time: 0.000074 Rows_sent: 412 Rows_examined: 134055

SET timestamp=1572173532;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘kannel’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:12.734869Z
User@Host: playsms[playsms] @ localhost [] Id: 3050
Query_time: 0.000685 Lock_time: 0.000150 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173532;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:12.735767Z
User@Host: playsms[playsms] @ localhost [] Id: 3050
Query_time: 0.000231 Lock_time: 0.000080 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173532;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:12.748596Z
User@Host: playsms[playsms] @ localhost [] Id: 3051
Query_time: 0.000301 Lock_time: 0.000060 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173532;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:12.749071Z
User@Host: playsms[playsms] @ localhost [] Id: 3051
Query_time: 0.000159 Lock_time: 0.000052 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173532;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:12.789510Z
User@Host: playsms[playsms] @ localhost [] Id: 3050
Query_time: 0.053481 Lock_time: 0.000077 Rows_sent: 0 Rows_examined: 128243

SET timestamp=1572173532;
SELECT id, queue_code FROM playsms_tblSMSOutgoing_queue WHERE flag=‘0’ LIMIT 10;
Time: 2019-10-27T10:52:12.835329Z
User@Host: playsms[playsms] @ localhost [] Id: 3050
Query_time: 0.045442 Lock_time: 0.000149 Rows_sent: 0 Rows_examined: 128243

SET timestamp=1572173532;
SELECT id, queue_code FROM playsms_tblSMSOutgoing_queue WHERE flag=‘3’ LIMIT 10;
Time: 2019-10-27T10:52:12.897807Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.150354 Lock_time: 0.000076 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173532;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘nexmo’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:13.039484Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.137574 Lock_time: 0.000060 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173532;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘xvestrus’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:13.179209Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.135602 Lock_time: 0.000065 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173533;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘xvesttaj’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:13.319050Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.135700 Lock_time: 0.000059 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173533;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘barclayalert’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:13.320938Z
User@Host: playsms[playsms] @ localhost [] Id: 3052
Query_time: 0.000325 Lock_time: 0.000073 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173533;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:13.321630Z
User@Host: playsms[playsms] @ localhost [] Id: 3052
Query_time: 0.000144 Lock_time: 0.000054 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173533;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:13.324802Z
User@Host: playsms[playsms] @ localhost [] Id: 3052
Query_time: 0.002986 Lock_time: 0.000055 Rows_sent: 0 Rows_examined: 4860

SET timestamp=1572173533;
SELECT * FROM playsms_tblRecvSMS WHERE flag_processed=‘1’ LIMIT 1000;
Time: 2019-10-27T10:52:13.325330Z
User@Host: playsms[playsms] @ localhost [] Id: 3052
Query_time: 0.000103 Lock_time: 0.000039 Rows_sent: 10 Rows_examined: 10

SET timestamp=1572173533;
SELECT * FROM playsms_tblGateway;
Time: 2019-10-27T10:52:13.342855Z
User@Host: playsms[playsms] @ localhost [] Id: 3053
Query_time: 0.000296 Lock_time: 0.000062 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173533;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:13.343410Z
User@Host: playsms[playsms] @ localhost [] Id: 3053
Query_time: 0.000140 Lock_time: 0.000052 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173533;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:13.343849Z
User@Host: playsms[playsms] @ localhost [] Id: 3053
Query_time: 0.000223 Lock_time: 0.000051 Rows_sent: 0 Rows_examined: 204

SET timestamp=1572173533;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘0’ AND registry_group=‘features’ AND registry_family=‘mailsms’;
Time: 2019-10-27T10:52:13.344412Z
User@Host: playsms[playsms] @ localhost [] Id: 3053
Query_time: 0.000101 Lock_time: 0.000039 Rows_sent: 10 Rows_examined: 10

SET timestamp=1572173533;
SELECT * FROM playsms_tblGateway;
Time: 2019-10-27T10:52:13.487067Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.151817 Lock_time: 0.000071 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173533;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘rbsalert’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:13.629749Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.138568 Lock_time: 0.000059 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173533;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘hsbalert’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:13.751828Z
User@Host: playsms[playsms] @ localhost [] Id: 3054
Query_time: 0.000447 Lock_time: 0.000140 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173533;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:13.752335Z
User@Host: playsms[playsms] @ localhost [] Id: 3054
Query_time: 0.000149 Lock_time: 0.000053 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173533;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:13.777688Z
User@Host: playsms[playsms] @ localhost [] Id: 3047
Query_time: 0.143823 Lock_time: 0.000062 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173533;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘bistox’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:13.840730Z
User@Host: playsms[playsms] @ localhost [] Id: 3055
Query_time: 0.000759 Lock_time: 0.000174 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173533;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:13.841961Z
User@Host: playsms[playsms] @ localhost [] Id: 3055
Query_time: 0.000226 Lock_time: 0.000082 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173533;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:13.888135Z
User@Host: playsms[playsms] @ localhost [] Id: 3055
Query_time: 0.045742 Lock_time: 0.000092 Rows_sent: 0 Rows_examined: 128243

SET timestamp=1572173533;
SELECT id, queue_code FROM playsms_tblSMSOutgoing_queue WHERE flag=‘0’ LIMIT 10;
Time: 2019-10-27T10:52:13.932260Z
User@Host: playsms[playsms] @ localhost [] Id: 3055
Query_time: 0.043692 Lock_time: 0.000116 Rows_sent: 0 Rows_examined: 128243

SET timestamp=1572173533;
SELECT id, queue_code FROM playsms_tblSMSOutgoing_queue WHERE flag=‘3’ LIMIT 10;
Time: 2019-10-27T10:52:14.333117Z
User@Host: playsms[playsms] @ localhost [] Id: 3056
Query_time: 0.000859 Lock_time: 0.000195 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173534;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:14.338226Z
User@Host: playsms[playsms] @ localhost [] Id: 3056
Query_time: 0.000461 Lock_time: 0.000159 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173534;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:14.344119Z
User@Host: playsms[playsms] @ localhost [] Id: 3056
Query_time: 0.004947 Lock_time: 0.000144 Rows_sent: 0 Rows_examined: 4860

SET timestamp=1572173534;
SELECT * FROM playsms_tblRecvSMS WHERE flag_processed=‘1’ LIMIT 1000;
Time: 2019-10-27T10:52:14.344972Z
User@Host: playsms[playsms] @ localhost [] Id: 3056
Query_time: 0.000657 Lock_time: 0.000050 Rows_sent: 10 Rows_examined: 10

SET timestamp=1572173534;
SELECT * FROM playsms_tblGateway;
Time: 2019-10-27T10:52:14.350514Z
User@Host: playsms[playsms] @ localhost [] Id: 3057
Query_time: 0.000297 Lock_time: 0.000062 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173534;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:14.351029Z
User@Host: playsms[playsms] @ localhost [] Id: 3057
Query_time: 0.000162 Lock_time: 0.000051 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173534;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:14.351444Z
User@Host: playsms[playsms] @ localhost [] Id: 3057
Query_time: 0.000222 Lock_time: 0.000050 Rows_sent: 0 Rows_examined: 204

SET timestamp=1572173534;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘0’ AND registry_group=‘features’ AND registry_family=‘mailsms’;
Time: 2019-10-27T10:52:14.351733Z
User@Host: playsms[playsms] @ localhost [] Id: 3057
Query_time: 0.000101 Lock_time: 0.000039 Rows_sent: 10 Rows_examined: 10

SET timestamp=1572173534;
SELECT * FROM playsms_tblGateway;
Time: 2019-10-27T10:52:14.757264Z
User@Host: playsms[playsms] @ localhost [] Id: 3058
Query_time: 0.000722 Lock_time: 0.000139 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173534;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:14.758344Z
User@Host: playsms[playsms] @ localhost [] Id: 3058
Query_time: 0.000248 Lock_time: 0.000102 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173534;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:14.784434Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.000499 Lock_time: 0.000117 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173534;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:14.791194Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.000262 Lock_time: 0.000108 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173534;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:14.869813Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.074862 Lock_time: 0.000071 Rows_sent: 0 Rows_examined: 256513

SET timestamp=1572173534;
SELECT * FROM playsms_tblDLR WHERE flag_processed=‘1’ LIMIT 1000;
Time: 2019-10-27T10:52:14.874499Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.000154 Lock_time: 0.000054 Rows_sent: 10 Rows_examined: 10

SET timestamp=1572173534;
SELECT * FROM playsms_tblGateway;
Time: 2019-10-27T10:52:14.936904Z
User@Host: playsms[playsms] @ localhost [] Id: 3060
Query_time: 0.000765 Lock_time: 0.000208 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173534;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:14.938095Z
User@Host: playsms[playsms] @ localhost [] Id: 3060
Query_time: 0.000406 Lock_time: 0.000132 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173534;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:14.987839Z
User@Host: playsms[playsms] @ localhost [] Id: 3060
Query_time: 0.049251 Lock_time: 0.000123 Rows_sent: 0 Rows_examined: 128243

SET timestamp=1572173534;
SELECT id, queue_code FROM playsms_tblSMSOutgoing_queue WHERE flag=‘0’ LIMIT 10;
Time: 2019-10-27T10:52:15.020243Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.141112 Lock_time: 0.000060 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173534;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘blocked’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:15.036845Z
User@Host: playsms[playsms] @ localhost [] Id: 3060
Query_time: 0.048550 Lock_time: 0.000181 Rows_sent: 0 Rows_examined: 128243

SET timestamp=1572173534;
SELECT id, queue_code FROM playsms_tblSMSOutgoing_queue WHERE flag=‘3’ LIMIT 10;
Time: 2019-10-27T10:52:15.164915Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.139071 Lock_time: 0.000065 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173535;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘dev’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:15.306972Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.136502 Lock_time: 0.000061 Rows_sent: 412 Rows_examined: 134055

SET timestamp=1572173535;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘kannel’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:15.352674Z
User@Host: playsms[playsms] @ localhost [] Id: 3061
Query_time: 0.000831 Lock_time: 0.000229 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173535;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:15.354436Z
User@Host: playsms[playsms] @ localhost [] Id: 3061
Query_time: 0.000493 Lock_time: 0.000205 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173535;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:15.361753Z
User@Host: playsms[playsms] @ localhost [] Id: 3061
Query_time: 0.006684 Lock_time: 0.000168 Rows_sent: 0 Rows_examined: 4860

SET timestamp=1572173535;
SELECT * FROM playsms_tblRecvSMS WHERE flag_processed=‘1’ LIMIT 1000;
Time: 2019-10-27T10:52:15.362314Z
User@Host: playsms[playsms] @ localhost [] Id: 3061
Query_time: 0.000202 Lock_time: 0.000072 Rows_sent: 10 Rows_examined: 10

SET timestamp=1572173535;
SELECT * FROM playsms_tblGateway;
Time: 2019-10-27T10:52:15.363027Z
User@Host: playsms[playsms] @ localhost [] Id: 3062
Query_time: 0.000313 Lock_time: 0.000071 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173535;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:15.363656Z
User@Host: playsms[playsms] @ localhost [] Id: 3062
Query_time: 0.000145 Lock_time: 0.000055 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173535;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:15.364238Z
User@Host: playsms[playsms] @ localhost [] Id: 3062
Query_time: 0.000227 Lock_time: 0.000052 Rows_sent: 0 Rows_examined: 204

SET timestamp=1572173535;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘0’ AND registry_group=‘features’ AND registry_family=‘mailsms’;
Time: 2019-10-27T10:52:15.364622Z
User@Host: playsms[playsms] @ localhost [] Id: 3062
Query_time: 0.000104 Lock_time: 0.000040 Rows_sent: 10 Rows_examined: 10

SET timestamp=1572173535;
SELECT * FROM playsms_tblGateway;
Time: 2019-10-27T10:52:15.456524Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.142408 Lock_time: 0.000065 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173535;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘nexmo’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:15.600042Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.138076 Lock_time: 0.000580 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173535;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘xvestrus’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:15.742091Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.136353 Lock_time: 0.000065 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173535;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘xvesttaj’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:15.762218Z
User@Host: playsms[playsms] @ localhost [] Id: 3063
Query_time: 0.000606 Lock_time: 0.000118 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173535;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:15.763203Z
User@Host: playsms[playsms] @ localhost [] Id: 3063
Query_time: 0.000376 Lock_time: 0.000116 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173535;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:15.883896Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.135937 Lock_time: 0.000079 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173535;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘barclayalert’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:16.027140Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.136822 Lock_time: 0.000064 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173535;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘rbsalert’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:16.041577Z
User@Host: playsms[playsms] @ localhost [] Id: 3064
Query_time: 0.000356 Lock_time: 0.000077 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173536;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:16.045870Z
User@Host: playsms[playsms] @ localhost [] Id: 3064
Query_time: 0.000160 Lock_time: 0.000063 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173536;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:16.093141Z
User@Host: playsms[playsms] @ localhost [] Id: 3064
Query_time: 0.043954 Lock_time: 0.000050 Rows_sent: 0 Rows_examined: 128243

SET timestamp=1572173536;
SELECT id, queue_code FROM playsms_tblSMSOutgoing_queue WHERE flag=‘0’ LIMIT 10;
Time: 2019-10-27T10:52:16.140864Z
User@Host: playsms[playsms] @ localhost [] Id: 3064
Query_time: 0.043706 Lock_time: 0.000115 Rows_sent: 0 Rows_examined: 128243

SET timestamp=1572173536;
SELECT id, queue_code FROM playsms_tblSMSOutgoing_queue WHERE flag=‘3’ LIMIT 10;
Time: 2019-10-27T10:52:16.170912Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.138093 Lock_time: 0.000068 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173536;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘hsbalert’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:16.311227Z
User@Host: playsms[playsms] @ localhost [] Id: 3059
Query_time: 0.134723 Lock_time: 0.000064 Rows_sent: 0 Rows_examined: 134055

SET timestamp=1572173536;
SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=‘0’ AND p_smsc=‘bistox’ AND flag_deleted=‘0’;
Time: 2019-10-27T10:52:16.370848Z
User@Host: playsms[playsms] @ localhost [] Id: 3066
Query_time: 0.000589 Lock_time: 0.000143 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173536;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:16.370852Z
User@Host: playsms[playsms] @ localhost [] Id: 3065
Query_time: 0.000538 Lock_time: 0.000089 Rows_sent: 39 Rows_examined: 204

SET timestamp=1572173536;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘1’ AND registry_group=‘core’ AND registry_family=‘main_config’;
Time: 2019-10-27T10:52:16.371815Z
User@Host: playsms[playsms] @ localhost [] Id: 3066
Query_time: 0.000226 Lock_time: 0.000081 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173536;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:16.372905Z
User@Host: playsms[playsms] @ localhost [] Id: 3065
Query_time: 0.000936 Lock_time: 0.000799 Rows_sent: 0 Rows_examined: 37

SET timestamp=1572173536;
SELECT language_module FROM playsms_tblUser WHERE flag_deleted=‘0’ AND username=’’;
Time: 2019-10-27T10:52:16.373492Z
User@Host: playsms[playsms] @ localhost [] Id: 3066
Query_time: 0.000357 Lock_time: 0.000079 Rows_sent: 0 Rows_examined: 204

SET timestamp=1572173536;
SELECT registry_key, registry_value FROM playsms_tblRegistry WHERE uid=‘0’ AND registry_group=‘features’ AND registry_family=‘mailsms’;
Time: 2019-10-27T10:52:16.374022Z
User@Host: playsms[playsms] @ localhost [] Id: 3066
Query_time: 0.000177 Lock_time: 0.000058 Rows_sent: 10 Rows_examined: 10

SET timestamp=1572173536;
SELECT * FROM playsms_tblGateway;
Time: 2019-10-27T10:52:16.377877Z
User@Host: playsms[playsms] @ localhost [] Id: 3065
Query_time: 0.004438 Lock_time: 0.000105 Rows_sent: 0 Rows_examined: 4860

SET timestamp=1572173536;
SELECT * FROM playsms_tblRecvSMS WHERE flag_processed=‘1’ LIMIT 1000;
Time: 2019-10-27T10:52:16.378322Z
User@Host: playsms[playsms] @ localhost [] Id: 3065
Query_time: 0.000105 Lock_time: 0.000039 Rows_sent: 10 Rows_examined: 10

Also for additional information

Please help!
Thank in advance

Regards,
Jamshid Tursunov

[thejvmshid]

Anton, I tried to collect information on each process and together as a whole, and this is what happened:
Sequential shutdown and inclusion:

Before shutting down the processes, the CPU load varied in the range of 105-140%
Disconnected in the following sequence:
The first to disconnect ratesmsd, the CPU load dropped to around 30-50%, and this range, while watching, kept steady
The second turned off recvsmsd, the CPU load was in the range of 30-43%
The third disabled schedule, the CPU load was in the range of 30-42%
The fourth disconnected sendsmsd, the CPU load was in the range of 30-42%
Fifth disabled dlrssmsd, CPU load dropped to 0.7%, sometimes jumped to 1%

When all 5 services disconnected, the CPU load dropped to 0.7%, sometimes jumped to 1%

When I turned on dlrssmsd, the CPU load jumped right up to 30-42%
Next turned on sendsmsd, the CPU load remained in the range of 30-42%
After turning on schedule, the CPU load was in the range of 30-42%
Then turned on recvsmsd, the CPU load was in the range of 30-42%
When I turned on ratesmsd, the CPU load was kept in the range of 40-45%, but very often there are skips and the load reaches as much as 145%

Individual enable and disable: (I will enable and disable the service to calculate how much load a single process gives)
When I turned on dlrssmsd, the CPU load jumped right up to 42%
Next turned on sendsmsd, CPU load kept in the range 1.3-1.7%
After I enabled schedule, the CPU load was in the range 1.3-1.7%
Then I turned on recvsmsd, the CPU load kept in the range 1.3-1.7%
When I turned on ratesmsd, the CPU load started to jump right up to the mark above 100%
…
I want to emphasize that even after I turned off all the PlaySMS processes, the memory occupied by MySQL remained at 14%. I want to say that after disabling the PlaySMS process, the memory is not freed.

Respectfully,
Jamshid Tursunov