History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: QB-3106
Type: Bug Bug
Status: Closed Closed
Resolution: Incomplete
Priority: Critical Critical
Assignee: Steve Luo
Reporter: Piotr Jedrys
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
QuickBuild

Long query inserts to QB_MEASUREMENTS

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. Text File jvm4.log (5.79 Mb)

Image Attachments:

1. Screen Shot 2018-01-22 at 16.43.37.png
(468 kb)

2. Screen Shot 2018-01-22 at 16.43.58.png
(493 kb)

3. Screen Shot 2018-01-22 at 16.44.17.png
(367 kb)

4. Screen Shot 2018-01-22 at 16.44.36.png
(430 kb)

5. Screen Shot 2018-01-22 at 16.49.39.png
(380 kb)
Environment: Linux


 Description  « Hide
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?

 All   Comments   Work Log   Change History      Sort Order:
No work has yet been logged on this issue.