Skip to main content

New answers tagged

1 vote
Accepted

Merge old and new versions of the same MariaDB database

If you're willing to do an extra query per table you can completely drop the IGNORE syntax and get results with zero warnings via SHOW WARNINGS;: INSERT INTO $database1.$table SELECT * FROM $...
John's user avatar
  • 725
1 vote

MariaDB 10.7 to 10.5 replication issue with DROP DATABASE

Incorrect definition of table mysql.event This kind of error normally indicates that the DB that is throwing the error has been upgraded and not had mysql_upgrade run on it. The rest of the error I'd ...
Phil Sumner's user avatar
  • 1,897
1 vote
Accepted

Dynamically populate table values for migrating data

Thanks to Ergest Basha and nbk for their helpful comments I was able to copy newer records to an older database without complications or problems by using: INSERT IGNORE INTO $db1.$table SELECT * FROM ...
John's user avatar
  • 725
0 votes

MariaDB : very high trx_rseg_history_len

History length may increase when the indexes are not optimal. Item 1 SELECT cr.* FROM reference_front_link AS rfl JOIN commande_reference AS cr ON cr.crf_rfr_id = rfl....
Rick James's user avatar
  • 78.6k
0 votes
Accepted

Hidden Unicode General Collation via mysqli_get_charset even though everything else is 520 and 1400

I filed a PHP bug report and in short: they have an internal static array of character sets with utf8mb4_general_ci as a fallback. So the appropriate way to get the character set information is by ...
John's user avatar
  • 725
0 votes

MariaDB: Writing even 25MB of data into a LONGBLOB is very slow

Things to consider: Compress such text in the client, then store into a LONGBLOB. (XML typically compresses 3:1.) Store such bulky things in the filesystem, not the table. How much RAM do you have? ...
Rick James's user avatar
  • 78.6k
0 votes

MariaDB : very high trx_rseg_history_len

I think I finally found the solution : increase the innodb_buffer_pool_size to 16Go (our server has 32 and I initially had a value of 128Mo). The slow queries are fast again, trx_rseg_history_len is ...
Adrien Godar's user avatar
0 votes

WSREP_SST: [ERROR] Possible timeout in receiving first data from donor in gtid stage

We found the issue. If we install mariadb.org repo on Alma Linux 9 the HA is broken with the following error: WSREP_SST: [ERROR] Possible timeout in receiving first data from donor in gtid stage: exit ...
Sandeep's user avatar
  • 101
1 vote
Accepted

mysql - show all users/hosts with privileges to access a certain database

Is there a way in which I can provide the database in the request? And then get all different users that have been granted access to that db in a single shot? You can use the mysql.db table which ...
Ergest Basha's user avatar
  • 4,000
0 votes
Accepted

Backup with mariabackup error Can't open dir ./System Volume Information

There are two things going on here: the hidden system folder ./System Volume Information is created by Windows at the root of each mass storage device the fact that mariabackup.exe finds a folder ./...
theking2's user avatar
  • 111
0 votes

What is causing my ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)?

Have you tried running mysql.server start? I was having the same issue, and after three days of debugging, came across this post. They recommended running mysql.server start, and I don't know why, but ...
Krislunde's user avatar
0 votes

MariaDB Crashes Every Time Restarted

I was having a similar problem, except I was getting [ERROR] InnoDB: Missing FILE_CHECKPOINT(10514035995) at 10514035995. Would completely reinstall mariadb with brew, it would run fine, but after ...
Krislunde's user avatar
0 votes

MariaDB Crashes Every Time Restarted

What worked for me is killing all mysql processes, reinstalling, and then setting the root password manually. Note: Don't use pkill except in very rare circumstances. It was like: brew stop mariadb ...
Zachary Taylor's user avatar
0 votes

How can I disable mysql_native_password and mysql_old_password on MariaDB / MySQL?

There is currently no mechanisms to disable mysql_native_password. old_passwords as a system variable defaults to off so mysql_old_password isn't available. MDEV-12320, is feature request to ...
danblack's user avatar
  • 7,819
1 vote

Stuck at finding the syntax error in group_concat and prepare in MariaDB

I can't find the syntax problem. The problem is simple - PREPARE statement does not support multi-statement query. So the presence of the 2nd statement in your SQL text which you want to be executed ...
Akina's user avatar
  • 20.1k
1 vote

MariaDB Crashes Every Time Restarted

I encountered the same problem, and only a downgrade to [email protected] helped to resolve it. See https://github.com/orgs/Homebrew/discussions/5389#discussioncomment-9701010
Ow1y's user avatar
  • 11
0 votes

Change the default value of a string column to real uuid()

With MySQL 8, I use: uuid_bin1 BINARY(16) NOT NULL DEFAULT (UUID_TO_BIN(UUID(), 1)) if that column is the Primary Key.
druud62's user avatar

Top 50 recent answers are included