I want to use InnoDB as my default database engine because it is more resilient to crashes and other things.
I know I can just add the following to
my.cnf file
default-storage-engine=InnoDB
But I also need to configure the InnoDB engine.
However I expected all of the InnoDB database (and other) settings to be present in
my.cnf but the file is practically blank.
I dont know if this is a bug.
#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# include *.cnf from the config directory
#
!includedir /etc/my.cnf.d
- Should this file have some default settings in it?
- is the default database engine setup by CWP InnoDB or is it MyISAM?
- Does anyone have a my.cnf configured with InnoDB settings?
I am not an expert in database architecture.
I think this file should be updated by the CWP team with some basic settings. I do understand there are many different setups but a baseline would be useful. Xampp and cPanel manage to do this.
Any help would be appreciated (explanations/my.cnf file/tutorial on what next)
shoulders