MariaDB 10 -> 11 migration, the 11th version stopped using possible_keys
I faced the issue during migration from MariaDB 10.11 to 11.0 version that some specific queries run longer.
Database Issues on Live Server – Dev Server works
I believe I have a database problem with my FiveM Lua script and I’m not sure how to fix it. My dev server is at home, and everything works perfectly there. I can create a character without any errors, etc. However, on my live server, this does not work; I get an error when creating a character. The code is exactly the same on both servers, so I suspect it must be related to the database because a value is not being inserted.
When updating unique index column by primary key in MySQL 5.6 version, it leads to deadlocks
Database Info It looks like Mysql or MariaDb 5.6.16, I am not sure Welcome to the MariaDB monitor. Commands end with ; or g. Your MySQL connection id is 12297574 Server version: 5.6.16-log Source distribution Table Info There are two unique index CREATE TABLE `test` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `version` int(11) NOT NULL […]
I want tp use MariaDB in CMD but I cannot
I have installed MariaDB from CMD but I cant connect to it from CMD or make database or etc.
I want to build a database from CMD, I have tried multiple ways but I was unsuccessful
SQL Procedure for Secret Santa Draw Allows Self-Gifting
Hello Stack Overflow community,