MariaDB is an open source RDBMS, that is designed to be a"drop-in" replacement for MySQL.
2
votes
2answers
95 views
How can I improve my table design for different types of an entity?
Consider an accounting system as an example. I have an Entity called Client. Client can be of different types, with different fields applicable to different types. I consider creating separate tables ...
0
votes
2answers
45 views
SHOW TABLE STATUS very slow on InnoDB
Recently we've been migrating from MyISAM to InnoDB and I understand that MyISAM uses meta information against each table to track information and such - however, the database is about 1.8gb with 1+ ...
2
votes
1answer
34 views
MySQL Full Text search increase relevance for exact matches?
I have a MySQL database of ~10,000 organisation names that I want to be able to search. I would like to use a full text search because this would enable me to find "institute of doobry" by searching ...
1
vote
1answer
52 views
Avoiding performance hit from GROUP BY during FULLTEXT search?
Is there any clever way to avoid the performance hit from using group by during fulltext search?
SELECT p.topic_id, min(p.post_id)
FROM forum_posts AS p
WHERE MATCH (p.post_text) AGAINST ('baby ...
0
votes
1answer
82 views
Install MariaDB without password prompt in ubuntu
I need to install mariadb server in ubuntu without passwod prompt.
For this purpose, I execute the following commands, but it doesn't gave me any progress. It again shows password prompt.
I used the ...
1
vote
0answers
148 views
Does MariaDB-Galera Cluster support LAST_INSERT_ID and mysql_info?
As far as I understand, Galera does not support table locking, but what information can be retrieved about the last query?
LOCK/UNLOCK TABLES cannot be supported in master-master replication. Lock ...
1
vote
0answers
218 views
Oracle Flashback Archive aka Total Recall in MySQL
What would you suggest as a replacement system to achieve the same functionality of Oracle Flashback Archive aka Total Recall in other DBMS, in general or specifically in MySQL or MariaDB?
...
0
votes
0answers
34 views
Autoincrement by 2
I use MariaDB 5.5. It increases every auto_increment value by 2. So all my ai cols look like 1 3 5 7 9 ...
Where can I change this behaviour? Or might this be a bug?
0
votes
0answers
207 views
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)! in Fedora16
I installed MariaDB server in linux using tar file(mariadb-5.5.28a-linux-i686.tar.gz) followed by the instructions from this link : https://kb.askmonty.org/en/installing-mariadb-binary-tarballs/.
...
