Questions tagged [mariadb-5.5]
The mariadb-5.5 tag has no usage guidance.
18 questions
1
vote
0
answers
273
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
284
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
481
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 ...
- 149
0
votes
2
answers
246
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
94
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 ...
- 23
1
vote
1
answer
3k
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, ...
- 159
0
votes
1
answer
302
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
488
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 ...
- 13
0
votes
0
answers
176
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
...
- 101
0
votes
0
answers
134
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
376
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
2k
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 ...
- 113
1
vote
1
answer
114
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
38
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
2k
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 ...
- 349
1
vote
1
answer
35
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
68
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
...
- 101
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'...
- 667