Questions tagged [mariadb-10.5]
100 questions
0
votes
1 answer
mysql secure installation seems to be not secure
After successful mysql_secure_installation
Output:
mysql_secure_installation
Enter current password for root (enter for none):
Switch to unix_socket authentication [Y/n] n
Change the root password? [Y/n] y
New password:
MyBullPassword
Re-enter new…
MANY Q
- 1
- 3
0
votes
2 answers
How to select a field of a JSON object coming from the WHERE condition
I have this table
id name json
1 alex {"type": "user", "items": [ {"name": "banana", "color": "yellow"}, {"name": "apple", "color": "red"} ] }
2 peter {"type": "user", "items": [ {"name": "watermelon", "color": "green"}, {"name": "pepper",…
FlamingMoe
- 2,709
- 5
- 39
- 64
0
votes
0 answers
MariaDB pl/sql 'Function does not exist'
I use MariaDB 10.5.6-MariaDB with InnoDB 10.5.6 and every time I try to do a select or whatever within a pl/sql block then it says 'Function does not exist'. What am I doing wrong? Is there a library that needs to be sourced before pl/sql can be…
ben
- 122
- 9
0
votes
1 answer
Can 'data race' happen with triggers in MariaDB with InnoDB?
My application processes very large volume of real-time data (>200 million a day) and I need to aggregate them real time in order keep reporting performant. The data is fed and hence processed randomly by several threads by the server.
I use MariaDB…
ben
- 122
- 9
0
votes
2 answers
Change MariaDB 10.5.5 Port
I have installed MariaDB 10.5.5 in Ubuntu 20.04 server. Right now I try to change the default port of the database to let say 12345. When I look into /etc/mysql/my.cnf and /etc/mysql/mariadb.conf.d/50-server.conf there is no port options, then I add…
EdTan
- 38
- 5
0
votes
0 answers
Error Unknown/unsupported storage engine: InnoDB
● mariadb.service - MariaDB 10.5.4 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed…
user7242195
-1
votes
1 answer
Dumping MariaDB database with mysqldump encoding issues
I am trying to dump mysql database as it would be exported from PhpMyAdmin (PA). I can see that I have an issue with encoding some values. Using MariaDb 10.5
PA output this: 0x00000000000000000000ffffd5065ccc
Output from PA export:
INSERT INTO…
DevWL
- 17,345
- 6
- 90
- 86
-1
votes
2 answers
INSERTing into a tag_map in MySQL
I have a simple article and tag_map tables as
CREATE TABLE Articles
(
ArticleID int(11) unsigned NOT NULL AUTO_INCREMENT,
Title varchar(255),
PRIMARY KEY(ArticleID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci
CREATE TABLE…
Googlebot
- 15,159
- 44
- 133
- 229
-1
votes
2 answers
how can this query be optimized (n+1 and dense_rank after)
How can I optimize this query
WITH stats AS (SELECT a.IntegratorSalesAssociateID,
a.AgentName,
(
SELECT COUNT(*)
FROM properties AS p
…
phper
- 307
- 2
- 12
-2
votes
1 answer
Is there possible query to compute for the total profits per category in 2 table?
How do I do.
Here is the table 1 for payments
Payments
paymentid
Unit
branch
tenantid
name
amount
note
dateofpayment
1
Bodega
Santo
1
Alsace Alsace
10000
REFRESHED DATA
2022-12-27 16:22:53
2
Bodega
Santo
1
Alsace…
