Hello Peter, i'm definitely not a MySQL expert but giving a look to the settings you posted (and expecially to that 'key_buffer = 256M') i suspect that all that memory is 'locked' because of some overextimated setting. In my little experience with it, a bare MySQL server (for bare i mean as you find it, without touching any my.cnf variable) takes some 30Mb (VSZ), comes with a 'key_buffer = 16M' and attached to a bunch of totally underutilized web sites, creates 20 to 30 processes.
Is pmacct still warning you about the packet loss ? If yes, try either (1) pushing up the value of 'plugin_buffer_size' (mantaining its actual ratio with 'plugin_pipe_size') or try (2) increasing the ratio (pushing up 'plugin_pipe_size' but leaving as is the 'plugin_buffer_size'). Two examples: 1) plugin_buffer_size: 8192 plugin_pipe_size: 8192000 2) plugin_buffer_size: 4096 plugin_pipe_size: 8192000 Let me know how things get evolved on your side. Cheers, Paolo
