maria-discuss team mailing list archive

[AskMonty KB <noreply@xxxxxxxxxxxx>]

Hello,

A new question has been asked in "MariaDB Community" by zeeshan_amin. Please answer it at http://mariadb.com/kb/en/sql-server-replication-to-maria-db/ as the person asking the question may not be subscribed to the mailing list.

--------------------------------
Hi,
I am new to Maria DB and have no past experience with MySQL.

I am trying to create replication between SQL Server 2005 and Maria DB 10.0.14
Publication has 2 tables with close to 24 million rows, and taking a long time to load data into Maria DB. 
There is no other user connected to MariaDB, 
Looking at the workbench, i see InnoDB Buffer usage close to 87%, key Efficiency 100%, and Traffic 35KB/sec.
as per current speed 2million rows an hour, its going to take 12 hours to load 24 million rows.

Any help in making this load faster?

Regards
Zee
--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/sql-server-replication-to-maria-db/