suggestion for speed, performance, server optimization .

September 3, 2014 2.5k views
moin5050
By:
moin5050

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 ,

3 comments
  • gio.arteaga September 4, 2014

    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

  • moin5050 September 4, 2014
    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-rehash TRUE
    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

  • moin5050 September 8, 2014

    Can you help me out

Log In to Comment
1 Answer
moin5050 September 4, 2014
[deleted]
Reply
Have another answer? Share your knowledge.