Hot answers tagged

2 votes
Accepted

MariaDB - How to add index to a generated VIRTUAL column

This seems to be an open issue: MDEV-18812, Add support for generated indexed virtual columns to aria. It was created 2019-03-04, so I would not hold my breath in wait for a solution For the sake of ...
Lennart - Slava Ukraini's user avatar
2 votes

Tool for monitoring changes to data in a database

You can enable the audit plugin in MariaDB or MySQL servers. Configure it to store the logs to a file and backup these files in S3. This is better than using CDC or using the mysqlbinlog utility since ...
jerichorivera's user avatar
2 votes
Accepted

Words and their occurences in table column

CREATE TABLE test (id INT, slug VARCHAR(100)); INSERT INTO test VALUES (1, 'name1-name2-name3-name4-name5'), (2, 'name6-name2-name3-name4-name7'); SELECT jsontable.word, COUNT(*) amount FROM test ...
Akina's user avatar
  • 19.6k
2 votes

Is there known such big perfomance diff between current MySQL and MariaDB?

You touched on something that might run a lot faster and simpler in MariaDB: INSERT INTO your_table (id, val) SELECT seq, FLOOR(RAND()*POW(10, FLOOR(15 * RAND()))) FROM seq_101_to_100000; ...
Rick James's user avatar
  • 77.6k
1 vote

Select last record of every hour, but time is not precise

I found a solution. Maybe is suboptimal, but suits my needs... SELECT T.* FROM electric_meters AS T JOIN ( SELECT MAX(ts) as ts_max, DATE_FORMAT(DATE_ADD(ts, INTERVAL 55 ...
Ajax's user avatar
  • 111
1 vote

Words and their occurences in table column

The "best" way would be to properly Normalise your data. select * from table1 ; +----+-------+ | id | name | +----+-------+ | 1 | name1 | | 1 | name2 | | 1 | name3 | | 1 | name4 | | ...
Phill  W.'s user avatar
  • 8,503
1 vote

Tool for monitoring changes to data in a database

You could use a change data capture tool like Debezium https://debezium.io/ or Maxwell’s Daemon https://maxwells-daemon.io/ to read the binary log where every row modification is logged as an event ...
Alexander Peresypkin's user avatar
1 vote
Accepted

Need help on database design for 5 entities complex relations

Looking at your diagram, I think your difficulty starts where you mistakenly try to model "Languages" as a subordinate of "Lines", when it is actually an independent entity. Apart ...
Giannis Tsimarakis's user avatar
1 vote

Need help on database design for 5 entities complex relations

In my opinion, your task is simple enough to write code that works 'identically' in both MariaDB and MySQL. There are two "things" to think about: Entity -- Implement as a table with ...
Rick James's user avatar
  • 77.6k
1 vote

Query RDS tables over time

What I want is a database where I can store this data which is not timestamped but that is received each day and be able to query it by the day it was received. How would this kind of database be ...
mustaccio's user avatar
  • 25.6k
1 vote
Accepted

The mariadbd process is at over 140% CPU utilisation despite a high innodb_buffer_pool_size value

Thanks very much for your response. I solve my problem by taking a Dedicated server instead of VPS. The old VPS was : 120Go RAM 24 Core AMD CPU NVMe as storage Ubuntu 22.04 The new is : 64Go RAM 18 ...
Nelson Nokimi's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible