Re: I botched my.cnf
> key_buffer_size=1=64M
You mean 16M?
> open_files_limit=16384
You expect hundreds of simultaneous users? The defaukt of 5000 should suffice unless you see the error Too many open files.
> default-storage-engine=MyISAM
Why? InnoDB is much more tunable and will give better performance.
What version of MySQL is this?
> innodb_flush_log_at_trx_commit=2
1 is probably better. Read about these vars at
https://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html
> Shutting down plugin 'PERFORMANCE_SCHEMA'
The error(s) will be above this in the log.
Subject
Written By
Posted
Re: I botched my.cnf
January 18, 2018 11:57AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.