Messages

46

MySQL / 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

47

CentOS-WebPanel GUI / Re: Cgroup In Package Creation Question

« on: June 27, 2021, 04:59:32 PM »

I am trying to setup cgroups and noticed that in packages I have to use a number to assign a cgroup but I cannot get the relevant number from the policy page.

Is this still an issue or am I doing some thing dumb.

thanks