MySQL Forums
Forum List  »  Performance

Re: High memory used by MySQL
Posted by: Peter Brawley
Date: March 02, 2020 04:17PM

> mysaladmin refresh then back
> with memory used to the limit

That flushes all table buffers, closes & reopens log files, so may momentarily reduce the memory load of those buffers too.

Handler_read_rnd_nxt/sec is 294K in this time period, much too high, you need to optimise the queries that are causing this debacle---turn the slow query log on, get after the queries causing that high number.

handler writes/sec 154k, > 20k/sec indicates inefficient code is stressing the system---your Inserts need optimising, see https://dev.mysql.com/doc/refman/5.7/en/insert-optimization.html

Options: ReplyQuote


Subject
Views
Written By
Posted
802
February 12, 2020 02:45AM
505
February 12, 2020 11:41AM
419
February 13, 2020 09:24AM
418
February 13, 2020 11:49AM
396
February 14, 2020 09:05AM
353
February 14, 2020 11:06AM
348
March 02, 2020 04:12AM
Re: High memory used by MySQL
330
March 02, 2020 04:17PM
288
March 02, 2020 08:35PM
324
March 02, 2020 08:36PM
320
March 03, 2020 06:12AM
295
March 03, 2020 11:51AM


Sorry, you can't reply to this topic. It has been closed.

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.