hosting.guru blog

…just a few extra words about hosting

  • hosting.guru
  • Home
  • Service
  • Contact me

Tag: mysql

Compiling PHP7 on server with (old) MySQL 5.6

Posted on April 26, 2018

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 »
0
Linux, MySQL, PHP

MariaDB 10.2 strict mode settings and compatability with the old code

Posted on February 6, 2018

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 »
0
MySQL

Optimizing MySQL, Intermediate results

Posted on October 27, 2015

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 »
0
MySQL

Optimizing MySQL, part 3, mysql cache

Posted on October 27, 2015

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 »
0
MySQL

Optimizing MySQL, part 2

Posted on October 27, 2015

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 »
0
MySQL

Optimizing MySQL, part 1

Posted on October 27, 2015

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 »
0
MySQL

Categories

  • apache
  • Linux
  • MySQL
  • Online tools
  • PHP
  • Security
  • Wordpress
hosting.guru - professional help in any hosting related question
Powered by WordPress and Momentous.