WordPress.org

Support

Support » Plugins and Hacks » [Resolved] Optimize MySQL for WordPress/W3 Total Cache and question about Varnish

[Resolved] Optimize MySQL for WordPress/W3 Total Cache and question about Varnish

  • Hello,

    I’m setting up my first VPS and it seems to be working well. Installed Nginx, php-fpm (as a unix socket), APC, Varnish and MySQL on Ubuntu 12.04 server with OnApp, and everything works and is damm fast.

    So i optimized Nginx, php-fpm, APC, configured Varnish… but i have two questions left.

    Atm i have a VPS with 1 core, 1.2GHz and 768MB RAM. How can i optimize MySQL for it? I tryed to use a https://tools.percona.com/, but it gave me some really big numbers, and most of them made the MySQL to stop starting, so i had to go back to where i was.

    I will use this VPS for a WordPress website with about 5k daily visitors and 13~15k daily pageviews. W3 Total Cache is setup to do database and object cache using APC, and minify/page cache with disk enhanced… but before i migrate the site to this server and go live with it, i want to optimize MySQL.

    Anyone can help me optimize it?

    My my.conf looks like this atm: http://pastebin.com/x22hLjDc

    Also, how do i know Varnish is working with WordPress? I know i have to make some specific configs to varnish and WP play well together, and i did follow this https://github.com/nicolargo/varnish-nginx-wordpress, but how do i know it’s working?

    Thanks in advanced everyone (:

    http://wordpress.org/extend/plugins/w3-total-cache/

Viewing 2 replies - 1 through 2 (of 2 total)
  • how do i know Varnish is working with WordPress?

    You may do the following steps to check if Varnish is working with WordPress

    1. Set the TTL to 120 seconds (the default value in most setups I have seen), in Varnish.
    2. Visit your site’s home page as a non-logged-in user.
    3. Turn off MySQL and/or PHP.
    4. Try to login to the WP backend (to make sure PHP or MySQL is really turned off). You wouldn’t be able to login now.
    5. Visit your site’s home page as a non-logged-in user.
    6. If the home page shows up, Varnish is working.

    Instead of home page, you may use any other page or post. You may want to purge its cache before doing this tiny test that may fail, if the TTL expires just before step #5.

    Thanks for the answer @pothi! Helped a lot (:

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Resolved] Optimize MySQL for WordPress/W3 Total Cache and question about Varnish’ is closed to new replies.