MySQL Forums
Forum List  »  Newbie

Re: I botched my.cnf
Posted by: Peter Brawley
Date: January 18, 2018 11:57AM

> 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.

Options: ReplyQuote


Subject
Written By
Posted
January 18, 2018 09:26AM
January 18, 2018 09:31AM
January 18, 2018 09:40AM
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.