Does SQL Query Cache matters on shared hosting?
Query cache, once a popular feature of MySQL database engine was removed from it many years ago. Developers from MariaDB kept it and that was […]
Continue reading »Category: MySQL
MySQL Tuner
Just a small note about amazing tool, that can analyze runtime variables of your MySQL server (also MariaDB) and give overview and recommendations – based […]
Continue reading »
Change all MyISAM tables to InnoDB from shell
A very handy command to change all MyISAM tables for specific database to InnoDB. Just put correct database name instead of dbName . mysql -u […]
Continue reading »
Migrating from Centos to Debian
Little introduction Frustrated as most of you, who has been with CentOS for many years, I have decided to head to Debian. This page will […]
Continue reading »
Compiling PHP7 on server with (old) MySQL 5.6
If you ever need to compile PHP7.0+ on a server where you still are running old MySQL and configuration script complains about not being able […]
Continue reading »
MariaDB 10.2 strict mode settings and compatability with the old code
In MariaDB 10.2 and MySQL 5.7 strict mode is enabled by default. Strict mode tells server to reject SQL queries, that does not pass table […]
Continue reading »
MariaDB 10.2 on cPanel and missing default value
So latest cPanel 66.x offers upgrade for MariaDB to version 10.2, which sounds great if you want to offer latest to your customers. But one […]
Continue reading »Optimizing MySQL, Intermediate results
In the past few weeks we’ve been looking into different MySQL configuration options and were running many simple tests. Even though all tests were different […]
Continue reading »Optimizing MySQL, part 3, mysql cache
In this part we are targeting MySQL cache. On most of our shared-hosting servers more than 50% of all queries are served by MySQL cache. […]
Continue reading »Optimizing MySQL, part 2
Today I wrote new tests. Today tests are targeting 3 large tables, containing from 100’000 to 1’700’000 records. We do huge number of random selects […]
Continue reading »