2.6.1.11. MySQL server configuration

Version

On businesshosting can change MySQL version.

Текущую версию MySQL-сервера can узнать несколькими способами:

  • View in phpMyAdmin:
  • Execute SQLquery:
    SELECT VERSION();
  • Connect to hosting via SSH and execute any of the commands:
    • mysql -V
    • mysql --version

Options

Options not available for global change, поскольку это затронет всех клиентов на сервере. Однако для некоторых параметров can изменять значения session level.

All parameters and values

Список всех параметров MySQL-сервера и их значения can просмотреть несколькими способами:

system_time_zone

Timezone. Can be modified with a request at the session level: 

SET time_zone = '+03:00';

We recommend that you study the documentation for your CMS, framework, scripts and set the right time using their own tools.

max_allowed_packet

The maximum packet size. It is 16 MB and cannot be changed.

group_concat_max_len

Maximum allowed result length in bytes for a function GROUP_CONCAT(). Can be modified with a request at the session level: 

SET group_concat_max_len = 10000;

Events

On виртуальном хостинге и businesshosting scheduler disabled (parameter event_scheduler isequalto OFF) and cannot be enabled. To run scheduled tasks, use alternative methods, for example cron.

Content