Re: I botched my.cnf

[Mike Franklin]

Just tried this new cnf and still no joy.

[mysqld]
performance-schema=0
innodb_file_per_table=1
query_cache_size=128M
thread_cache_size=4
key_buffer_size=1=64M
max_allowed_packet=268435456
table_open_cache=512
wait_timeout=300
max_user_connections=64
open_files_limit=16384
myisam_sort_buffer_size=4M
collation_server=utf8_unicode_ci
character_set_server=utf8
innodb_buffer_pool_size=1G
innodb_thread_concurrency=8
tmp_table_size=768M
max_heap_table_size=768M
max_connections=125
table_definition_cache=512
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=128M
general_log=0
slow_query_log=0
log-output=TABLE
long_query_time=20
innodb_io_capacity=100
default-storage-engine=MyISAM


Error log only shows the server shutting down. Nothing for restarting.


2018-01-18 10:36:34 5846 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-01-18 10:36:34 5846 [Note] Shutting down plugin 'MRG_MYISAM'
2018-01-18 10:36:34 5846 [Note] Shutting down plugin 'CSV'
2018-01-18 10:36:34 5846 [Note] Shutting down plugin 'MEMORY'
2018-01-18 10:36:34 5846 [Note] Shutting down plugin 'MyISAM'
2018-01-18 10:36:34 5846 [Note] Shutting down plugin 'sha256_password'
2018-01-18 10:36:34 5846 [Note] Shutting down plugin 'mysql_old_password'
2018-01-18 10:36:34 5846 [Note] Shutting down plugin 'mysql_native_password'
2018-01-18 10:36:34 5846 [Note] Shutting down plugin 'binlog'
2018-01-18 10:36:34 5846 [Note] /usr/sbin/mysqld: Shutdown complete