WordPress.org

Ready to get started?Download WordPress

Forums

W3 Total Cache
[resolved] Optimize MySQL for WordPress/W3 Total Cache and question about Varnish (3 posts)

  1. Julian Fernandes
    Member
    Posted 2 years ago #

    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/

  2. Pothi
    Member
    Posted 2 years ago #

    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.

  3. Julian Fernandes
    Member
    Posted 2 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic