Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mariadb-5.5]

18 questions
3
votes
1 answer

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'm not sure if we can perform a direct in-place…
vegatripy
  • 668
  • 2
  • 7
  • 17
1
vote
0 answers

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 hardware is based on NetApp HCI full SSD. The VM…
omar.c
  • 11
  • 1
1
vote
1 answer

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 by both developer and sysadmin, performance is…
frEEk
  • 11
  • 1
1
vote
1 answer

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 possible and how ?
Christoforos
  • 149
  • 1
  • 10
1
vote
2 answers

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 so, everyone has 2 devices registered to their…
John Doe
  • 23
  • 1
  • 4
1
vote
1 answer

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, which is different from the number of indexes 3…
Lynob
  • 159
  • 1
  • 8
1
vote
2 answers

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 includes all of the create table statements, and…
diginize
  • 13
  • 2
1
vote
2 answers

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 indexed. The insert query is also very…
megamind
  • 113
  • 2
1
vote
1 answer

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 not the first person using Rhel 7 to face this…
BAMF4bacon
  • 113
  • 1
  • 5
1
vote
1 answer

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 tables. If I run du -sh /var/lib/mysql/xyz I get…
Jason
  • 115
  • 4
1
vote
1 answer

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?
zandro zoriano
  • 11
  • 1
0
votes
2 answers

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 all work I need to Use mysqldump to export all…
Jason
  • 115
  • 4
0
votes
1 answer

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. The script would be this: mysql…
CESAR MURILO DA SILVA JUNIOR
  • 1
  • 2
0
votes
0 answers

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 FROM g JOIN c ON c.parent_id = g.id AND…
rink.attendant.6
  • 101
  • 4
0
votes
0 answers

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 files and master.info file. I can however connect…
megamind
  • 113
  • 2
1
2