Category "innodb"

MariaDB: Unknown data type "MYSQL_JSON"

According to MariaDB's website, you can simply replace MySQL with MariaDB. Great, I thought, however after installing MariaDB (10.5.7), some of my InnoDB tables

ERROR: Unable to start Group Replication 3096 (HY000) Can't add nodes to cluster INNODB

Setup: [All machines (4) are connected on LAN, updated, upgraded and they see themselves and work fine.] I've installed mysql in all 4, I created a cluster b

What are MySQL InnoDB intention locks used for?

I have read the MySQL mannual about intention lock: http://dev.mysql.com/doc/refman/5.5/en/innodb-locking.html#innodb-intention-locks It says that "To m

Save lat & lng values into point field in mysql

I have a table with fields latitude and longitude stored as float values, and I want to start saving them into points in a new column to use spatial features. C

How is it possible for InnoDB to deadlock on a single row?

According to The Good Word, InnoDB uses automatic row-level locking. You can get deadlocks even in the case of transactions that just insert or delete a sin

MariaDB Import maximum key length

We are currently moving the DB to another Server but we got a problem. Our Database is quite big and when we want to Import it to our new MariaDB Server with Ph