Lamp Mariadb install error

Current Development version likely to have breaking changes
DVB Hardware
Posts: 201
Joined: Thu Jan 01, 2015 5:12 pm
Location: Rhode Island

Re: Lamp Mariadb install error

Post by DVB Hardware »

Magic919 wrote: Fri Dec 03, 2021 9:13 am Your logs show it is using the default of 128MB

Code: Select all

2021-12-01 15:54:21 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
I'm not sure why you'd want to change it.
I was just following this https://wiki.zoneminder.com/Ubuntu_Serv ... der_1.36.x
I assumed there was a reason for it, not in my skills set. It was crashing mariadb & apache access to zm

Thanks for the update, if you have a spare expendable PC try see if it happens to you all. I have 2 boxes it trashed, remove Innodb it is fine.
I just kept on this because I did not want a newbie trying zm having the same problem. then trashing zm elsewhere

Jimmy
Linux Mint 21 Cinnamon Mariadb 10.6.x using Master 1.37.x latest always

DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: Lamp Mariadb install error

Post by Magic919 »

I have a spare box running Ubuntu 20.04 and have copied those innodb settings into the mysqld section of the MariaDB Debian config file referenced. It works fine.
-
DVB Hardware
Posts: 201
Joined: Thu Jan 01, 2015 5:12 pm
Location: Rhode Island

Re: Lamp Mariadb install error

Post by DVB Hardware »

Version mariadb ? im on 10.6.5
Linux Mint 21 Cinnamon Mariadb 10.6.x using Master 1.37.x latest always

DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: Lamp Mariadb install error

Post by Magic919 »

MariaDB 10.3.31.
-
DVB Hardware
Posts: 201
Joined: Thu Jan 01, 2015 5:12 pm
Location: Rhode Island

Re: Lamp Mariadb install error

Post by DVB Hardware »

I have a few spare drives will try 10.3.31 or what ever the repository will give me
Linux Mint 21 Cinnamon Mariadb 10.6.x using Master 1.37.x latest always

DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
DVB Hardware
Posts: 201
Joined: Thu Jan 01, 2015 5:12 pm
Location: Rhode Island

Re: Lamp Mariadb install error

Post by DVB Hardware »

Magic919 wrote: Fri Dec 03, 2021 4:47 pm MariaDB 10.3.31.
Ok so 10.3.31 works with innodb mod
10.6.5 does not
Linux Mint 21 Cinnamon Mariadb 10.6.x using Master 1.37.x latest always

DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: Lamp Mariadb install error

Post by Magic919 »

That’s interesting. It’s clear the InnoDB part of MariaDB has diverged from the MySQL base on the later version. I couldn’t see anything specific to rule out those config mods.

I’ll bear it in mind for when Ubuntu gets to 10.6 for MariaDB. Hopefully it’ll be clearer by then.
-
Post Reply