Question

suggestion for speed, performance, server optimization .

  • Posted September 3, 2014

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 ,

Subscribe
Share

Can you help me out

  1. i have installed one click WordPress Ubuntu 14.04 , NO control panel
  2. NO idea about this.
  3. default (one click WordPress setting)
  4. default (one click WordPress setting)
  5. WordPress 3.9 , 11 plugins
  6. No i haven’t installed any cache plugin yet.
  7. no I am not (please provide me with the links to any tutorial regarding this)
  8. no firewall
  9. mysql stats
auto-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     cached
Mem:           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+ COMMAND
13092 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 | tail
www-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 

First, you need to share more information about the current setup.

  1. OS installed. Did you install any control panel?
  2. what web server did you install? If Apache, what method was it installed dso, fcid, php-fpm, cgi?
  3. Sample apache configuration parameters.
  4. What modules are installed for php?
  5. What version of WordPress? How many plugins are installed with wp?
  6. Have you considered installed a cache plugin for WP?
  7. Are you blocking useless bot accessing your site, which often steal memory resources?
  8. Firewall?
  9. Mysql configuration and stats? http://mysqltuner.com/
  10. Can you provide some basic statistics about mysql and the OS? Mysql stats? Current os memory allocation? Service memory allocations?

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


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

This comment has been deleted