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 (: