Questions tagged [mariadb-5.5]

The tag has no usage guidance.

0
votes
0answers
9 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
14 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
20 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
60 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
120 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
15 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
0answers
110 views

Add new slave in MariaDB Replication

I have a Master server (A) and a Slave server (B). B is getting replicated from A [all the dbs (db1,db2,db3) except few tables]. Now, I need to add one more Slave but It has to replicate only db1 and ...
0
votes
1answer
47 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'...