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 »Tag: configuration
Only allow to view images from a folder with simple .htaccess file
Once in a while my beloved hackers upload their shitty files into image folder (basically they use some plugin for image upload). In most cases […]
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 »Optimizing MySQL, part 1
MySQL is a most popular database management system. It can be configured to match your needs using huge amount of options and settings. But which […]
Continue reading »