abazoskib Posted August 4, 2009 Share Posted August 4, 2009 i ran a script called tuning-primer.sh from http://www.transcendlinux.com/mysql-performance-tuning i got this message however i do not know exactly how to approach this problem: MEMORY USAGE Max Memory Ever Allocated : 974 M Configured Max Per-thread Buffers : 5.24 G Configured Max Global Buffers : 394 M Configured Max Memory Limit : 5.63 G Physical Memory : 1.70 G Max memory limit exceeds 90% of physical memory If anyone could show me which variables to change that would be great. Also, which variable values shall I post for observation? Link to comment https://forums.phpfreaks.com/topic/168811-memory-usage-problem/ Share on other sites More sharing options...
fenway Posted August 4, 2009 Share Posted August 4, 2009 This is all determined in your my.cnf file. Link to comment https://forums.phpfreaks.com/topic/168811-memory-usage-problem/#findComment-890921 Share on other sites More sharing options...
abazoskib Posted August 4, 2009 Author Share Posted August 4, 2009 actually the problem is that my server has not gone down since going up, so ive been using 'set global ...' to establish the values. what variable values am i looking for specifically? Link to comment https://forums.phpfreaks.com/topic/168811-memory-usage-problem/#findComment-890929 Share on other sites More sharing options...
fenway Posted August 10, 2009 Share Posted August 10, 2009 "Configured Max Per-thread Buffers" -- how is that being calculated? usually that's the worst-case scenario, so it's likely to be true. Link to comment https://forums.phpfreaks.com/topic/168811-memory-usage-problem/#findComment-894750 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.