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? Quote Link to comment 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. Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.