#MySQL a 'pretty poor database' says departing Oracle engineer http://www.tuxmachines.org/node/158755#comment-31994

Steinar H. Gunderson Leaving MySQL • Tux Machines ⇨ http://www.tuxmachines.org/node/158755 #mysql #oracle #psql #db

Mein Arbeitgeber hat am Standort Greifswald eine Stelle im IT-Bereich ausgeschrieben.

https://www.fli.de/de/karriere/stellenangebote/einzelansicht/mitarbeiterin-mitarbeiter-im-it-bereich-m-w-d/

#Linux #MySQL #TVÖD

Instalar un stack LAMP en Rocky Linux

https://www.ochobitshacenunbyte.com/2021/09/13/instalar-un-stack-lamp-en-rocky-linux/

#Linux #RockyLinux #Apache #httpd #MariaDB #mysql

Hello #Friendica Admins,
mysqltuner.pl wants me to set "innodb_buffer_pool_size (>= 20.7G)", which is probably because of the #database size. I assigned 20 GB #RAM to the VM and have 20 GB #SWAP too. So setting it that high is not possible, as this would bring the total max #memory usage way beyond 40 GB.

Questions:
1. Why is the total max usage higher than this setting? What is the multiplicand parameter?
2. Any idea how I can set this to use 16 GB for #MySQL all the time, allow double in peak and (swapping then) and not more?

I think I will change the setup at some point which will free more RAM for #mariadb, but now I need to cope with it like it is. I see loading time it really bad with low settings for "innodb_buffer_pool_size", like 0.4 seconds over all, more RAM reduces it by 70%... but then I get omm (out of memory) problem.

!Friendica Admins

los primeros numero de mysql en munin.

















poquitos datos recolectados, lo encendi recien. vere mas adelante que dice.

#munin #mysql #reisub