Author Topic: Configure InnoDB as default engine but my.cnf is empty  (Read 2089 times)

0 Members and 1 Guest are viewing this topic.

Configure InnoDB as default engine but my.cnf is empty
« 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]
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
# 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)

« Last Edit: December 19, 2021, 04:21:24 PM by shoulders »