Hello, I am struggling with my database
MariaDB 10.3.27-MariaDB
First Problem - MySQL Tuner:
I try run mysqltuner script to diagnose and optimize the database and I get false data of:
[OK] Maximum reached memory usage: 2.4G (60.47% of installed RAM)
[!!] Maximum possible memory usage: 27.1G (677.32% of installed RAM)
Second Problem Sockets / Permissions:
another issue i tried connect socket in my cnf with
[MySQL]
socket=/var/lib/mysql/mysql.sock
[mysqld]
socket=/var/lib/mysql/mysql.sock
what actually the default via unix and port 3306.
but for some reason, the tuner got a block and the interface of:
whm>MySQL process
gut block from data as well and show black page.
(this because in centos07 systemctl running MySQL / maria db as a root)
So... i start to check permissions.
first, i check:
/etc/my.cnf (own by root)
after that i see the:
/etc/my.cnf.d (own by root as well)
then i check the last folder:
/var/lib/mysql (own by MySQL as a user and a group mysql:mysql )
now i thinking to myself.
how is even possible?
if root runs my.cnf, how "mysql:mysql" run all the folders alone?
When i connect the sockets as i told you before in my.cnf.
i get a permission problem, so I start to understand [mysql] is maybe a stand-alone socket?
and [mysqld] is stand alone as well?
or root permission actually can access MySQL folder? (/var/lib/mysql)
Please help, at least with the tuner and the fake usage.
(this fake usage, when you get inside process manager mysql PID is 12% - 20%)
WHM>SERVICE STATUS
shows have more than 2 and a half gigabit available.
This is means, the tuner shows fake results.
I am not able to optimize and use all the resources of the database server.
Please help
MariaDB 10.3.27-MariaDB
- CENTOS 7.9 virtuozzo [server]
- v92.0.9
First Problem - MySQL Tuner:
I try run mysqltuner script to diagnose and optimize the database and I get false data of:
[OK] Maximum reached memory usage: 2.4G (60.47% of installed RAM)
[!!] Maximum possible memory usage: 27.1G (677.32% of installed RAM)
Second Problem Sockets / Permissions:
another issue i tried connect socket in my cnf with
[MySQL]
socket=/var/lib/mysql/mysql.sock
[mysqld]
socket=/var/lib/mysql/mysql.sock
what actually the default via unix and port 3306.
but for some reason, the tuner got a block and the interface of:
whm>MySQL process
gut block from data as well and show black page.
(this because in centos07 systemctl running MySQL / maria db as a root)
So... i start to check permissions.
first, i check:
/etc/my.cnf (own by root)
after that i see the:
/etc/my.cnf.d (own by root as well)
then i check the last folder:
/var/lib/mysql (own by MySQL as a user and a group mysql:mysql )
now i thinking to myself.
how is even possible?
if root runs my.cnf, how "mysql:mysql" run all the folders alone?
When i connect the sockets as i told you before in my.cnf.
i get a permission problem, so I start to understand [mysql] is maybe a stand-alone socket?
and [mysqld] is stand alone as well?
or root permission actually can access MySQL folder? (/var/lib/mysql)
Please help, at least with the tuner and the fake usage.
(this fake usage, when you get inside process manager mysql PID is 12% - 20%)
WHM>SERVICE STATUS
shows have more than 2 and a half gigabit available.
This is means, the tuner shows fake results.
I am not able to optimize and use all the resources of the database server.
Please help
Last edited by a moderator: