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.

Filter by
Sorted by
Tagged with
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 ...

1
2 3 4 5
38