MySQL Forums
Forum List  »  Newbie

Re: insert stops insert in other tables
Posted by: Emil Edeholt
Date: June 28, 2022 04:36AM

Thanks for your answer. Sorry for my slow reply, I got the flu.

> How much RAM is available to MySQL?
> What is innodb_buffer_pool_size?

pool size: 1024MB
the table I'm trying to copy has a DATA_LENGTH + INDEX_LENGTH = 376MB
the total ram on the server is 4GB, 2GB free ram when not running my query

> Does the Insert query induce swapping?

I'm not sure what is the best way to measure this. I ran:
sudo awk '/^Swap:/ { SWAP+=$2 } END { print SWAP" kB" }' /proc/$(pidof mysqld)/smaps

and it was 34MB before the query and about the same during the execution of the query.

> What is the result of running Explain Analyze on your Insert query?
EXPLAIN INSERT INTO the_database.table_copy SELECT * FROM the_database.table_original;

1 SIMPLE table_original ALL NULL NULL NULL NULL 213476

> What does Show Engine InnoDB Status say when it runs whole your Insert query is running?

Does this tell you anything?

Options: ReplyQuote

Written By
Re: insert stops insert in other tables
June 28, 2022 04:36AM

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.