MySQL Forums
Forum List  »  Newbie

Re: insert stops insert in other tables
Posted by: Peter Brawley
Date: June 28, 2022 06:31AM

Are multiple users using this app? If so, your machine looks under-resourced for what you're trying to do.

If MySQL has access to most of the 4GB, you might improve performance by increasing innodb_buffer_pool_size to 2 or 3 GB. Mutex numbers suggest disk i/o is the bottleneck. If growing the buffer doesn't improve performance, you might consider doing the table copy at off-peak times, or reconsider the need for the copy---is it in fact necessary? If it is, and if such table copying is frequent, you probably need a faster disk and perhaps more RAM.

Options: ReplyQuote

Written By
Re: insert stops insert in other tables
June 28, 2022 06:31AM

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.