mysql

Администратор Development

 

Настройки mysql


  show variables like 'max_connections';
  SET GLOBAL max_connections = 1500;


 Mysql 5.7
  sql_mode="ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
  max_allowed_packet          = 16M
  key_buffer_size             = 16M
  innodb_buffer_pool_size     = 8G (половина оперативной)
  innodb_file_per_table       = 1
  innodb_flush_method         = O_DIRECT
  innodb_flush_log_at_trx_commit  = 0
  max_connections             = 1500 https://dba.stackexchange.com/questions/1229/how-do-you-calculate-mysql-max-connections-variable
  expire_logs_days            = 10
  max_binlog_size             = 100M
  slow_query_log = /var/log/mysql/mysql-slow.log
  long_query_time = 3