Skip to Content
avatar image
Former Member

mysql performance with Dataservices 4.2


I'm testing Dataservices 4.2 with mysql 5.5.

Copy 58 000 rows  from Mysql to  another Mysql Database on the same instance 43 s

Copy 58 000 rows from mysql  to MS sqlserver 2008   3s

Copy From Oracle, MS sqlserver 2008, ...  to mysql     40 s

Copy From Oracle, MS sqlserver 2008, ...   to MS sqlserver 2008     10 S

I check also a copy  with mysql workbench  6.2 wizard from another database to mysql and the results is 10 s

Can somebody help me. is it a problem of Mysql system or a problem Dataservices- Mysql ??

Ps: i have the same problem with mysql 5.1

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 15, 2015 at 10:10 AM

    Hi

    The list of possible issues is endless in such cases.

    First check your hardware. Is the MYSQL installed on the same disk as the data services ? Then, if the disk is not a high rpm variety with a substantial amount of cache, then you will face such a situation.

    Does the MYSQL database server have the same kind of hardware configuration like the MSSQL databse server you are benchmarking against.

    Start your checks with these and if we can eliminate these obvious areas where performance can be an issue, then we can focus on other issues.

    kind regards

    Raghu

    Add comment
    10|10000 characters needed characters exceeded