Questions tagged [mariadb-5.5]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
158 views

MariaDB 5.5 on Zabbix

it is a pleasure for me joining your community. I read a lot of posts trying to figure how to solve some problems. I'm facing with some performance issues about MariaDB on zabbix. First of all, the ...
  • 11
1 vote
1 answer
111 views

Massive performance degradation in upgrade from MariaDB 5.5 to MySQL 8

As part of a complete server move and upgrade (OS, Apache, and db) went from MariaDB 5.5 to MySQL 8.0.21. Hardware specs unchanged. Unfortunately despite many hours of reading and experimental tuning ...
  • 11
1 vote
1 answer
129 views

Backup live mariadb

I want to take a dump from a live mariadb database, but I need during the backup process to stop any kind of insert or update so as my backup to be the latest data image from my database. Is this ...
0 votes
2 answers
59 views

Transition to innodb_file_per_table for 30+ databases

Currently I have a MySQL Server with innodb_file_per_table = 0 Based on a number of factors, it seems to make sense for me to change that to innodb_file_per_table = 1 I understand that to make this ...
  • 115
1 vote
2 answers
70 views

Deleting Duplicates - mariaDB

I have a mariaDB database containing details about user devices (sort of an 'allowed device' list for VPN access). Back when the project started, there was no restriction on what devices were allowed ...
1 vote
1 answer
2k views

Table contains 4 indexes inside InnoDB, which is different from the number of indexes 3 defined in MySQL

The database is an old version of MariaDB, the equivalent of MySQL 5.5. The table contains those columns id auth old_auth device_id_fk This error is showing Table contains 4 indexes inside InnoDB, ...
  • 173
0 votes
1 answer
231 views

I have to delete over 90 million records, do I remove or maintain the transaction's SQLWARNING?

SQL Server: mysql Ver 15.1 Distrib 5.5.65-MariaDB, for Linux (x86_64) using readline 5.1 OS: Slackware 14.1 That's 90 million old radius bank records I want to remove, leaving only those this month....
1 vote
2 answers
78 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
0 answers
87 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
0 answers
64 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 ...
  • 113
1 vote
2 answers
216 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 ...
  • 113
1 vote
1 answer
970 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 ...
1 vote
1 answer
79 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 ...
  • 115
0 votes
0 answers
30 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....
  • 1
0 votes
1 answer
1k 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 ...
  • 311
1 vote
1 answer
25 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
1 answer
64 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 ...
3 votes
1 answer
4k 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'...
  • 659