simple queries taking too much time
Hi,
In our logs we see some simple queries (INSERT 1 row or DELETE 1 row by primary key) that sometime takes a few seconds to complete without knowing where is spent the time and how to reduce it :
# Thread_id: 5460576 Schema: our_schema Last_errno: 0 Killed: 0
# Query_time: 2.049189 Lock_time: 0.000099 Rows_sent: 0 Rows_examined: 1 Rows_affected: 1 Rows_read: 1
# Bytes_sent: 11
use our_schema;
SET timestamp=
DELETE FROM our_table WHERE doc_id = 825297976;
# Thread_id: 5474371 Schema: arp_tool_ms Last_errno: 0 Killed: 0
# Query_time: 2.747146 Lock_time: 0.000063 Rows_sent: 0 Rows_examined: 0 Rows_affected: 1 Rows_read: 0
# Bytes_sent: 19
SET timestamp=
INSERT INTO our_other_
We see that only one row is accessed/inserted (use of primary key) and that the lock time is really short.
However looking at the cluster statistics doesn't give us any more information about the time lost to execute our queries. It doesn't happen all the time but we see that our applications are slowed down.
You can find the screenshot of our cluster statistics at http://
Question information
- Language:
- English Edit question
- Status:
- Expired
- Assignee:
- No assignee Edit question
- Last query:
- Last reply: