Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: CPU usage while running ETL's

  1. #1
    Join Date
    Aug 2015

    Default CPU usage while running ETL's


    I am facing issues with CPU usage up to 99% while running ETL's(i.e. while trying to retrieve data from OLTP to Datamart). creating lot of problem/hanging my etl's.

    My problem here is : even though my job completed successfullly CPU usage is not getting down, how to release locks? please please help me.
    currently runnig ETL's in AMAZON server with java 1.7 64 bit mixed mode, Windows OS, MySQL database, PDI-CE-5.3 and volume of data is 4300000 records

    spoon.bat file java options consist ("-Xmx4096m" "-XX:MaxPermSize=2048m") , am i need to change here ?

    below is my AMAZON server OLTP,WH database machine RAM and CPU details, am i need to upgrade here ? in same server nearly 16 databases were exist.. please help me.
    Name:  CPU usgae.jpg
Views: 73
Size:  9.5 KB

    i am getting issue at sync after merge step, please ask me you need more info.
    Name:  sync after merge.jpg
Views: 75
Size:  10.2 KB
    Last edited by santhi; 11-09-2015 at 06:55 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.