История изменений
Исправление try20, (текущая версия) :
Пробовал вот так в my.cnf, то же самое, но сейчас в дефолтном состоянии, за исключением описанного выше:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
max_connections = 64
key_buffer_size = 16M
innodb_buffer_pool_size = 32M
innodb_buffer_pool_instances = 2
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 2
thread_cache_size = 8
query_cache_size = 20M
query_cache_limit = 2M
max_heap_table_size = 8M
tmp_table_size = 8M
init_connect=‘SET collation_connection = utf8_unicode_ci’
character-set-server = utf8
collation-server = utf8_unicode_ci
sql_mode = «ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATES»
[client] default-character-set = utf8
Исходная версия try20, :
Пробовал вот так в my.cnf, то же самое:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
max_connections = 64
key_buffer_size = 16M
innodb_buffer_pool_size = 32M
innodb_buffer_pool_instances = 2
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 2
thread_cache_size = 8
query_cache_size = 20M
query_cache_limit = 2M
max_heap_table_size = 8M
tmp_table_size = 8M
init_connect=‘SET collation_connection = utf8_unicode_ci’
character-set-server = utf8
collation-server = utf8_unicode_ci
sql_mode = «ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATES»
[client] default-character-set = utf8