MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Mysql high memory usage on centos 7 (migrating from centos 5)
1191
Tamas Szabo
March 03, 2018 04:39AM
Re: Mysql high memory usage on centos 7 (migrating from centos 5)
785
Tamas Szabo
March 03, 2018 05:54AM
Re: Mysql high memory usage on centos 7 (migrating from centos 5)
647
Peter Brawley
March 03, 2018 08:59AM
Re: Mysql high memory usage on centos 7 (migrating from centos 5)
1589
Tamas Szabo
March 03, 2018 10:07AM
Re: Mysql high memory usage on centos 7 (migrating from centos 5)
775
Peter Brawley
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.