Skip to main content

Search

Items tagged with: mariadb


Eliminar # e instalar # en # 20.04
https://blonder413.wordpress.com/2022/03/17/eliminar-mysql-e-instalar-mariadb-en-ubuntu-20-04/


Ya esta disponible el quinto capitulo del #curso de #mariadb #nodejs para crear un #webservice

https://patojad.com.ar/programacion/2021/08/webservice-nodejs-y-mariadb-5-accediendo-a-nuestra-db-mediante-la-api/


Ya esta disponible el tercer capitulo del curso de #mariadb #nodejs para crear un #webservice

https://patojad.com.ar/programacion/2021/08/webservice-nodejs-y-mariadb-3-conector-mariadb-en-nodejs/


Since a few days sometimes my #mariadb load spikes to 140, anyone else see this, it just takes 1 minute and normalizes again. till now I was to slow to capture the mytop view, just the end of such thing in this capture.

When it is over the load normalizes at 0.8 again.

@Steffen K9 🐰 did you experience anything like that? I saw it twice, once yesterday and just now.
@Michael Vogel any idea what happens?



#friendica !Friendica Support


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

Este sitio web utiliza cookies. Si continúa navegando por este sitio web, usted acepta el uso de las cookies.