MySQL Forums
Forum List  »  Performance

A INSERT SQL is MySQL use memory too much
Posted by: 问问 jack
Date: May 01, 2022 11:33PM

when MySQL is running a insert data, the count of number is about 20w, and is about 100M but the memory useage is about more than 4G


*************************** 1. row ***************************
thread_id: 442974
event_name: memory/sql/THD::variables
sys.format_bytes(CURRENT_NUMBER_OF_BYTES_USED): 3.93 GiB
sql_text: INSERT INTO data
the SQL memory from SELECT a.thread_id, a.event_name,sys.format_bytes(CURRENT_NUMBER_OF_BYTES_USED), sql_text FROM performance_schema.memory_summary_by_thread_by_event_name a,performance_schema.events_statements_current b where a.thread_id=b.thread_id ORDER BY CURRENT_NUMBER_OF_BYTES_USED DESC LIMIT 10; CURRENT_NUMBER_OF_BYTES_USED is about 3GB

is there any wrony with it ?

Options: ReplyQuote


Subject
Views
Written By
Posted
A INSERT SQL is MySQL use memory too much
176
May 01, 2022 11:33PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.