new server, need optimization, high swap usage

[Walter]

[mysqld]
key_buffer_size = 12G
innodb_buffer_pool_size=134217728

key_buffer ist for Myisam, try to reduce this to a sensible size.
innodb is what Xenforo uses by default and you only have 128 MB of Innodb buffers. Depending on the size of your forum try to raise this to e.g. 10G:

key_buffer_size = 1G
innodb_buffer_pool_size=12G

But this is only a rough guideline, true optimization depends on what your server does and how many posts you have and and and.... And there are other optimizations you can do.

 

[dotpro]

Walter,

Thank you. This is what I've got on the server:

1. website with 35k+ articles ( with 10K pictures) wordpress and 300k posts vb forum and around 45K photos photopost gallery
   
2. website with around 9k articles (3k photos in wordpress) and smaller vb forum and 105K photos in photopost gallery
   
3. site with 6k articles and very small xf
4. a standalone XF active forum with 300k posts
5. few other small websites, not very active

 

[rdn]

Walter,

Thank you. This is what I've got on the server:

1. website with 35k+ articles ( with 10K pictures) wordpress and 300k posts vb forum and around 45K photos photopost gallery
   
2. website with around 9k articles (3k photos in wordpress) and smaller vb forum and 105K photos in photopost gallery
   
3. site with 6k articles and very small xf
4. a standalone XF active forum with 300k posts
5. few other small websites, not very active

Short answer, Convert all your database table to Innodb including WP database and optimize your my.cnf
(focus on Innodb Engines only, disregard Myisam optimizations).