Questions tagged [mariadb]
Open source RDBMS designed to be a "drop-in" replacement for MySQL. Add a version-specific tag like mariadb-10.2 if that context is important.
1,293
questions
0
votes
0answers
9 views
Errors reading and writing communications packets
After an outage that had us down for 4 days I am attempting to establish replication between 2 of our servers in order to have a "hot" backup available should the need arise.
After dumping all of the ...
-3
votes
0answers
42 views
The best SQL server for client/server system (direct connection), performance/security? [on hold]
Which relational database server does handle a two-tier client/server setup best?
I'm about to create a WinForm .Net client and don't want to develop a mid-tier server.
Many client connections:
Which ...
0
votes
0answers
7 views
Trying to create 2nd instance of mariadb on windows server
I have a windows server with MariaDB (10.2.14-MariaDB) and I'm trying to install a 2nd instance on it. I have 1 instance working using port 3307. I used mysql_install_db to install it on port 3307. I ...
0
votes
0answers
23 views
can't join a freshley started mariadb galera cluster
I'm at my very first clustering experience. I need to create a MariaDB Cluster. Currenlty I have two servers but I planned to add 1 more in the future.
Now, I have:
maz-pihole (a debian 9 based OS ...
0
votes
0answers
24 views
MariaDB SPIDER engine
I am trying to include just one table from another MariaDB server (lets call it A) into the database on another (even physical) server (lets call it B). And I came up with the conclusion that SPIDER ...
0
votes
1answer
29 views
MariaDB CONNECT storage engine
I have a MariaDB running on one server that contains a particular table that I want somehow to have access to on another server on the same private network.The second server is also running MariaDB. ...
0
votes
1answer
14 views
Skip_log_bin and innodb_flush_log_at_trx_commit
If I have skip_log_bin =1 is there any reason for not having innodb_flush_log_at_trx_commit = 0?
If I have understand correctly, innodb_flush_log_at_trx_commit, reads data from log file and stores ...
0
votes
0answers
27 views
Docker MariaDB lost data
I was using the official mariadb 10.3 image as a database with innodb and file per table turned on. A few months ago I pulled the image for a minor release and let it run. This as I now found out did ...
0
votes
2answers
25 views
Move table from InnoDB to Memory
I am using mariadb 10.4 with nignx with joomla 4 on Debian 8 system.
Is it possible for a table that is already created with records in a working database to be moved on memory?
I find only ...
2
votes
1answer
22 views
Removing grants for databases that no longer exist
We have quite a few MariaDB servers with whom the permissions have gotten a bit messy over the years. I'd like to tidy them up.
I've already written some tools for presenting grants/table information ...
0
votes
1answer
39 views
MariaDB is not using all memory available
I have a joomla web site with about 160.000 articles. I use 10.4.6-MariaDB, nginx and php 7.3.
When I check my server with top, I see a maximum of 3,3 MB of memory usage by MariaDB while I have given ...
1
vote
2answers
30 views
MariaDB writes at 500kb/s how to get it to write at normal speeds?
My ubuntu 18.04 has mariadb. I've tried mariadb 10.1, 10.2 and 10.3 all with the same symptons
When I time the harddrive, it has reasonable speeds
$ sudo hdparm -Tt /dev/sda
/dev/sda:
...
0
votes
0answers
19 views
Mysql high number of queries in queue
we have been struggling to understand this behabiour on mariadb. we have some jobs that run every minute and they do a lot of updates on some metadata tables inside mariadb, however we have noticed ...
0
votes
0answers
42 views
Database performance, tps & IOPS
We have a Java application that uses a MariaDB database that is dedicated to this application. The application needs to insert 1 million records within 5mins so ideally we would like the database to ...
0
votes
1answer
33 views
MySQL service will not start [ERROR] mysqld got exception 0xc0000005
Server was running just fine with MariaDB 10.3.13. Stopped the service, installed MariaDB 10.3.16 and restarted the server just fine. Stopped the service again and installed MariaDB 10.4.6 and the ...
0
votes
0answers
14 views
MariaDB Cluster node crashes after upgrade
I have a 3 node MariaDB galera cluster running. It was running fine until I updated one node from MariaDB 10.3.14 to 10.3.16 (the other nodes are still on 10.3.14). Since then, this one node regularly ...
0
votes
0answers
23 views
How to debug INSERT statements
I have issues importing "not-so-small" dumps to MariaDB 10.4.6 in CentOS, but the error log and stderr is empty.
I dumped many databases with mysqldump sized around 50MB / 500.000 rows each, and ...
0
votes
1answer
30 views
100+ DBs in one instance or divide and conquer : MariaDb Ubuntu 64bits
I have a desktop app (100+ customers and more to come) running at customer's small local server, all of them have same structure in tables (different info). I'm migrating that app to web ( almost ...
1
vote
1answer
26 views
MariaDB CONNECT engine BIN table - file record layout, storage of a date data type, padding
In mariadb-10.4.5, running on Windows 10, I created this table (in the local database):
`CREATE TABLE IF NOT EXISTS `testbalNoFieldFormat` (
`fig` int(4) NOT NULL,
`name` char(10) NOT NULL,
`...
0
votes
1answer
44 views
MariaDB: Duplicate entry for key on OPTIMIZE with no duplications
There is a table named contracts with following structure:
MariaDB [db_name]> DESCRIBE `contracts`;
+-----------------------------+--------------+------+-----+---------+----------------+
| Field ...
0
votes
1answer
16 views
revoke and apply privileges on current active sessions
I am revoking some privileges to a user like this:
REVOKE INSERT, UPDATE, CREATE, ALTER ON `name`.* FROM 'user'@'%'
I verify via:
SHOW GRANTS FOR 'user'@'%';
And see that privileges really have ...
0
votes
0answers
12 views
Using next sequence in DEFAULT value and ON UPDATE value
Can somebody tell me is the following expected behavior or I'm doing something wrong?
MariaDB version: 10.3.12-MariaDB-1:10.3.12+maria~bionic-log
WORKS:
CREATE TABLE `example_table_1` (
`id` ...
0
votes
1answer
27 views
How can i replicate many database into one, by avoid primary key collision?
I have n number of databases and I have to collect data from those into one database. The databases has some specific value (e.g. currencies) which I want to update from the collector database(of ...
0
votes
1answer
43 views
Mysql_upgrade fails, table is corrupted
I have a mariaDB with a table that is corrupted. It's useless data to me, so I've tried to drop the schema but it won't drop. Instead, it gives me this error when trying to drop it:
"Error Code: 1805....
0
votes
0answers
16 views
Mysql slow after a while until reboot
Mysql became slow after a while until I reboot, it's fast again, then gets slow after a while.
This started after I accidentally deleted everything in /var/log.
Mysql and mariadb wouldn't start at ...
1
vote
0answers
10 views
queries to active live test health of a galera cluster
What queries could be used to foresee or better fine tune alerts to check the health status of a Galera (MariaDB) cluster?
The problem I am facing is that randomly the cluster gest stalled because of ...
0
votes
0answers
22 views
Start replication again from crashed MySQL master
I am messing around with MySQL replication trying to learn about it and have ran into a snag that I can't seem to find the solution to. I have a local instance of MySQL running as Master and a remote ...
0
votes
1answer
27 views
What's the low-down on MariaDB JSON support?
Does MariaDB ever plan to have full JSON support or is it just going to be an alias forever?
It's a bummer to set constraints definition in the table just to make it work properly. Application-level ...
0
votes
0answers
20 views
MariaDB Galera + Replication (GTID error)
Using MariaDB 10.2.25 + Galera with 3 masters
All Masters have binlogs active
Want to switch the Master_Host of an external salve (also running MariaDB 10.2.25) to a different Master.
Replication is ...
0
votes
1answer
26 views
Query to filter a table based on a comparison applied to the same table?
Case & Problem:
Consider a corporate building with some rooms and departments that need authorization to enter.
Employees have to scan their badges to be authorized.
If the employee is inside (...
0
votes
1answer
43 views
Mysql innodb recover from frm and ibd
There are numerous question (in this site and elsewhere on the internet) about how to recover innodb database from *.frm and *.ibd file (the point: when you have the undamaged ibdata1).
Situation:
I ...
0
votes
2answers
27 views
No index used warning in WHERE column IS NULL
I'm getting this warning:
No index used in query/prepared statement SELECT * FROM mTable WHERE my_column IS NULL
But the my_column is already indexed.
MariaDB [mytest]> SHOW INDEX FROM mTable;
...
0
votes
0answers
18 views
Storing when something is in use
I need to track license usage for software and the software does not have any sort of metric that we can use. The need for this comes when it is time to pay the maintenance quarterly and trying to ...
0
votes
0answers
29 views
Pivot returning null columns in MariaDB / mySQL
I'm trying to pivot a table in a Wordpress Woocommerce database, just for some adhoc reporting, using Case statements. It works well for most columns (the shorter ones), but columns returned with ...
0
votes
0answers
25 views
Order by not working in subquery
I have a table with comments related to articles.
entity_id | parent_id | comment | created_at
1 | 4 | AAAA | 2018-10-18 12:28:03
2 | 5 | BBBB | 2018-10-19 12:28:...
0
votes
0answers
19 views
How can get each row of other table in 'where' condition?
[Table1]
row, col1, col2, col3
1, 0 , 2019-06-20 09:00, 2019-06-20 11:00
2, 0 , 2019-06-20 11:30, 2019-06-20 13:00
3, 0 , 2019-06-20 13:30, 2019-06-20 17:30
[...
0
votes
0answers
26 views
Procedure can not be executed
I can run one procedure in one database:
$ mysql --user=license --password=test123 --host=mariadb.devlocal --database=license -s '--execute=CALL config_sp_License_Update("missing","...
0
votes
1answer
29 views
Can we use MariaDB mysqldump CLI to take dump from MySQL Community version?
MySQL server version:
mysqld Ver 5.7.26 for Linux on x86_64 (MySQL Community Server (GPL))
MariaDB mysqldump CLI version:
mysqldump Ver 10.17 Distrib 10.3.12-MariaDB, for Linux (x86_64)
I am ...
0
votes
1answer
47 views
Efficient partition pruning with ORDER BY on same column as PARTITION BY RANGE + LIMIT?
I've set up a table in MariaDB (10.4.5, currently RC) with InnoDB using partitioning by a column of which its value is incrementing-only and new data is always inserted at the end. For this case, ...
7
votes
2answers
323 views
Covering index used despite missing column
I have the following query, using MariaDB 10 / InnoDB:
SELECT id, sender_id, receiver_id, thread_id, date_created, content
FROM user_message
WHERE thread_id = 12345
AND placeholder = FALSE
ORDER ...
0
votes
1answer
40 views
What's the best way to migrate from mariadb to mysql on ubuntu 18.04
I've got a server running on ubuntu 18.04.1 with mariadb 10.1. and I have to change to mysql. The reason is that mariadb isn't supported by a product I want to buy. Searching around the internet I've ...
2
votes
1answer
60 views
How to clear the InnoDB redo log before starting mysqld for crash recovery
System: Windows Server 2012 R2, MariaDB 10.2.8
We are currently trying to recover from a quasi-crash (it was a normal shutdown, but mysqld won't start up again)
and are having problems with the redo ...
1
vote
0answers
29 views
MariaDB Spider sharding: automatic XA commit?
I'm planning to use Spider to shard my huge table across multiple backend nodes. What I'd like to do, is inserting on the Spider node(s) on the virtual big table, and Spider have it distribute it for ...
0
votes
1answer
33 views
MariaDB replication failure: Fatal error 1236 - binlog shows 'Event truncated'
Disclaimer: I am not a certified DBA
I have configured MariaDB Master - Slave replication and everything was working but now have an error that I cannot get past.
I have run the following on the ...
0
votes
2answers
22 views
Would re-importing reduce the DB/backup size?
My MariaDB DB size is constantly growing. So is the backup file size.
As I am not a DB admin (just a programmer using this DB) I wonder if I could just export the whole DB, then delete the existing ...
-1
votes
1answer
24 views
I need to create query connect 3 tables with Many to Many relationship in MariaDb
I have Many to Many relationship Tables.
items, caregories, stock, item_category, item_stock
Items: Categories: item_category:
╔════════╦════════════╗ ╔═════╦═══════════╗ ╔══...
0
votes
0answers
32 views
MariaDB pipped querys not executed
I experience a strange problem on our 3 node MariaDB cluster (10.2.24). Queries send over the command line are received by the cluster but don't get executed. MySQL does not return any errors or ...
0
votes
1answer
30 views
Does “consolidation” of query statements improve query performance?
Assume we have a set of postal addresses A1, A2, A3, ... of the form:
A1 = 124, "Smith", "Rd"
A2 = 142, "Jones", "St"
A3 = 8190, "Smith", "Ln"
A4 = 142, "Via Gracia", NULL
A5 = 190, "Jones", "St"
A6 =...
0
votes
0answers
26 views
Mariadb refuses to start a new instance
I have two production Mariadb servers running on Ubuntu 16.04 that have a second instance running on them on port 3307. I've set up up a third instance to run on port 3309. I've created a new data ...
0
votes
2answers
122 views
Why are the system tables in MySQL and MariaDB utf8 and not utf8mb4?
I know the general advice is never to use utf8, but instead to use utf8mb4. If that's the advice, then why do the system tables themselves use utf8?
You can see this in the MariaDB test suite, and ...
