MySQL Forums
Forum List  »  Newbie

Re: insert stops insert in other tables
Posted by: Peter Brawley
Date: June 23, 2022 10:50AM

For starters ...

How much RAM is available to MySQL?

What is innodb_buffer_pool_size?

What is the result of running Explain Analyze on your Insert query?

Does the Insert query induce swapping?

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

Edited 1 time(s). Last edit at 06/28/2022 05:53AM by Peter Brawley.

Options: ReplyQuote

Written By
Re: insert stops insert in other tables
June 23, 2022 10:50AM

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.