MariaDB / MySQL

110 readers

2 users here now

Community for MariaDB/MySQL users

founded 2 years ago

MODERATORS

[email protected]

What do users of MariaDB in Debian/Ubuntu want to see in future versions? (self.mariadb_mysql)

submitted 3 days ago by otto to c/[email protected]

3 comments fedilink hide all child comments

Besides having the latest version available, what do Debian/Ubuntu users who run MariaDB wish to see in future versions of MariaDB, or how it is integrated and packaged in Debian?

I am the maintainer in Debian and Ubuntu - looking for feedback and ideas.

you are viewing a single comment's thread
view the rest of the comments

[–] otto 2 points 2 days ago (1 children)

Yes, increasing the InnoDB buffer pool to use all available memory is the most important configuration change a sysadmin can do. But in order to do it, you need to know if the host is dedicated to one MariaDB instance or if there are multiple servers on the same host. Otherwise you would just have processes each hogging more memory when they can and not giving it up to others.

I could think about having a dialog during the installation that asks something like "Is host dedicated to this MariaDB instance? If yes, automatically configure it to use most of the system RAM available."

[–] [email protected] 1 points 2 days ago

Not even a dialog, just a variable in my.cnf that enables it, like setting ibps manually. (And there are other buffers that maria might benefit from some extra growth if it knows it has space)