i am currently in the progress of implementing xtraBackup - to be able to set up database replication.
The database is very small at time - ibdata1 file is only around 300MB.
Load is not that high - around 170 queries per second, 30% update, 10% insert.
Database is a 5.5.29-MariaDB-mariadb1~precise-log - on an ubuntu 12.04 64bit Xen VM - with 16GB RAM and 24 E5-2620 CPU’s. Using built in XtraDB engine.
So, starting from this i thought it would be absolut no problem to start XtraBackup - it should be able to complete in a few seconds.
But as soon as i start it - and as soon as it comes to scaning the logs - my database starts to block queries - because of a table level lock.
I do have one special table in my database - it is a memory table - for statistical updates.
The queries which does start to block because the have to wait - do write entries in this table - and some external scripts are reading from there and updating there…
Could the memory table cause the problem ?
I have also already tried the --no-lock option - does have no affect
Any Ideas ?