Tagged Questions
0
votes
1answer
22 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). ...
1
vote
1answer
44 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 ...
1
vote
2answers
106 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+ ...
1
vote
1answer
619 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 ...
1
vote
2answers
437 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 ...
