How to change MySQL/MariaDB innodb_log_file_size value?

How to change MySQL/MariaDB innodb_log_file_size value?

You might be a long way to find innodb_log_file_size values in MySQL/MariaDB.

For Linux users:

Step 1:
Use SSH to get connect Plesk server

Step 2: Now stop the service of MySQL and choose the command by selecting the version MySQL or OS:

Code:
# servicemariadb stop
# servicemysql stop
Step 3: Use text editor vi editor to open the file MySQL configuration:

The ubuntu-based distribution in Debian:

Code:
# vi /etc/mysql/my.cnf
The RHEL-based distribution in CentOS:

Code:
# vi /etc/my.cnf
Step 4: As per our requirement, you can make changes in innodb_file_size in the section of [mysqld]. Sometimes, you won’t see the file there so, better go add it new in the same section:

Code:
[mysqld]
<...>
innodb_log_file_size=128M
<...>
Step 5: You need to move two files such as ib_logfile1 and ib_logfile0 directly to the directory of your choice.

To the root, you can move them:

Code:
# mv /var/lib/mysql/ib_log* /root
Step 6: You would have stopped the MySQL service at starting now restart again using the command:

Code:
# servicemariadb start
# servicemysql start
For Windows server:

Here comes the question:


Where you will be finding the customer database in the MySQL server? Check-in
Code:
%plesk_dir%Databases\MySQL\
Again, where you will be finding the Plesk system database in the Plesk SQL server? Check-in
Code:
%plesk_dir%MySQL\
Step 1: Use RDP, to connect Plesk server. You can see the MySQL configuration file only by using the text editor:

Plesk SQL server:

Code:
C:\>%plesk_dir%MySQL\my.ini
MySQL server:

Code:
C:\>%plesk_dir%Databases\MySQL\my.ini
Step 2: Make changes in the file innodb_log_file_size in the section [mysqld]:

Code:
innodb_log_file_size=128M
Step 3: Start removing the redo log files in

MySQL server: Move on to the folder %plesk_dir%Databases\MySQL\data and start deleting the file ib_logfile0 and ib_logfile1

Plesk SQL server: To delete the file ib_logfile0 and ib_logfile1, go to the folder %plesk_dir%MySQL\Data

Step 4: Use the Plesk server monitor or Windows services to start MySQL57 or Plesk SQL Server.
Author
kumkumsharma
Views
2,306
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from kumkumsharma

Top