Question : I have a Joomla app that takes my MySQL instance down all the time. It uses too much […]
Category: MariaDB
Select query on 8 million records with greater and less than columns (Slow)
Question : I looked through the posts but cannot find an answer. I inherited this application so the response is […]
],
Question : Answer :
Imposing LIMIT on UNION
Question : We are working with some legacy code that is using a sub-optimally normalized DB. The problem that we […]
Stuck at inserting records into MariaDB conditionally
Question : I know about insert ignore. That’s of no use, because MariaDB does not consider NULL to be part […]
Batch query a lot of MySQLdump files
Question : I have a website for an event. I set up a cron job to back up the database […]
MySQL/MariaDB replication
Question : I configured two MariaDB instance in Master-Slave configuration. As a test, I tried to see what happens when […]
What is the optimal solution for storing real time time-series in MariaDB / MySQL?
Question : Use case: A measurement creates a given number of images. For each image we need to store a […]
MariaDB Fails to log in error log
Question : I am using MariaDB Version 5.5.56 The database was restarted 2 days ago but I am not seeing […]
mariadb won’t let me access from “remote”
Question : I have one Linux computer(CentOS7.4) as server, one windows computer. I have setup the mariadb server. On windows, […]