New answers tagged mariadb
3
votes
Accepted
Innodb - Can you safely ignore the warning "Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size"
The warning you saw is not produced by MySQL Server, it's produced by Magento.
It has to do with "indexing" which is Magento's term for a type of ETL process. Your canonical data is stores ...
- 16k
1
vote
How to handle asynchronous slave synchronization with Galera?
To be honest, even if you could make it happen, and there are ways to do it, this setup with two “sides” actively writing is not a good idea. The simplest way would be to configure bi-directional ...
- 384
1
vote
How to handle asynchronous slave synchronization with Galera?
Yes, it is possible.
You must setup one node in the Galera Cluster like you would any regular slave
The topology you are looking for would resemble this (Image comes from a severalnines.com Blog)
...
- 184k
0
votes
Illegal mix of collations
Change your VIEW to:
CREATE VIEW hr_employees AS
SELECT id, name, salary
FROM employees
WHERE department = 'HR'
AND date_format(created_at, "%Y" COLLATE utf8mb4_general_ci) IN ('2024')
;...
- 900
0
votes
Website Content Not Displaying Correctly in Vietnamese After Restoring Database from Backup
"restored the website using the backup" -- Could we see a little more of the backup -- namely where some Vietnamese text can be seen.
I worry that the backup may have been messed up.
Also, ...
- 79.4k
7
votes
Loading a CSV into mariadb errs out as "invalid date format"
From LOAD DATA INFILE
In the case of a variable, the SET statement can be used to preprocess
the value before loading into the table.
If no variable is used during the LOAD DATA process, first the ...
- 4,463
0
votes
MariaDB Server Overloading
This question is hard to answer because it's missing so much information.
What are the SQL queries? We only see a screenshot of truncated queries.
You said you truncated the largest tables, but are ...
- 16k
0
votes
Accepted
MySQL Workbench error "name is not activatable"
For anyone wondering, I did end up resolving this issue, turns out I didn't have a keyring provider installed in my system.
Installing something like "gnome-keyring" fixed the issue!
0
votes
Accepted
MariaDB - Is it safe to delete a large temporary file?
This file was created by query that doesn't fit into memory. You have to find out which query is a culprit and kill it. The temporary file will be deleted automatically.
As far as creation datetime is ...
- 4,581
0
votes
Mysql process consumes High CPU & RAM even after reboot
If the reboot caught a long DML query in progress, then after the reboot, a ROLLBACK is needed to clean up that query. It will probably involve both CPU and I/O.
1GB or RAM and ...
- 79.4k
0
votes
auto restart mariadb.service if oom-kill killed main process
We recently upgraded from ubuntu LTS 18 to Ubuntu LTS 24 and started getting getting the DBI connect "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'" error ...
- 1
0
votes
Mysql process consumes High CPU & RAM even after reboot
When you restart mysql and buffer pool is not warmed up then the reads happen from Disk.
The Disk IO increases to fetch the information from disk instead of buffer pool.
You should check the below ...
Top 50 recent answers are included