To optimize every table in all databases on the server, just run this command:
mysqlcheck -o --all-databases -u root -p
In case you want to optimize tables for a single database:
mysqlcheck -o <db_name> -u root -pMonth: April 2016
HTTP/2 performance comparison (case study)
Couple of days ago nginx released nginx-1.10.0 stable version with http2 support.
I was already running nginx from their repos on couple of servers, and as the upgrade was possible just by running apt-get upgrade and adding a single parameter to config file, I decided to give it a try immediately.
I knew http2 use should impact sites with lots of http requests the most, so I compared the results from my hobby site for Latvian gamers – https://exs.lv/ – which has quite a lot of small images and other assets. I removed 3rd party ads so they don’t impact the load times and run couple of tests using gtmetrix.com. The results were pretty impressive for changing a single line of code. Continue reading