Question
suggestion for speed, performance, server optimization .
hi,
i have a website which was 512Mb Droplet , it had 700,0000 post all imported using data feeds of products. the website database use to crash often , so i upgraded on 1Gb droplet.
But the problem are still the same,
- website is slow takes too long to load
- Wordpress Admin panel more slow. *importing more products is still slow (previously it used to import 500 products in 1 minute now it takes more then 15min for it ) *database crashes (before it used to crash 5 times a day ,now 2 times a day).
this are some of the problems i am facing , cant afford higher droplet .being a student , i am tight on budget :(
So guys please help me out by recommending best practice, solutions , plugin, advice regarding this.
Thanks in advance ,
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
First, you need to share more information about the current setup.
mysql stats - install http://mysqltuner.com/
Memory usage - http://www.cyberciti.biz/faq/linux-check-memory-usage/
A. free -t -m
B. top (Press M to display top services using memory)
C. http://www.commandlinefu.com/commands/view/3/display-the-top-ten-running-processes-sorted-by-memory-usage
Cheers,
Gio
auto-rehash TRUEauto-vertical-output FALSE
character-sets-dir (No default value)
column-type-info FALSE
comments FALSE
compress FALSE
debug-check FALSE
debug-info FALSE
database (No default value)
default-character-set auto
delimiter ;
enable-cleartext-plugin FALSE
vertical FALSE
force FALSE
named-commands FALSE
ignore-spaces FALSE
init-command (No default value)
local-infile FALSE
no-beep FALSE
host (No default value)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 3306
prompt mysql>
quick FALSE
raw FALSE
reconnect TRUE
socket /var/run/mysqld/mysqld.sock
ssl FALSE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-key (No default value)
ssl-verify-server-cert FALSE
table FALSE
user (No default value)
safe-updates FALSE
i-am-a-dummy FALSE
connect-timeout 0
max-allowed-packet 16777216
net-buffer-length 16384
select-limit 1000
max-join-size 1000000
secure-auth FALSE
show-warnings FALSE
plugin-dir (No default value)
default-auth (No default value)
10.
A.
total used free shared buffers cachedMem: 994 924 69 23 5 461
-/+ buffers/cache: 457 536
Swap: 4095 51 4044
Total: 5090 976 4113
B.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND13092 www-data 20 0 318924 32164 23540 S 21.2 3.2 0:03.50 apache2
12741 mysql 20 0 2337664 299500 2800 S 1.9 29.4 9:25.57 mysqld
13095 root 20 0 105632 2544 1472 S 0.6 0.2 0:00.30 sshd
1 root 20 0 33496 1144 76 S 0.0 0.1 0:05.49 init
c.
root@Zhopon:~# ps aux | sort -nk +4 | tailwww-data 13012 0.7 3.1 318924 32120 ? S 22:22 0:18 /usr/sbin/apache2 -k start
www-data 13238 0.6 3.1 318924 32428 ? S 22:55 0:01 /usr/sbin/apache2 -k start
www-data 12373 0.4 3.2 321260 33248 ? S 21:43 0:20 /usr/sbin/apache2 -k start
www-data 13018 0.6 3.2 319188 32580 ? S 22:24 0:12 /usr/sbin/apache2 -k start
www-data 13091 0.7 3.2 319188 32700 ? S 22:49 0:04 /usr/sbin/apache2 -k start
www-data 13092 0.6 3.2 319436 32796 ? S 22:49 0:04 /usr/sbin/apache2 -k start
www-data 13090 0.9 3.3 321508 33704 ? S 22:49 0:06 /usr/sbin/apache2 -k start
www-data 13088 0.4 4.5 333288 46456 ? S 22:48 0:02 /usr/sbin/apache2 -k start
www-data 12545 0.6 4.8 336620 49476 ? S 21:46 0:27 /usr/sbin/apache2 -k start
mysql 12741 19.1 29.4 2337664 300036 ? Ssl 22:10 9:27 /usr/sbin/mysqld
hope all this helps
Can you help me out