522 Error Connection timed out (CloudFlare)
522 Error Connection timed out (CloudFlare)
Hi,
Installed VestaCP Version: 0.9.8 (amd64) a week ago and first 1-2 days
it was ok but last few days I have serious issues with accessing the website.
It timeouts every few seconds, especially when I try to access WordPress dashboard.
Trying to amend the my.cnf but it doesn't help much.
The CPU load jumps to 25-75% sometimes when I load the site.
The site is a WordPress with W3 Total Cache installed, CloudFlare and everything
is up to date (coming from a shared hosting and everything worked there).
It is a KVM VPS with 3 CPUs and 1 CPU socket, 2GB ram and SSD hdd.
There are just 2 sites hosted on the server with a minimum visit (5-10 unique/day).
Any advice is appreciated.
Some details below (installed MySQLTuner but it was for too short time online so the date
can be incorrect).
Thank you in advance for any hits.
Installed VestaCP Version: 0.9.8 (amd64) a week ago and first 1-2 days
it was ok but last few days I have serious issues with accessing the website.
It timeouts every few seconds, especially when I try to access WordPress dashboard.
Trying to amend the my.cnf but it doesn't help much.
The CPU load jumps to 25-75% sometimes when I load the site.
The site is a WordPress with W3 Total Cache installed, CloudFlare and everything
is up to date (coming from a shared hosting and everything worked there).
It is a KVM VPS with 3 CPUs and 1 CPU socket, 2GB ram and SSD hdd.
There are just 2 sites hosted on the server with a minimum visit (5-10 unique/day).
Any advice is appreciated.
Some details below (installed MySQLTuner but it was for too short time online so the date
can be incorrect).
Code: Select all
uname -a
Linux hostname 3.2.0-4-amd64 #1 SMP Debian 3.2.54-2 x86_64 GNU/LinuxCode: Select all
free -m
total used free shared buffers cached
Mem: 2012 1477 535 0 164 952
-/+ buffers/cache: 360 1651
Swap: 3747 0 3747Code: Select all
top -c
top - 16:22:37 up 2 days, 22:20, 1 user, load average: 0.00, 0.02, 0.05
Tasks: 100 total, 1 running, 99 sleeping, 0 stopped, 0 zombie
%Cpu(s): 0.0 us, 0.2 sy, 0.0 ni, 99.5 id, 0.0 wa, 0.0 hi, 0.0 si, 0.3 st
KiB Mem: 2061072 total, 1491628 used, 569444 free, 168028 buffers
KiB Swap: 3837944 total, 0 used, 3837944 free, 957836 cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
18286 root 20 0 71256 3644 2848 S 0.7 0.2 0:00.99 sshd: root@pts/0
30831 root 20 0 0 0 0 S 0.7 0.0 0:07.15 [kworker/1:2]
1 root 20 0 10648 792 656 S 0.0 0.0 0:08.99 init [2]
2 root 20 0 0 0 0 S 0.0 0.0 0:00.37 [kthreadd]
3 root 20 0 0 0 0 S 0.0 0.0 0:03.89 [ksoftirqd/0]
5 root 20 0 0 0 0 S 0.0 0.0 0:00.00 [kworker/u:0]Code: Select all
# vmstat 5 5
procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
0 0 0 543528 167960 961532 0 0 2 10 21 31 1 0 98 0
1 0 0 526516 167960 961532 0 0 0 0 57 63 2 0 97 0
2 0 0 505504 167960 961564 0 0 0 160 373 478 14 3 76 0
0 0 0 542792 167960 961584 0 0 0 40 209 239 9 2 85 0
0 0 0 542896 167960 961584 0 0 0 63 48 56 0 0 100 0Code: Select all
>> MySQLTuner 1.1.1 - Major Hayden <[email protected]>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.35-0+wheezy1-log
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 8M (Tables: 125)
[--] Data in InnoDB tables: 752K (Tables: 24)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 2
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 28m 21s (2K q [1.561 qps], 261 conn, TX: 8M, RX: 496K)
[--] Reads / Writes: 97% / 3%
[--] Total buffers: 730.0M global + 1.2M per thread (200 max threads)
[OK] Maximum possible memory usage: 980.0M (48% of installed RAM)
[OK] Slow queries: 3% (80/2K)
[OK] Highest usage of available connections: 1% (3/200)
[OK] Key buffer size / total MyISAM indexes: 194.0M/2.4M
[!!] Key buffer hit rate: 93.6% (24K cached / 1K reads)
[!!] Query cache efficiency: 0.0% (0 cached / 2K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 563 sorts)
[!!] Temporary tables created on disk: 28% (196 on disk / 683 total)
[OK] Thread cache hit rate: 98% (3 created / 261 connections)
[OK] Table cache hit rate: 20% (195 open / 949 opened)
[OK] Open file limit used: 0% (306/65K)
[OK] Table locks acquired immediately: 100% (2K immediate / 2K locks)
[OK] InnoDB data size / buffer pool: 752.0K/8.0M
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Temporary table size is already large - reduce result set size
Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
query_cache_limit (> 88M, or use smaller result sets)Thank you in advance for any hits.
Re: 522 Error Connection timed out (CloudFlare)
Adding TOP as well:
Code: Select all
top - 00:22:13 up 3:18, 1 user, load average: 0.12, 0.11, 0.16
Tasks: 99 total, 3 running, 96 sleeping, 0 stopped, 0 zombie
%Cpu(s): 9.8 us, 2.3 sy, 0.0 ni, 75.6 id, 0.2 wa, 0.0 hi, 0.1 si, 12.0 st
KiB Mem: 2061072 total, 1142500 used, 918572 free, 125960 buffers
KiB Swap: 3837944 total, 0 used, 3837944 free, 628824 cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3629 username 20 0 223m 46m 9208 R 58.5 2.3 0:01.76 php
12283 www-data 20 0 266m 17m 4076 R 25.9 0.9 0:10.41 apache2
17813 mysql 20 0 780m 101m 7824 S 1.3 5.0 0:44.37 mysqld
186 root 20 0 0 0 0 S 0.7 0.0 0:27.57 jbd2/dm-0-8
13 root rt 0 0 0 0 S 0.3 0.0 0:04.81 migration/2
3509 root 20 0 21988 1520 1084 R 0.3 0.1 0:00.23 top
12076 www-data 20 0 52064 2136 800 S 0.3 0.1 0:03.33 nginx
1 root 20 0 10648 792 652 S 0.0 0.0 0:01.36 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.08 kthreadd
3 root 20 0 0 0 0 S 0.0 0.0 0:00.45 ksoftirqd/0
5 root 20 0 0 0 0 S 0.0 0.0 0:00.02 kworker/u:0
6 root rt 0 0 0 0 S 0.0 0.0 0:05.16 migration/0
7 root rt 0 0 0 0 S 0.0 0.0 0:00.55 watchdog/0
8 root rt 0 0 0 0 S 0.0 0.0 0:04.90 migration/1
10 root 20 0 0 0 0 S 0.0 0.0 0:00.32 ksoftirqd/1
12 root rt 0 0 0 0 S 0.0 0.0 0:00.68 watchdog/1
15 root 20 0 0 0 0 S 0.0 0.0 0:00.35 ksoftirqd/2
16 root rt 0 0 0 0 S 0.0 0.0 0:00.40 watchdog/2
17 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 cpuset
18 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 khelper
19 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kdevtmpfs
20 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 netns
21 root 20 0 0 0 0 S 0.0 0.0 0:00.05 sync_supers
22 root 20 0 0 0 0 S 0.0 0.0 0:00.00 bdi-default
23 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kintegrityd
24 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kblockd
27 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khungtaskd
28 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kswapd0
29 root 25 5 0 0 0 S 0.0 0.0 0:00.01 ksmd