Questions tagged [mariadb-10.5]
100 questions
0
votes
1 answer
How to get all latest messages but with limit to one for every user message
I have been searching a lot, but probably I don't know how to ask the question properly.
I'm storing all chat messages between all users in table called 'user_messages' which looks like this:
message_from_user_id | message_to_user_id |…
Michał Lorenc
- 63
- 3
- 8
0
votes
1 answer
why are SQL inserts (mariadb) getting slower as a table grows
I'm trying to process some data and write it to a mariadb (10.5.10) table using django :
Here is my model
class AbstractCandle(models.Model):
exchanged_security = models.ForeignKey('market.exchangedsecurity', on_delete=models.CASCADE)
date =…
Reda Bourial
- 329
- 2
- 9
0
votes
1 answer
How to make a replication in MariaDB with windows 10? Error 1067 with the service
I have been looking for how to create a database replication with MariaDB but the steps I find on the official page of how to do it https://mariadb.com/kb/en/setting-up-replication/ give me an error in this He passed:
Example that enables…
Rosanny Batista
- 21
- 4
0
votes
0 answers
MariaDB - How to confirm Data at Rest has been encrypted?
I've just installed MariaDB 10.5.5 on Windows Server 2019 and have enabled the file_key_management plugin (keyfile is not encrypted (but will be)). I need to provide proof that the data is in fact encrypted, and have tried the recommendations from…
user2337160
- 41
- 1
- 5
0
votes
2 answers
Predefined range of date to fill
I want to count the number of item by date, but sometimes the table doesn't contains rows with some dates, and I have a hole in the result, like :
+------------+--------+
| date | number |
+------------+--------+
| 2021-03-12 | 1 |
|…
Surfoo
- 88
- 1
- 12
0
votes
2 answers
ROLL UP to keep only Grand Total and remove sub totals
I have 2 questions for the following query output:
COALESCE(Division,'Grand Total') Divi,
COALESCE(Section,'DivTotal') Sec,
COALESCE(m.Department,'SecTotal') Dept,
COALESCE(Assortment,'DeptTotal') Assort,
COALESCE(Promo,'')…
Brajesh Sharma
- 3
- 2
0
votes
1 answer
MariaDB: is the page cache / buffer pool shared across database connections for an embedded database?
I have a multi-threaded (OpenMP) application using an embedded MariaDB database. Sometimes I use Aria and other times I use InnoDB. When I set the page cache buffer size for Aria (aria_pagecache_buffer_size) or the InnoDB buffer pool size…
mlawsonca
- 103
- 1
- 6
0
votes
0 answers
Why do I get "mysql: unknown option '-▒'" error on execution of mysql command performing any query?
On the execution of the following command in linux
mysql --host=HOST --user=USER -–password='password' DATABASE --execute='SHOW TABLES'
I get the following error
mysql: unknown option '-▒'
This output does not depend on execute command and it is…
kathdroid
- 11
- 1
- 5
0
votes
2 answers
"Illegal mix of collations" error with stock install of phpMyAdmin
Problem
I have a stock install of Debian 11 (testing) with a brand new install of MariaDB (10.5.9-MariaDB-1), phpMyAdmin (5.0.4deb2) and Lighttpd (1.4.59). After adding a user and logging in, clicking on any database and the privileges tab renders…
Kurt Fitzner
- 595
- 5
- 14
0
votes
0 answers
What are the string to integer conversion rules used in MariaDB
Long story short: I need to find the rules for type conversion from string to integer in MariaDB.
My case: I have a VARCHAR column in a table that can have numeric values (1,2,3), numeric values padded with zeroes (01, 02, 03) and some non numeric…
Arkay
- 1
- 1
0
votes
2 answers
Not able to drop field in MariaDB table
I have table my_transitions and I am trying to delete field called myStage.
I am using this command:
alter table `my_transitions` drop `myStage`
I am seeing this error:
Key column 'myStage' doesn't exist in table
But when I list all fields using…
Bob
- 8,392
- 12
- 55
- 96
0
votes
2 answers
Select latest child for each parent optimization
I have 2 tables, a keyword table and a keyword position table
keyword structure
CREATE TABLE `keywords`
(
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`keyword` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
…
phper
- 307
- 2
- 12
0
votes
1 answer
unable to insert query in MariaDB
I am trying to insert a query :
insert into Table(ID,Value,Date) Values('Test1', '33', '20210315 11:15:27.059')
to MariaDB using ODBC Driver (Maria 3.1) but I have this error :
Exception message : ERROR [22007]
[ma-3.1.11][10.2.15-MariaDB]Incorrect…
happy
- 1
0
votes
1 answer
How to connect to MariaDB (10.5.8) with MYSQL Workbench as user identified via ed25519?
I can set MYSQL Workbench to connect to MariaDB with SSL connection as user identified via mysql_native_password, but if I set the identification to ed25519 it fails. Exists any plugin or solution for it? Should I use another free database…
Gábor Horváth
- 33
- 6
0
votes
1 answer
INSERT INTO...SELECT issue in MariaDB Columnstore
I have a new installation of MariaDB 10.5.8 which includes Columnstore as a plugin. I'm facing an issue when I try to insert rows into a columnstore table from a select statement. I have narrowed it down to a test case that consistently replicates…
Juan Arias
- 1
- 1