Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tMySQL component, MiriaDB as DB Version decrease performance.

Hi all,
I am working on migration from AS400DB2 server to MariaDB with some lookups. I notice strange behavior of job performance. 
If in Database Connection I select from dropdown Db Version “MariaDB” job runs two times longer than when selected “MySQL 5”. 
Also I notice that for MariaDB connection Talend Open Studio for Data Integration use mariadb-java-client-1.1.7.jar driver. Now version 1.5.5 is available but I can’t find how to update it in Talend.
Any ideas about strange performance behavior?
Can somebody help to update MariaDB driver used in Talend?
Thanks!
Labels (3)
3 Replies
vapukov
Master II
Master II

Hi Yuriy,
what version of studio? how You use MariaDB connection when measure performance? (write or read)
generally for change JDBC, You need found all XML files related to MySQL and edit them - change information for the new version
than - menu Windows -> View -> Talend -> Modules and update all of them

0683p000009MCQw.png    0683p000009MBzT.png   0683p000009MCEr.png   0683p000009MCUE.png
Anonymous
Not applicable
Author

Hi Vladimir,
Thanks a lot for your help! It worked!
I updated driver to newer version (I used mariadb-java-client-1.5.4) as you described, and performance become even better than with MySQL 5.
Thank you!
vapukov
Master II
Master II

Welcome 0683p000009MACn.png