Key: |
QB-3106
|
Type: |
Bug
|
Status: |
Closed
|
Resolution: |
Incomplete
|
Priority: |
Critical
|
Assignee: |
Steve Luo
|
Reporter: |
Piotr Jedrys
|
Votes: |
0
|
Watchers: |
0
|
If you were logged in you would be able to see more operations.
|
|
|
QuickBuild
Created: 22/Dec/17 12:39 PM
Updated: 25/Jan/19 08:49 AM
|
|
Component/s: |
None
|
Affects Version/s: |
7.0.28
|
Fix Version/s: |
None
|
|
Original Estimate:
|
Unknown
|
Remaining Estimate:
|
Unknown
|
Time Spent:
|
Unknown
|
File Attachments:
|
1.
jvm4.log (5.79 Mb)
|
Image Attachments:
|
|
Environment:
|
Linux
|
|
Slow query results shows that insert to QB_MEASUREMENT_DATAR03 is taking much time.
# Query 2: 0.00 QPS, 0.01x concurrency, ID 0xA77BB2A9D02C43ED at byte 13078
# Scores: V/M = 0.64
# Time range: 2017-12-21T17:30:33 to 2017-12-21T21:33:01
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 21 12
# Exec time 17 182s 11s 21s 15s 19s 3s 15s
# Lock time 40 1ms 50us 384us 85us 69us 85us 57us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 8 2.06k 176 176 176 176 0 176
# String:
# Hosts quickbuild_master
# Users quickbuild_db
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS LIKE 'QB_MEASUREMENT_DATAR03'\G
# SHOW CREATE TABLE `QB_MEASUREMENT_DATAR03`\G
/* insert com.pmease.quickbuild.model.MeasurementDataR03 */ insert into QB_MEASUREMENT_DATAR03 (QB_METRIC_NAME, QB_SOURCE, QB_TIMESTAMP, QB_VALUE, QB_ID) values (?, ?, ?, ?, ?)\G
This is actual status of the table:
mysql> SHOW TABLE STATUS LIKE 'QB_MEASUREMENT_DATAR03'
-> ;
+------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------+----------+----------------+---------+
| QB_MEASUREMENT_DATAR03 | InnoDB | 10 | Dynamic | 108211 | 121 | 13123584 | 0 | 35831808 | 5242880 | NULL | 2017-12-10 16:18:20 | 2017-12-22 00:28:13 | NULL | utf8_bin | NULL | | |
+------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------+----------+----------------+---------+
How do you suggest to optimize it?
|
Description
|
Slow query results shows that insert to QB_MEASUREMENT_DATAR03 is taking much time.
# Query 2: 0.00 QPS, 0.01x concurrency, ID 0xA77BB2A9D02C43ED at byte 13078
# Scores: V/M = 0.64
# Time range: 2017-12-21T17:30:33 to 2017-12-21T21:33:01
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 21 12
# Exec time 17 182s 11s 21s 15s 19s 3s 15s
# Lock time 40 1ms 50us 384us 85us 69us 85us 57us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 8 2.06k 176 176 176 176 0 176
# String:
# Hosts quickbuild_master
# Users quickbuild_db
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS LIKE 'QB_MEASUREMENT_DATAR03'\G
# SHOW CREATE TABLE `QB_MEASUREMENT_DATAR03`\G
/* insert com.pmease.quickbuild.model.MeasurementDataR03 */ insert into QB_MEASUREMENT_DATAR03 (QB_METRIC_NAME, QB_SOURCE, QB_TIMESTAMP, QB_VALUE, QB_ID) values (?, ?, ?, ?, ?)\G
This is actual status of the table:
mysql> SHOW TABLE STATUS LIKE 'QB_MEASUREMENT_DATAR03'
-> ;
+------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------+----------+----------------+---------+
| QB_MEASUREMENT_DATAR03 | InnoDB | 10 | Dynamic | 108211 | 121 | 13123584 | 0 | 35831808 | 5242880 | NULL | 2017-12-10 16:18:20 | 2017-12-22 00:28:13 | NULL | utf8_bin | NULL | | |
+------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------+----------+----------------+---------+
How do you suggest to optimize it? |
Show » |
|