Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.2.22
-
OS: Ubuntu 18.04 server 64bit
Linux: 4.15.0-47-generic #50-Ubuntu SMP Wed Mar 13 10:44:52 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
Database: mysql Ver 15.1 Distrib 10.2.22-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Description
MariaDB Galera Cluster response longer than 1 second
the collected slow log samples as follow:
SET timestamp=1557759155;
UPDATE `api_logs` SET `response_code` = 200
WHERE `id` = 104258;
- User@Host: CD.com[CD.com] @ [192.168.1.141]
- Thread_id: 1154 Schema: ciosa_productivo QC_hit: No
- Query_time: 1.055928 Lock_time: 0.000034 Rows_sent: 0 Rows_examined: 0
- Rows_affected: 1
SET timestamp=1557759155;
INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('6adcce0d0cc4dae7dbb3dcb7171979c0', '200.39.24.163', 'Mozilla/5.0 (Windows NT 6.2; WOW64; Trident/7.0; rv:11.0) like Gecko', 1557759147, ''); - User@Host: CD.com[CD.com] @ [192.168.1.56]
- Thread_id: 1157 Schema: ciosa_productivo QC_hit: No
- Query_time: 1.105405 Lock_time: 0.000024 Rows_sent: 0 Rows_examined: 0
- Rows_affected: 1