Questions tagged [mariadb]
The mariadb tag has no summary.
172 questions
0votes
0answers
20views
SQL request with multiple sorting [migrated]
A mariaDB table records the connections of users to some pages date userID pagenumber (int) There are about 150.000 lines. I want to create a new table like this; UserID (unique) Howmanytimes (number ...
- 1
0votes
0answers
59views
Install mysql (not mariadb) on raspbian bookworm and other debian
There are many servers in the network that I manage, and throughout that network, mysql is the standard and only "mysql-like" database used. (There's some postgre but that is another matter)...
- 101
0votes
0answers
82views
single node Slurm machine, munge authentication problem
I'm in the process of setting up a singe-node Slurm workstation machine and I believe I followed the process closely and everything is working just fine. See below: sudo systemctl restart slurmdbd &...
- 199
-1votes
1answer
83views
MariaDB password only works if passed as command line argument
If I try to login this way, it works. $ mariadb --user blogbot -p"password" If I try to login this way, it doesn't work. $ mariadb --user blogbot -p Enter password: ERROR 1045 (28000): ...
- 101
0votes
0answers
69views
High swap consumption during database backup with mariabackup
We are experiencing a swap consumption problem when backing up our database. Every evening at 01am we run the mariabackup command and during the process swap usage rises sharply until it reaches 100% ...
0votes
1answer
46views
Script bash - Insertion of data into MariaDB from Oracle database
This script bash makes the data extraction to Oracle DB (another server), processing it and insert into MariaDB (my server), but the insertion it's misaligned and let it some columns in blank. This ...
-1votes
1answer
85views
Can ClamAV detect malicious files on a MySQL/MariaDB server?
Can ClamAV help detect malicious files (ie malware, rootkits, etc) for a MySQL/MariaDB server, specifically the /var/lib/mysql data folder? The database server is a single role and locked down both by ...
0votes
0answers
21views
Capturing Data from Sensors Sequentially Using Raspberry Pi 5 and NRF24
I am developing a project on Raspberry Pi 5. For this project, I have 6 sensors and I collect data from these sensors. I use NRF24 when collecting data. I store the data I collect in the database I ...
- 1
0votes
1answer
382views
AlmaLinux 9.4 how to update MariaDB to a later version
I have a brand new AlmaLinux 9.4 installation with my hosting company and it appears to have been pre-installed with a LAMP stack. The MariaDB server version currently running is MariaDB 10.5.22 but I ...
- 101
1vote
2answers
1kviews
Why is mariadb.service not restarted by systemd after OOM kill
The mysql.service got killed by the OOM killer. While investigating the root cause I wanted to change the unit configuration to restart if killed. I was surprised to find Restart=on-abort already in ...
- 191
0votes
0answers
237views
How to identify which process is causing a high memory consumption?
I am running a virtualized Arch Linux machine. From time to time, it shows a high memory consumption and I do not know the reason because basically, the machine is sitting idle. # ps aux --sort=-%mem ...
0votes
1answer
322views
start mariadb but systemctl status mariadb with failed
I installed mariaDB under the path ‘/app/mysql’; Since the configuration file could not be found, I created the 'my.cnf' file under the 'etc/mysql' path and copied the content online, my.cnf CODE: [...
0votes
0answers
70views
Mysql server under pressure?
I'm having issue with a server than hosting 5 Wordpress and 1 staging Including on Woocommerce and one Bbpress with huge db. The server got 120Go Ram with 500Mo swap set. I have a TTFB around 3s... ...
0votes
2answers
529views
Why do we misnomer MariaDB as a "mysql-server"?
I've had an interesting discussion recently, about whether it is okay to call MariaDB a "mysql server" when in reality, Maria is not 100% compatible with MySQL. I understand it was ...
- 53
1vote
0answers
47views
"Access Denied user root error code 1045 (28000)" after changing root passwords
I'm encountering an "Access Denied user root error code 1045 (28000)" error with user root. I'm facing this problem after changing passwords. It was working fine before, and I'm confused ...
