MySQL Forums
Forum List  »  Performance

Re: High memory usage on mysql 5.7.18
Posted by: Zubair Suri
Date: July 24, 2017 04:51PM

Here are the results from the query at https://www.artfulsoftware.com/infotree/tip.php?id=1339&r=1

"Item","Rate","Suggestions"
"Slow queries/sec",NULL,"Enable slow query log"
"Unindexed queries/sec",NULL,"Find & optimise unindexed queries"
"Full table scans/sec",NULL,"Find & optimise queries that do full table scans"
"Total InnoDB load / buffer pool size",NULL,"InnoDB buffer pool can accommodate most InnoDB data & indexes"
"InnoDB buffer pool inefficiency","0","Grow innodb_buffer_pool_size if > 2% or if innodb_buffer_pool_size < 70% of RAM"
"InnoDB pages read and buffer pool","0","As above"
"InnoDB log thrashing","0.75","Best near 0.5; if well under 0.5, grow innodb_log_file_size, shrink if much larger"
"Mins between InnoDB log rotation","1763.65","Grow log size if < 30 min, shrink if > 60 min**"
"MyISAM query cache hits/sec",NULL,"If high, grow query_cache_size up to 50"
"MyISAM query cache spills/sec",NULL,"If < 5, try turning query cache off"
"MyISAM cache hit rate","4632.82","If < 10, grow key_buffer_size"
"MyISAM key read rate",NULL,"Should be high when the buffer is full"
"MyISAM query cache hits/inserts",NULL,"If < 5, consider disabling the cache"
"Temp tables created/sec",NULL,"Grow tmp_table_size, max_heap_size. Use Heap tables in queries"
"Database changes/connection",NULL,"Use db.table syntax"
"Processes/connection","0","If high, grow thread_cache_size"
"Queries/sec",NULL,"Thousands is busy: you may need better hardware"
"Inserts/sec",NULL,"Tens of thousands is busy, you may need better hardware"
"InnoDB buffer reads/sec",NULL,"Thousands is busy: you may need better hardware"
"Files opened/sec",NULL,"If > 5, increase table_open_cache"
"Created tmp disk tables/sec",NULL,"If > 1, check tmp_table_size, max_heap_table_size, Text/Blob query retrievals"
"Created_tmp_disk_tables/Queries","0.24","If > 4%, check tmp_table_size, max_heap_table_size, Text/Blob query retrievals"

Options: ReplyQuote


Subject
Views
Written By
Posted
4617
July 21, 2017 08:05AM
Re: High memory usage on mysql 5.7.18
1267
July 24, 2017 04:51PM


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.