MySQL Forums
Forum List  »  Performance

Re: Mysql high memory usage on centos 7 (migrating from centos 5)
Posted by: Tamas Szabo
Date: March 03, 2018 10:07AM

Peter, is good, that mysql server used too much memory after 2 days on centos 7 before same data same my.cnf same mysql version on centos 5 server used ~1/2 memory ~3 months?!?

Mysql server used 6 GB memory constantly on centos 5, same data used ~10-11 GB memory on centos 7. This is my problem and i don't understand the reason (other info: centos 5 NEVER swap, centos 7 swapping after 2 days; all server have vm.swappiness 60)

Do you can give me answer for this? Yes, i known, i need more memory for mysql server. But why i don't need more memory on centos 5 for same data with same settings? This is the BIG question!

Here is requested result:

+--------+---------+---------+---------+
| engine | data | indexes | total |
+--------+---------+---------+---------+
| InnoDB | 7.0 GB | 2.7 GB | 9.7 GB |
| MyISAM | 4.5 GB | 1.8 GB | 6.3 GB |
| CSV | 0.0 GB | 0.0 GB | 0.0 GB |
| MEMORY | 0.0 GB | 0.0 GB | 0.0 GB |
| TOTALS | 11.5 GB | 4.5 GB | 16.0 GB |
+--------+---------+---------+---------+

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql high memory usage on centos 7 (migrating from centos 5)
87
March 03, 2018 10:07AM


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.