Questions tagged [mariadb-5.5]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
19 views

MariaDB mysqldump lacks all data - how do I force including it?

for years I've been using mysqldump without much trouble. Recently I joined a project that is using "MySQL dump 10.14 Distrib 5.5.52-MariaDB, for Linux (x86_64)" and when I attempt to do a dump it ...
0
votes
0answers
39 views

Optimizing range join (x between a and b) in MariaDB

My query has a join using a BETWEEN clause and it causes a full table scan to occur if I understand the EXPLAIN output correctly. Query EXPLAIN SELECT g.id, g.name, c.id AS child_id, c.date ...
0
votes
0answers
13 views

Creating new Slave without copying relay-log files from existing slave

I have a already existing master slave replication setup. I want to create a new slave but I cannot ssh to the existing slave machine due to some issue with the slave so I cannot copy the relay log ...
1
vote
2answers
41 views

Mysql Config Suggestions - CPU too high

My server (64GB,16CPUs) has mariadb 5.5.60. The queries are around 500 selects /second and 300 inserts/seconds. The queries are simple select of auth token and user details. Both are properly ...
0
votes
1answer
16 views

MariaDB 5.5 — how to customize password rules

I am using RHEL 7, which includes MariaDB 5.5. I want to set up minimum requirements for passwords: minimums length 15, 1 lowercase, 1 uppercase, 1 symbol, 1 number. I figure that I am probably ...
0
votes
0answers
19 views

Master- Master breaks after server Reboot

I have a Master-Master Replication with the following Configuration. Due to some patches, we have to Reboot the both the masters. But when i check the replication i s broken. MASTER 1: [mysqld] ...
1
vote
1answer
22 views

Why would a file generated by mysqldump be substantially larger than the data directory

I have a MariaDB server - 5.5.60 I have a database xyz that has both MyISAM and InnoDB tables The majority of the tables are MyISAM but in this database in particular, the data is mainly in InnoDB ...
0
votes
0answers
23 views

Efficient pseudo-random entry constrained selection

I am looking for a SQL query to pick up a (pseudo)random entry that matches a WHERE clause from a table of ~1,000,000 entries. This query must be as efficient as possible (must resolve in, at most, 0....
0
votes
0answers
130 views

OpenStack MariaDB (MySQL) cleanup of nova database

I am trying to do cleanup on Newton (RHOSP 10) release nova DB, and want to remove old instances, which are removed LONG time ago (have about 7M rows on some tables). I did some info gathering and ...
0
votes
1answer
224 views

MariaDB special Characters

I have a database on a hosting service that was recently move and upgraded without much notice which has caused me many problems. This problem, however, seems to arise from an upgrade from MySQL to ...
1
vote
1answer
17 views

How to update MariaDB if the current version is not in default directory?

I will try to update my MariaDB from 5.5.56-MariaDB to 10.3.9-MariaDB. However my current version was configured or located into another directory. How should i do it?
0
votes
1answer
51 views

Strange query optimization issue - logically the same, different performance

I have a slow query and I don't understand why the DB is choosing to perform a sub-optimal execution plan. Server is MariaDB 5.5 Slow query (4-5 seconds) is: SELECT VisitDate AS LASTDATE FROM Visit ...
2
votes
1answer
2k views

Can upgrade from MariaDB 5.5 to MariaDB 10.3 directly?

We have a database running in MariaDB 5.5.60 and we want to upgrade it to the last 10.3.7 version. However I'm looking at MariaDB knowledge base ( https://mariadb.com/kb/en/library/upgrading/ ) and I'...