new server, need optimization, high swap usage

[dotpro]

Hi,

I recently moved my websites to new dedicated server and need help optimizing it.

Dedicated server: Yes
SSD or SATA: 4x SSD in RAID10
RAID or non-RAID (and hardware or software) and if RAID what level: HW/RAID10
Memory: 64GB
CPU: Dual CPU HEX Core E5-2620 0 @ 2.00GHz
HTTP server used: Litespeed entperprise
PHP processor used: fcgi
version of PHP: 5.4
OpCode caching enabled: no
Memcached being used? no, i have xcache installed


I am noticing high swap usage and only 6% of the RAM being used.

 

[Slavik]

What does

cat /proc/swaps

Return?

 

[dotpro]

Hi,
thanks, it returns:

Filename Type Size Used Priority
/dev/sdb7 partition 4300796 445748 -1

 

[Slavik]

Whats your /proc/sys/vm/swappiness set to?

 

[dotpro]

60

 

[dotpro]

I managed to set the value to 0 and swap is still at about 7% usage.

I restarted mysql and got these errors:
150113 1:14:45 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYVMHTKN' (Errcode: 28)
150113 1:14:45 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_7d50_22.MYI'; try to repair it

/tmp dir is about 10% full.

 

[Sheratan]

I think swap usage 7% is quite normal with that much RAM, with 10% /tmp too

If you want to swap usage 0% you can try to disable swap *not reccomended*

How much your RAM usage right now?

 

[dotpro]

Right now 6% RAM usage. My previous server lingered around 30% with occasional spikes and never used swap (it was not disabled).

thanks

 

[Jim Boy]

SWAP can be used by the server when idling. What happens is that it puts some of the Memory into SWAP, 'just in case', but it doesn't remove the data from regular memory. The level to which it does that is determined by swappiness. If you want to stop it, set swappiness to zero. But as it only writes during idle and doesn't remove anything from RAM, it should not be impacting on your system at all.

 

[dotpro]

Thanks everyone.

Is there anything else I can do to optimize the server for best performance?

 

[rdn]

Install the LiteSpeed Cache XenForo addon .

 

[dotpro]

Install the LiteSpeed Cache XenForo addon .

Thanks, that was on my list but it would be for xf forums only... I was asking in optimization in general for mysql/litespeed, etc.

 

[rdn]

Replace Oracle Mysql with Percona or MariaDB 10.

 

[dotpro]

Percona is an option. I had it before but for some reason I had issues restarting mysql:
http://www.percona.com/forums/quest...percona-server/29460-mysql-broken-please-help

Testing with tools.pingdom.com

forum with xf and litespeed cache takes 3.95seconds to load
while vb3.8 forum on same server takes 1.95seconds to load

 

[rdn]

http://www.percona.com/forums/quest...percona-server/29460-mysql-broken-please-help

Bad news on this link, they use VB5

forum with xf and litespeed cache takes 3.95seconds to load

Check the page size.
Maybe more ads, avatars, js, css on your current XenForo Site.
Install Full page caching for the guest.
Maybe varnish or LiteSpeed Caching.

 

[dotpro]

Bad news on this link, they use VB5


Check the page size.
Maybe more ads, avatars, js, css on your current XenForo Site.
Install Full page caching for the guest.
Maybe varnish or LiteSpeed Caching.

17KB
1 ad, 8 avatars load on homepage
is that different add-on?
i thought that is what the LiteSpeed Cache XenForo addon was for above?


XF needs its own EVA2000
I feel like I am not going anywhere even with SSDs and litespeed...

 

[rdn]

is that different add-on?
i thought that is what the LiteSpeed Cache XenForo addon was for above?

I'm not expert in litespeed, but all I know is this: https://xenforo.com/community/resources/xenforo-litespeed-cache.2704/
But I think it doesn't cache all pages for the guest.

XF needs its own EVA2000

He is already here helping a lot
tagging @eva2000

 

[eva2000]

Oh someone mentioned my name

@dotpro while I am here, I don't do free optimisations on this forum. I'm hear because my Centmin Mod forums uses XF https://community.centminmod.com/

 

[Walter]

How much RAM have you dedicated to Mysql?

 

[dotpro]

Oh someone mentioned my name

@dotpro while I am here, I don't do free optimisations on this forum. I'm hear because my Centmin Mod forums uses XF https://community.centminmod.com/

Oh, good to know. Should I post on vb or your forum?

How much RAM have you dedicated to Mysql?

This is what my.cnf looks like:

[mysqld]
slow-query-log=1
long_query_time=1
# safe-show-database
max_connections=500
local-infile=0
default-storage-engine=MyISAM
key_buffer_size = 12G
innodb_file_per_table=1
innodb_buffer_pool_size=134217728
max_allowed_packet=268435456
query-cache-type = 1
query-cache-size = 128M

open_files_limit=10000