MySQL Forums
Forum List  »  Performance

Re: Mysql high memory usage on centos 7 (migrating from centos 5)
Posted by: Peter Brawley
Date: March 05, 2018 11:17AM

?! You have 16GB of data and indexes. MySQL is configured to use 9.4GB RAM.

I misread uptime, the time sample is adequate.

400 queries/sec, 3000 inserts/sec is fairly busy.

Too many table scans. Those queries need optimising.

The query cache is using RAM, contributing little, and is gone in 8.0 so turn it iff.

Looks like there are MyISAM read and write bottlenecks. And it's creating 6 tmp tables/sec, try growing tmp_table_size, max_heap_size. And it's opening nearly 40 files/sec, try growing the open_table_cache.

Sorry, I know nothing about centos 5-to-7 diffs.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql high memory usage on centos 7 (migrating from centos 5)
75
March 05, 2018 11:17AM


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.