Issue Innodb_buffer_pool_size

[Larsm]

Hello,

I get this error when I check the plesk installation.
```
mysql: [ERROR] unknown variable 'innodb_buffer_pool_size=512M'
mysql: [ERROR] unknown variable 'innodb_buffer_pool_size=512M'
failed

ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_17.5.3_repair.log), fix and try again

***** problem report *****
ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_17.5.3_repair.log), fix and try again

Checking the Plesk database using the native database server tools .. [OK]

Checking the structure of the Plesk database ........................ [OK]

Checking the consistency of the Plesk database ...................... [OK]

Checking system users ............................................... [OK]

Checking Linux system files ......................................... [OK]

Checking virtual hosts' file system

There are files or directories with suspicious permissions in the
root directory of the domain 'analytics.larsmueller.net' .......... [WARNING]
To see more details, run the command in the verbose mode: plesk repair fs -verbose

Repairing web server configuration
Reinstalling SSL/TLS certificates ............................... [OK]
Applying the default SSL/TLS certificate to all IP addresses .... [OK]
Repairing server-wide configuration parameters for web servers .. [OK]
Updating the file of sharing passwords and permissions of users
according to actual information ................................. [OK]
Repairing web server configuration for all domains. This aspect
can be used with individual domains ("plesk repair web
example.com"), and on the server level ("plesk repair web") ..... [OK]

Checking the usage of PHP handlers .................................. [OK]

Repairing the mail server configuration
Reconfiguring all domains and mailboxes ......................... [OK]

Checking the DNS configuration file ................................. [OK]

Restoring DNS server configuration
Synchronizing DNS zones with the DNS server ..................... [OK]

Checking MySQL database servers ..................................... [OK]

Repair databases on available servers ............................... [OK]

Repair database users on available servers .......................... [OK]

Error messages: 0; Warnings: 1; Errors resolved: 0


exit status 1
```

How can I solve this error?

my /etc/mysql/my.cnf has no 'innodb_buffer_pool_size=512M' Variable.

Beat regards

Lars

Gesendet von meinem G8341 mit Tapatalk

 

[Larsm]

Has anyone an idea? I changed the size. Like this howto. MySQL :: MySQL 5.7 Reference Manual :: 14.6.3.2 Configuring InnoDB Buffer Pool Size

But the same output.
I have no idea what can I do.

Gesendet von meinem G8341 mit Tapatalk

 

[G J Piper]

my /etc/mysql/my.cnf has no 'innodb_buffer_pool_size=512M' Variable.

See if there is another config here: /etc/my.cnf

Also, please show us the entire contents of your my.cnf file if you could.

 

[Larsm]

See if there is another config here: /etc/my.cnf

Also, please show us the entire contents of your my.cnf file if you could.

I have three my.cnf files


With this Content

/etc/mysql/my.cnf

```
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
sql_mode=ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
bind-address = ::ffff:127.0.0.1
local-infile=0
```

/etc/alternatives/my.cnf

```
~ ~ # The files must end with '.cnf', otherwise they'll be ignored. # !includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/ [mysqld] local-infile=0 ~ ~ ~ ~
```
and /var/lib/dpkg/alternatives/my.cnf

```
auto
/etc/mysql/my.cnf

/etc/mysql/my.cnf.fallback
100
/etc/mysql/mysql.cnf
200
```

When I search in mysql database there is also an Entry:

mysql> show variables like 'innodb_%';


| innodb_buffer_pool_size | 2147483648 |


Gesendet von meinem G8341 mit Tapatalk

 

[G J Piper]

Wow tell you the truth that seems like quite a jumble of fairly useless settings to me.
There must be another settings file somewhere giving it that error.

I'd also look in Tools & Settings -> Database Servers and see if you're dealing with more than one installation of MySQL or something.

 

[Larsm]

There is Only one entry. Localhost.

I did not change anything here.

Gesendet von meinem G8341 mit Tapatalk

 

[speedbird]

There is no /etc/my.cnf ? That's where mine resides. However, it shouldn't say that the variable is unknown anyway.

 

[Larsm]

There is no /etc/my.cnf ? That's where mine resides. However, it shouldn't say that the variable is unknown anyway.

That's my config files

/etc/alternatives/my.cnf                                    
/etc/mysql/my.cnf                                           
/var/lib/docker/aufs/diff/eb785493b1aec9b8b8c5a13127e472584b
858a8bae8b845e76ba74b5e6be54a0/etc/mysql/my.cnf             
/var/lib/docker/aufs/diff/5e84df57856a0325e8e7544384beee4399
53e784828865702706e463e528f323/etc/mysql/my.cnf             
/var/lib/dpkg/alternatives/my.cnf

Gesendet von meinem G8341 mit Tapatalk

 

[Larsm]

I have an Update,

I set the innodb_buffer_pool_size to 5G via /etc/mysql/my.cnf

mysql> show global variables like 'innodb_buffer_pool%';
+-------------------------------------+----------------+
| Variable_name                       | Value          |
+-------------------------------------+----------------+
| innodb_buffer_pool_chunk_size       | 134217728      |
| innodb_buffer_pool_dump_at_shutdown | ON             |
| innodb_buffer_pool_dump_now         | OFF            |
| innodb_buffer_pool_dump_pct         | 25             |
| innodb_buffer_pool_filename         | ib_buffer_pool |
| innodb_buffer_pool_instances        | 8              |
| innodb_buffer_pool_load_abort       | OFF            |
| innodb_buffer_pool_load_at_startup  | ON             |
| innodb_buffer_pool_load_now         | OFF            |
| innodb_buffer_pool_size             | 17179869184    |
+-------------------------------------+----------------+
10 rows in set (0,00 sec)

That works after mysql reload. But I get the message when I backup a domain.

Warning: mysql "netzcloud"
Failed to execute backup database

Warning: mysql "netzcloud"
Not all the data was backed up into /var/lib/psa/dumps/clients/Larsm/domains/dasnetzundich.de/databases/netzcloud_1 successfully. Total space: 3932808151040; Available space: 3321375203328; Mounted on: /. mysql: [ERROR] unknown variable 'innodb_buffer_pool_size=512M' mysql: [ERROR] unknown variable 'innodb_buffer_pool_size=512M' mysql: [ERROR] unknown variable 'innodb_buffer_pool_size=512M' Can't call method "dumpCmdline" without a package or object reference at /opt/psa/PMM/agents/shared/Db/Connection.pm line 115.

Whats wrong? I checked all my.cnf files but no variable present like "'innodb_buffer_pool_size=512M'"
That's curious.

Gesendet von meinem G8341 mit Tapatalk

 

[virtubox]

I have an Update,

I set the innodb_buffer_pool_size to 5G via /etc/mysql/my.cnf

mysql> show global variables like 'innodb_buffer_pool%';
+-------------------------------------+----------------+
| Variable_name                       | Value          |
+-------------------------------------+----------------+
| innodb_buffer_pool_chunk_size       | 134217728      |
| innodb_buffer_pool_dump_at_shutdown | ON             |
| innodb_buffer_pool_dump_now         | OFF            |
| innodb_buffer_pool_dump_pct         | 25             |
| innodb_buffer_pool_filename         | ib_buffer_pool |
| innodb_buffer_pool_instances        | 8              |
| innodb_buffer_pool_load_abort       | OFF            |
| innodb_buffer_pool_load_at_startup  | ON             |
| innodb_buffer_pool_load_now         | OFF            |
| innodb_buffer_pool_size             | 17179869184    |
+-------------------------------------+----------------+
10 rows in set (0,00 sec)

That works after mysql reload. But I get the message when I backup a domain.

Warning: mysql "netzcloud"
Failed to execute backup database

Warning: mysql "netzcloud"
Not all the data was backed up into /var/lib/psa/dumps/clients/Larsm/domains/dasnetzundich.de/databases/netzcloud_1 successfully. Total space: 3932808151040; Available space: 3321375203328; Mounted on: /. mysql: [ERROR] unknown variable 'innodb_buffer_pool_size=512M' mysql: [ERROR] unknown variable 'innodb_buffer_pool_size=512M' mysql: [ERROR] unknown variable 'innodb_buffer_pool_size=512M' Can't call method "dumpCmdline" without a package or object reference at /opt/psa/PMM/agents/shared/Db/Connection.pm line 115.

Whats wrong? I checked all my.cnf files but no variable present like "'innodb_buffer_pool_size=512M'"
That's curious.

Gesendet von meinem G8341 mit Tapatalk

Check if there are other configuration folders included in your my.cnf file, some directives like

includedir /etc/mysql/conf.d/

You can also check if the directive innodb_buffer_pool_size=512M exist with

cat /etc/mysql/my.cnf | grep pool_size

 

[Larsm]

Check if there are other configuration folders included in your my.cnf file, some directives like

includedir /etc/mysql/conf.d/

You can also check if the directive innodb_buffer_pool_size=512M exist with

cat /etc/mysql/my.cnf | grep pool_size

I found it in the conf.d directory. Thanks for your help.

Gesendet von meinem G8341 mit Tapatalk

 

[AdrianC]

I had this error today, it was because in /etc/my.cnf I was adding the config variables before "[mysqld]" area of that config file.
My variables should be after [mysqld]

 

[Bitpalast]

And also remember that you need to add your configuration to both, the [mysqld] and [mysqldump] sections. An entry in the [mysqld] section works for the live operations of the database server, but will not work for the dump, e.g. when a backup is created.

 

[johnson113]

try this.
/etc/alternatives/my.cnf
/etc/mysql/my.cnf
/var/lib/docker/aufs/diff/eb785493b1aec9b8b8c5a13127e472584b
858a8bae8b845e76ba74b5e6be54a0/etc/mysql/my.cnf
/var/lib/docker/aufs/diff/5e84df57856a0325e8e7544384beee4399
53e784828865702706e463e528f323/etc/mysql/my.cnf
/var/lib/dpkg/alternatives/my.cnf