MariaDB is an open source RDBMS, that is designed to be a"drop-in" replacement for MySQL.
1
vote
0answers
9 views
MariaDB CUstom Functions
In MySQL, I wrote functions in C++, compiled them as .so, and added them to MySQL. I am trying to find a website that shows an example for doing the same in MariaDB. I cannot find any instructions, ...
1
vote
0answers
17 views
How do I safely import MySQL data in a directory to a running MariaDB server?
We're integrating another office into ours. That includes some of their data.
I have a new installed MariaDB 5.5 server. The data dir = /home/data/MariaDB. I've done a new/fresh install into that ...
0
votes
1answer
43 views
Which is faster among MySQL Community Server, Percona and MariaDB [on hold]
I have a small setup of MySQL Community Server version 5.6 running on KVM based VPS. 4 CPU cores are available and total memory is limited to 1GB. I use MyISAM tables mainly for Wordpress and few ...
0
votes
0answers
13 views
constrain/expand same set of privileges to exclude/include databases in mariadb
I have a user that has a set of privileges for all databases in an instance of MariaDB. I'm wondering how the same set of privileges can be made to cover a certain set of databases. Below are my ...
1
vote
1answer
43 views
MariaDB header error
I had a MySQL server on my Ubuntu dev box (I use a tutorial "how to install a lamp on ubuntu" type of article) and I decided to install mariadb.
So I uninstall mysql and install mariadb.
~$ mysql ...
0
votes
1answer
44 views
Is there a system wide way to change MariaDB to create tables using ROW_FORMAT = DYNAMIC
I've got a 700MB dump file from a mysql database that I was trying to undump into a new install of MariaDB and I got this error
ERROR 1118 (42000) at line 7481: Row size too large (> 8126). ...
0
votes
0answers
46 views
To what extent is MariaDB Java client a perfect replacement for MySQL JDBC (Connector/J)?
Premise: I ship a Java application which will make a JDBC connection to a MySQL database. (At the time of this writing it could be 5.1 or 5.5, but hopefully the question and answer don't rely heavily ...
0
votes
2answers
77 views
Memcached plugin on MariaDB?
I'd like to try new NoSQL feature in MySQL 5.6 but I am using MariaDB 10.0.2 on Debian 6 and don't fancy coming back to MySQL.
I'm wondering whether the memcached plugin has been added to MariaDB? ...
1
vote
1answer
50 views
Why InnoDB ALTER TABLE is so slow? [closed]
The machine has a 4-core hyper-threaded Intel i7 670 @ 2.8GHz, 16G RAM, 8G of which is InnoDB buffer pool. The database resides on Intel SSD disk. DBMS is MariaDB 5.5.30 x64 running under Windows ...
0
votes
1answer
38 views
UTF8 vs ASCII or custom binary format: high-performance optimization on very big tables
The summary of my question is whether there are advantages, even if minimal, to use ASCII, or even a smaller format designed yet created specifically for the situation, instead of UTF-8 for strings.
...
3
votes
3answers
109 views
How can I improve this query?
About a year back I introduced a query which returns a sort of "Customers Also Purchased" data-set. At the time it ran reasonably fast however, as of late it's become very slow, sometimes taking up to ...
1
vote
4answers
347 views
Daily and Differential Backups
Is there a program with which I can create daily MySQL, PostgreSQL and MariaDB backups with these requirements:
The first time, make a full backup.
The second time, only the changes since the last ...
0
votes
0answers
52 views
Which fork of MySQL has better performance? [closed]
Since Oracle bought the rights on MySQL, there are some forks of MySQL out now.
I wonder which fork I should choose for my application.
Is MariaDB the only choice?
2
votes
1answer
62 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
2answers
133 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+ ...
0
votes
0answers
37 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?
2
votes
3answers
135 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 ...
2
votes
1answer
224 views
MariaDB, Triggers and last_insert_id
I have a situation where I have three tables: sample, sample_name and run (extra columns removed to be only relevant information).
CREATE TABLE `sample` (
`sample_id` int unsigned NOT NULL ...
0
votes
1answer
124 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
2answers
317 views
how to import mysql system “mysql” database [closed]
This question might be already answered but it's almost impossible to google it.
When I perform full backup of mysql server using
mysqldump --all-databases
then reinstall it from scratch I want to ...
1
vote
1answer
80 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
0answers
215 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/.
...
1
vote
1answer
188 views
MariaDB allowing select only user to create databases
I'm baffled. I have a select only user, but somehow, the user can create a new database, and create table inside the new database. It can't create tables inside other db. It's really odd.
This is ...
2
votes
3answers
106 views
mariadb ignoring force index
I'm trying to tune a relatively simple query:
select bt.col1,bt.col2
from bigtable bt
join smalltable st on bt.smalltable_id = st.smalltable_id
where st.name = 'some name occuring only once in st'
...
1
vote
0answers
167 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 ...
3
votes
4answers
339 views
TRUNCATE TABLE statement sometimes hangs
Why does the TRUNCATE TABLE statement hang sometimes? What are the reasons for this type of issue?
I am migrating from MySQL to MariaDB. This problem doesn't happen with MySQL, only with MariaDB.
...
2
votes
1answer
237 views
Error 1046 Mariadb: No database selected
GRANT ALL ON my-database.* TO [email protected] IDENTIFIED BY 'password';
ERROR 1046 (3D000): No database selected
Ok I have created a database with a "-" on the name (did the same thing on the ...
1
vote
1answer
695 views
MariaDB and XtraDB/InnoDB plugins
In my vps, I thought of switching from MySQL to MariaDB (using Monty's repository for Debian Squeeze). Copying over my.cnf from MySQL to MariaDB, I saw that the new config file (the one from the ...
4
votes
1answer
186 views
Optimizing MySQL -
I've been researching how to optimize MySQL a bit, but I still have a few questions.
MySQL Primer Results
http://pastie.org/private/lzjukl8wacxfjbjhge6vw
Based on this, the first problem seems to be ...
4
votes
3answers
2k views
Is MariaDB a suitable drop in replacement for MySQL on a standard LAMP stack?
I've been wondering lately what (if any) are the improvements available in MariaDB over 'conventional' MySQL?
I understand that where platform interoperability and/or backwards compatibility may be ...
0
votes
1answer
228 views
Should I use mysql_upgrade after mysqld_safe when upgrading MariaDB?
I'm wanting to know the best practice to do a MariaDB upgrade on opensuse.
I am getting this error:
mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db =
'a_database'': Cannot load from ...
1
vote
1answer
2k views
Do you still use MyISAM or prefer Aria storage engine?
If Aria storage engine (previously called Maria) is the "new" MyISAM, which supports transaction and automatic crash recovery:
Why still use MyISAM ?
Should changing storage engine from MyISAM to ...
1
vote
2answers
445 views
Is there any performance difference among MariaDB (xtradb plugin) and XtraDB Server for InnoDB?
Title says it all. However i have to enter at least 30 characters.
2
votes
1answer
1k views
MariaDB XtraDB Performance Tuning
I believe that innodb has a single read thread. However, with MariaDB you can set multiple read threads. I'm unsure what the recommended value would be.
Questions
Does anyone have any experience ...
1
vote
0answers
228 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?
...
4
votes
1answer
527 views
Substantial difference between database size under MySQL and actual size on disk
When I check the size of my databases under MySQL I get this:
MariaDB [(none)]> SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB", ...
5
votes
2answers
1k views
How can I improve my SQL statement with weekly results with week starting on Thursday or any other day of the week?
I am a total newb, and I couldn't find a good way to do this anywhere. I have a database table that contains statistics that are recorded at various time throughout the week. The reporting week ...
12
votes
2answers
3k views
How do I properly perform a MySQL bake-off?
I want to performance test (aka bake-off) MySQL server rpm against some other forks such as Percona server, MariaDB, and possibly some others. I'm hoping that by asking this question I can better ...
9
votes
3answers
2k views
Why does importing a 12 GB .sql file take more than 36 hours?
I've been waiting now for 36 hours for a 12 GB .sql file to be imported with a simple type site.sql | mysql command. I can see the ibdata1 is growing still, currently nearly 40 GB.
Considering the ...
4
votes
2answers
958 views
After I kill my clients, MySQL continues to process queries for hours
Hi I have a MySQL db with 10 million rows with lots of triggers. A php client connects to mysql and INSERT's hundreds of rows per second.
When the client has been running for hours, and I terminate ...
23
votes
5answers
2k views
When is the right time to use MariaDB instead of MySQL, and Why?
What we earn and what we lost with this migration?
What should I expect as drawbacks after the migration?
Is it really unnecessary to change the applications in any situation?
