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,851
questions
0
votes
1answer
469 views
Mariadb Galera cluster empty set
I am playing around with a MariaDB Galera Master Master Cluster and I have some issues which I do not understand.
[mysqld]
bind-address=0.0.0.0
[galera]
wsrep_on=ON
wsrep_provider=/usr/lib64/galera/...
0
votes
0answers
9 views
UPDATE with UUID() sets all rows with the same value
Having a table t1 with the field f1 BINARY(16) the following command updates all rows with the same uuid value.
UPDATE t1 SET f1 = UNHEX(REPLACE(UUID(), '-', ''));
OK, somehow I must have totally ...
0
votes
1answer
24 views
SQL - Select everything after a certain row
After the following query:
SELECT
my_table.ID,
my_table.DATETIME,
my_table.VALUE,
diagnostics_keys.type as type,
diagnostics_keys.key,
diagnostics_keys.unit,
...
0
votes
2answers
18 views
Remove unused Indexes MariaDB
I have a big database with 50 tables and each table can contains 100,000 to 100 million records on which are there 1000s of indexes but many of the indexes are now not in use how to find those indexes ...
2
votes
0answers
13 views
MariaDB - Query to find unused indexes
I need to find unused index on a MariaDB database and do not have 'userstat' enabled, I found this query which is supposed to find unused indexes, but I am unable to get a full understanding of this ...
0
votes
1answer
14 views
MariaDB 10.3.27 Memory usage problem
Greetings!
I tried to optimize MariaDB configuration with my.cnf. Everything was OK, but available memory falling down each hour. I'm using MariaDB with Zabbix server on the same server. CPU: 4 Cores, ...
1
vote
1answer
4k views
Mysql (MariaDB 10.3.9) can not start
I updated my mysql and I can't start it now. I try:
sudo service mysql start
Result:
Job for mariadb.service failed because a timeout was exceeded. See
"systemctl status mariadb.service" and "...
0
votes
1answer
284 views
Use of MySQL trigger to insert row's week number
I have a table of orders in a MariaDB database that currently has a datetime column. For the dashboard I am building for this database, I have a statistic I would like to display which is "Orders This ...
2
votes
1answer
3k views
Status shows InnoDB: 128 rollback segment(s) are active waiting for purge to start
MySQL process was killed due to memory issues. When start command was issued, server started and is working but a status command shows the following:
InnoDB: 128 rollback segment(s) are active.
...
0
votes
0answers
28 views
Storing every 5 seconds data in MySQL MariaDB
I have a system to store and display the MQTT Messages that came from IoT to Server. The data comes in every 5 seconds and there are multiple data types in a single message. Therefore, I have thought ...
1
vote
0answers
6 views
How to limit impact of a bad application on MariaDB Galera Cluster with MaxScale?
I have a Galera Replication cluster with three MariaDB nodes where a Maxscale Active-Passive cluster in front provides a single node image to tis clients.
I have a bad behaving client, which opens ...
0
votes
1answer
18 views
Selectively ignoring tuples from a table
The problem that we are tackling with a data mining application is best described with an illustrative example.
There is a sample table myTable, which is defined as follows:
CREATE TABLE myTable
(
...
0
votes
1answer
489 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
1answer
1k views
Determine cause of “MySQL server has gone away”
I've got a long running process on a headless server. It is a C program that monitors a modem for Caller Id and hangs up on telemarketers. On startup the program opens a connection to a MariaDB 10.3 ...
0
votes
1answer
118 views
Do I need to `mysql_upgrade --verbose -u root -p` each time when `source backup.sql`?
I am upgrading mysql 5.1 to mysql 5.5 in centos 7 server.
As time limit,I only mysqldump and source several small database to mysql 5.5,and then mysql_upgrade --verbose -u root -p,everything is ok. ...
0
votes
1answer
23 views
High memory usage in Masters with MariaDB and Vitess
I'm running a Kubernetes Cluster with MariaDB 10.3.20 and Vitess 6. Everything is running fine, but the memory usage in the Master nodes is always around 90%. I don't have OOM right now, but I was ...
1
vote
1answer
910 views
Point in time recovery with mariabackup
I have a full backup dir and a bunch of hourly (incremental) backup directories taken with mariabackup, which is a port of the XtraBackup.
How does one restore the MariaDB up to a specific minute (...
2
votes
1answer
788 views
Full database backup using xtrabackup stream
I'm new to Percona XtraBackup. I've been trying to perform a full backup stream from my local ( test server around 600GB ) to remote server.
I just have some questions and I need guides, and I think ...
1
vote
1answer
25 views
Automatically and robustly restarting a Galera cluster
Galera clusters, somewhat famously, have a requirement that nodes need to be shut down and brought back up again in a certain order.
There are a few questions here and on other sites about recovering ...
0
votes
2answers
290 views
Galera cluster node fails with error. Brand new cluster + master / node. Access denied or can't connect
I am having issue.
Previous cluster fatally crashed, so I've created a new one with pretty much same settings (changed cluster name only).
Here is a galera.cnf for a node:
[mysqld]
binlog_format=...
0
votes
1answer
222 views
MySQL MyIsam Compressing tables
Im packing big MyISAM tables with myisampack and came up with the following issue. (MariaDB 10.1.14 64bit windows)
Indexes are rebuilt after packing the tablewhile running myisamchk -rq, so, it doesnt ...
1
vote
1answer
577 views
MariaDB / mYSQL Order BY PrimaryKey DESC vs DESC set by Default
What do you guys think about:
After each query, I put "Order BY PrimaryKey DESC"
VS
I set "PrimaryKey Sort by DESC Default" and each query I don't need to put Order By there.
Which one will be ...
1
vote
1answer
51 views
Wordpress query on MyISAM tables in MariaDB on ZFS takes too long to execute
I use a pretty common setup, some wordpress sites running on Debian 10 (Buster) with mariadb 10.3.27 on ZFS, on a decent server with SSDs and lots of RAM, pretty smooth operation with low CPU ...
0
votes
2answers
107 views
Find weighted random row. Or split 1 row into many based on column value
I want to query the DB and pick a random item weighted by the count. Something like so:
SELECT * FROM (-- SUBQUERY THAT GENERATES WEIGHTED TABLE --)
ORDER BY ct * RAND() LIMIT 1
I'm thinking the ...
1
vote
1answer
924 views
Warning: mysqli_real_connect(): (HY000/2002): Connection refused in /var/www/html/wordpress/wp-includes/wp-db.php on line 1626
I'm just starting to code and I try to host a Wordpress website on a server of my school.
However, as soon as I upload the website on the Wordpress interface with the plugin "all-in-one migration", ...
0
votes
1answer
618 views
MariaDB 10.2 custom install using mysql_install_db.exe
In the past I used to setup MySQL/MariaDB manually on Windows boxes but don't remember exactly how. I unzip the .msi file and put every binary file into the desired place. I write a custom my.ini file ...
0
votes
1answer
1k views
Internal MariaDB error code: 1927 ('Connection was killed')
Edit: filed a bug report at https://jira.mariadb.org/browse/MDEV-14493
Mariadb nodes freeze occasionally with the following error in the logs, any clues?
(drupal app, db freezes on clearing ...
5
votes
2answers
10k views
grastate.dat with seqno -1 on a healthy cluster. Why?
We use those versions:
# rpm -qa | egrep '(galera|maria)'
mariadb-libs-5.5.41-2.el7_0.x86_64
mariadb-galera-common-5.5.40-6.el7ost.x86_64
mariadb-galera-server-5.5.40-6.el7ost.x86_64
mariadb-5.5.41-2....
1
vote
1answer
43 views
MariaDB Uuid as Primary Key Performance Problem / Tweaks
im upgrading our mariadb database from PRIMARY KEY INT AUTO_INCREMENT to UUID PRIMARY KEY. We have around 80 tables with multiple relations between them. I've build a migration script to change the id ...
0
votes
0answers
48 views
MariaDB starts from cmd prompt but not as service
Attempting to start MariaDB as a service results in an error that says:
Windows could not start the MariaDB service on Local Computer
Error 1053: The service did not respond to the start or control
...
2
votes
2answers
231 views
Having charset “utf8mb4” - does it mean every character takes 4 bytes, or only those that need 4 bytes?
I have a VARCHAR(80) utf8mb4 column, and I'm testing adding some ASCII & Emoji characters, and use LENGTH() and CHAR_LENGTH() to understand the differences.
From reading in different places, my ...
1
vote
1answer
355 views
Inconsistency in Tables - Mariadb Galera Cluster
MariaDB cluster Version : mysql Ver 15.1 Distrib 10.0.24-MariaDB,
I have a two node + arbitrator cluster which is live and replicating data across nodes.
Unfortunately we found some inconsistency in ...
0
votes
1answer
103 views
mysql (mariadb) won't start after power outage (MacOS)
/var/log/system.log says (over and over)
Oct 13 19:34:01 Data-Server com.apple.xpc.launchd[1] (com.mariadb.server[2128]): Service exited with abnormal code: 1
Oct 13 19:34:01 Data-Server com.apple.xpc....
0
votes
1answer
1k views
MariaDB GTID current_pos vs slave_pos
In a standard master-slave setup using MariaDB (10.3 at this time) and GTID (Global Transaction ID), it is unclear wether to use current_pos or slave_pos.
Reminder from the documentation:
Using ...
1
vote
2answers
225 views
MariaDB 10.0.25 installs without configuration
While trying to install MariaDB on Ubuntu 15.10, I issue command
$ sudo apt-get install mariadb-server
and it outputs
Reading package lists... Done
Building dependency tree
Reading state ...
1
vote
1answer
243 views
galera cluster in simple failover mode
Can mariadb-galera cluster be configured without data replication but simply in failover mode? I envision such configuration as one active master server and one backup server, both using the same ...
0
votes
0answers
20 views
bin log location is not changing [duplicate]
in my mariadb i have replication, i tried to change the location of the binlogs by changing the configuration file as so: log-bin = /new/path/mysql-bin
I also tried to change the index location as so: ...
1
vote
0answers
17 views
AWS RDS MariaDB dropping connection after CREATE TABLE with CHECK followed by CREATE INDEX
I've spun up a fresh MariaDB T2 micro instance with all of the default settings (have observed same behavior on t3-micro and t3-small).
Running this script:
CREATE TABLE test (
id INTEGER NOT NULL ...
0
votes
0answers
28 views
Correct way to account for MySQL session variables using JDBC
I am trying out a neat solution for getting top N rows per each group. The solution makes use of two session variables @country_rank and @current_country. The solution works well while directly ...
0
votes
0answers
8 views
How to remove orphaned tables with #sql-ib file type
Having some space issues with my server and noticed that there are two massive #sql-ibxxx files with no .frm equivalents.
what is the best way to remove these?
My databases are setup so that we have
...
0
votes
0answers
8 views
cant change log-bin locaion [duplicate]
in my mariadb i have replication,
i tried to change the location of the binlogs by changing the configuration file as so:
log-bin = /new/path/mysql-bin
I also tried to change the index location as so:
...
0
votes
1answer
178 views
Mariadb - Error declaring variable in trigger
I'm trying to declare a variable to use later in my trigger, but I'm getting this error.
ERROR 1064 (42000)
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB ...
-1
votes
1answer
15 views
Can't update database table's column using trigger or from php page but works after using update sql query in phpMyAdmin
After inserting into my audit log table called userUpdateLogand it calls an before insert trigger to insert into userProfiles and users based off the columns insert into their respective table.
but ...
0
votes
1answer
18 views
Does the collation of ENUM columns impact their size?
What does it mean when we say that an ENUM has a charset of utf8mb4, versus latin1?
My understanding is that the ENUM holds a numeric index (1, 2, 3, 4...) that identifies which of the ENUM values (...
3
votes
1answer
61 views
MariaDB fails due to timeout
So I'm having troubles starting the MariaDB service. I have tried all the suggested answers I found on the site, but I think I can't even debug it properly.
I'll tell you what happened before the ...
2
votes
1answer
345 views
Mariadb-10.0.30 Replication drift
We've configured 4 mariadb 10.0.30 slaves, the master also has the same major version and about the same hardware (32 cores, 128Gbs ram, 4.4Tb of data on ssd raid), everything was running fine until ...
1
vote
4answers
2k views
MariaDB - MySQL - ALL-DB Import - Table 'user' already exists
I am attempting to migrate from local MariaDB to Docker version which should in essence be as simple as migrating to a new SQL Server. I have setup the Docker container fine via but can't seem to ...
0
votes
2answers
24 views
Imposing LIMIT on UNION
We are working with some legacy code that is using a sub-optimally normalized DB. The problem that we are trying to solve is best described with an illustrative example.
hi_priority and lo_priority ...
0
votes
0answers
8 views
Locks during the physical backup process by Mariabackup
I read the manual, but I do not fathom what you can do and what you should not do during the backup process by Mariabackup. Particularly, as MariaDB Enterprise Backup has additional features including ...
0
votes
1answer
489 views
Galera cluster replication stalls when using wsrep_provider_options repl.commit_order=2
we are currently testing if moving from mariaDB master/slave replication to a 3-node-galera-cluster is an option for us.
General replication in the cluster works fine like expected. Load test shows ...