Stack Overflow
Stack Overflow

Questions tagged [mariadb]

MariaDB is an open source database server that offers drop-in replacement functionality for MySQL.

MariaDB is an open source database server that offers drop-in replacement functionality for .

This MySQL fork has been made by its own original developers, triggered by doubts over the future management of MySQL after its acquisition by Oracle (through Sun Microsystems) in 2009. MariaDB is now released under the , and maintained by the community with the intent to maintain a high compatibility with MySQL APIs and commands.

Supported Storage Engines:

  • ARCHIVE
  • Aria
  • BLACKHOLE
  • Cassandra (added in 10.0)
  • CONNECT (added in 10.0)
  • CSV
  • FederatedX (drop-in replacement for Federated)
  • InnoDB
  • MEMORY
  • MERGE
  • Mroonga (added in 10.0)
  • MyISAM
  • OQGRAPH
  • S3 (added in 10.5.4)
  • SEQUENCE (added in 10.0)
  • SphinxSE
  • Spider (added in 10.0)
  • TokuDB (added in 5.5)
  • XtraDB (DEFAULT, drop-in replacement for InnoDB)

Legacy storage engines:

  • Federated (still provided, but FederatedX is recommended instead)
  • IBMDB2I (removed in 5.5)
  • PBXT (removed in 5.5)

Resources:

Related tags:

13893 questions
18
votes
1 answer

How to configure MariaDB in Laravel 5?

I have read somewhere that, there is no driver for "MariaDB" in Laravel 5 and that we can use mysql driver to use MariaDB in Laravel 5. But even then I am getting this error when i give my MariaDB username and password. The password is "root" and…
Parthapratim Neog
  • 4,352
  • 6
  • 43
  • 79
18
votes
2 answers

Difference between database, table, column collation

I understand that collations are a set of rules for making comparisons over a character set. MySQL / MariaDB has table and database collations in addition to column collation. I was wondering what was the difference between a collation on these…
Omar Abdel Bari
  • 934
  • 9
  • 17
18
votes
6 answers

Fix serialized data broken due to editing MySQL database in a text editor?

Background: I downloaded a *.sql backup of my WordPress site's database, and replaced all instances of the old database table prefix with a new one (e.g. from the default wp_ to something like asdfghjkl_). I've just learnt that WordPress uses…
its_me
  • 10,998
  • 25
  • 82
  • 130
17
votes
5 answers

Problem with pip install mariadb - mariadb_config not found

I have been trying to run pip3 install mariadb on my raspberry pi running ubuntu 18.04 and I was unsuccessful. I have tried installing following packages as suggested in other answers: sudo apt-get install mariadb-server sudo apt-get install…
Alex Xu
  • 197
  • 1
  • 1
  • 7
17
votes
1 answer

Access denied for user 'root'@'localhost' with mariadb 10.4.8 docker container using docker compose and issue while attaching external volume

I am new to Docker, I was trying to crate docker container of mariadb for my application but when I start running mariadb container it shows Access denied for user 'root'@'localhost' (using password: YES) dockerfile Following is the docker compose…
Rajesh Hatwar
  • 1,843
  • 6
  • 39
  • 58
17
votes
1 answer

WAMP server switch MySQL to MariaDB

How can I switch the database from MySQL to MariaDB in WAMP 3.1.0? I'm looking for it, but I can not find it.
kevas
  • 551
  • 2
  • 7
  • 22
17
votes
2 answers

Connect to MariaDB from Java application in NetBeans on Linux (Mageia)

I am trying to connect to a database in Mariadb through a simple java application but the connection is told to be unsuccessful and an Exception is thrown. I have done the similar connection using mysql and it was working correctly. The problem is…
Nitish Pareek
  • 2,453
  • 3
  • 19
  • 18
16
votes
2 answers

xampp windows mariadb not starting

mariaDB is not starting in my windows 10. I am getting the following in the logs: Cannot find checkpoint record at LSN (1,0x5c8f) 2019-12-19 9:18:13 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete…
Hugo Fernando Maia Milan
  • 917
  • 1
  • 8
  • 16
16
votes
3 answers

How can I create and load a second database in ddev?

I have a Drupal multisite that needs to have one database for each site, and want it to run in ddev, but ddev just has the one database by default, named 'db'. How can I get a second database?
rfay
  • 9,963
  • 1
  • 47
  • 89
16
votes
4 answers

FUNCTION ST_Distance_Sphere does not exist in MariaDB

I want get all locations around my location but the function ST_Distance_Sphere does not work. My query: select *, astext(location) as location from `locations` where ST_Distance_Sphere(location, POINT(35.905069591297, 49.765869174153)) <…
webafra
  • 221
  • 1
  • 2
  • 8
16
votes
3 answers

How can I limit the size of temporary tables?

I have largish (InnoDB) tables in a database; apparently the users are capable of making SELECTs with JOINs that result in temporary, large (and thus on-disk) tables. Sometimes, those are so large that they exhaust disk space, leading to all sorts…
Piskvor left the building
  • 91,498
  • 46
  • 177
  • 222
16
votes
3 answers

PHP / MYSQL connection failures under heavy load through mysql.sock

I've done quite a bit of reading before asking this, so let me preface by saying I am not running out of connections, or memory, or cpu, and from what I can tell, I am not running out of file descriptors either. Here's what PHP throws at me when…
Chad E.
  • 1,196
  • 9
  • 12
16
votes
3 answers

General error: 1615 Prepared statement needs to be re-prepared

I have been running into this issue every time I try and sync a medium size JSON object to my database so we can perform some reporting on it. From looking into what can cause it I have come across these links on the…
michael.schuett
  • 4,248
  • 4
  • 28
  • 39
16
votes
2 answers

What PDO driver to use with mariadb?

After replacing mysql with mariadb, I encountered the following error: PHP Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in /var/www/inlcude/config.php:5\nStack trace:\n#0 /var/www/inlcude/config.php(5): …
Question Overflow
  • 10,925
  • 18
  • 72
  • 110
16
votes
4 answers

How do I start MariaDB on boot on Mac OS X?

Just installed MariaDB (with homebrew). Everything looks like it's working, but I can't figure out how to have it automatically startup on boot on my Mac. I can't find any Mac-specific docs for this. The installation output says: To start mysqld…
Grant Birchmeier
  • 17,809
  • 11
  • 63
  • 98
1 2 3
…
99 100