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

0 Members and 1 Guest are viewing this topic.

Offline
*
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]
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
« Last Edit: December 19, 2021, 04:21:24 PM by shoulders »