MariaDB Is it safe to use my-mdb10-4gb.cnf on a 3GB VPS?

Mike Guista · Oct 10, 2014

I've a 3GB VPS where I have just installed Centos 7 for centos .08 beta installation. Is it safe to use my-mdb10-4gb.conf on a 3GB VPS?

eva2000 · Oct 10, 2014

hard to say without knowing your system and mariadb mysql server's memory usage

you can try it and monitor memory usage over time

if the innodb_log_file_sizes differ in my.cnfs you'd want to initially set the 4gb cnf to same size as existing /etc/my.cnf or adjust innodb_log_file_size as per MySQL :: MySQL 5.6 Reference Manual :: 14.5.7 Changing the Number or Size of InnoDB Log Files and Resizing the InnoDB Tablespace

Changing the Number or Size of InnoDB Log Files
To change the number or size of InnoDB redo log files in MySQL 5.6.7 or earlier, perform the following steps:

If innodb_fast_shutdown is set to 2, set innodb_fast_shutdown to 1:

mysql> SET GLOBAL innodb_fast_shutdown = 1;

After ensuring that innodb_fast_shutdown is not set to 2, stop the MySQL server and make sure that it shuts down without errors (to ensure that there is no information for outstanding transactions in the log).

Copy the old log files into a safe place in case something went wrong during the shutdown and you need them to recover the tablespace.

Delete the old log files from the log file directory.

Edit my.cnf to change the log file configuration.

Start the MySQL server again. mysqld sees that no InnoDB log files exist at startup and creates new ones.

Click to expand...

Log in / Register

Forums

Welcome to Centmin Mod Community

MariaDB Is it safe to use my-mdb10-4gb.cnf on a 3GB VPS?

Mike Guista New Member

eva2000 Administrator Staff Member

.

Log in / Register

Useful Searches

Welcome to Centmin Mod Community

MariaDB Is it safe to use my-mdb10-4gb.cnf on a 3GB VPS?

Mike Guista New Member

eva2000 Administrator Staff Member

.