Control Web Panel

WebPanel => MySQL => Topic started by: shoulders on December 19, 2021, 04:15:07 PM

Title: Configure InnoDB as default engine but my.cnf is empty
Post by: shoulders on December 19, 2021, 04:15:07 PM

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

Code: [Select]

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.

Code: [Select]

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