Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Percona memory leakage

GrohotunGrohotun EntrantInactive User Role Beginner
After update from 5.5.30-rel30.1-465.squeeze to 5.5.30-rel30.2-500.squeeze mysql started to eat more memory, than before update.
Here is munin graph:
attachment.php?attachmentid=123153&stc=1&d=1366902526
Update from 500 to 503 doen`t help.


How to fix problem?
Now mysqld use 9.3 GB of ram

Mysqltuner output:
Performance Metrics
Up for: 7d 5h 8m 27s (330M q [529.902 qps], 1M conn, TX: 666B, RX: 162B)
Reads / Writes: 81% / 19%
Total buffers: 3.3G global + 2.8M per thread (151 max threads)
[OK] Maximum possible memory usage: 3.7G (23% of installed RAM)
[OK] Slow queries: 0% (9/330M)
[OK] Highest usage of available connections: 41% (62/151)
[OK] Key buffer size / total MyISAM indexes: 8.0M/269.3M
[OK] Key buffer hit rate: 99.6% (90M cached / 329K reads)
[OK] Query cache efficiency: 84.8% (260M cached / 306M selects)
[!!] Query cache prunes per day: 5092278
[OK] Sorts requiring temporary tables: 0% (173 temp sorts / 20M sorts)
[!!] Joins performed without indexes: 408039
[OK] Temporary tables created on disk: 7% (3M on disk / 40M total)
[OK] Thread cache hit rate: 97% (40K created / 1M connections)
[!!] Table cache hit rate: 0% (400 open / 878K opened)
[OK] Open file limit used: 0% (41/65K)
[OK] Table locks acquired immediately: 99% (183M immediate / 183M locks)
[OK] InnoDB data size / buffer pool: 1.9G/3.0G

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.