Re: MYSQL import performance issue

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Using iDoctor is the the only way to know for sure...

But I'd guess that the R&D partition has more memory and/or disk i/o
available for this process to use than the production partition does...

Even if production has more total memory / disk I/O.

What's WRKDSKSTS show while the process is running?
What subsystem/memory pools are being used?

Charles


On Fri, May 10, 2019 at 11:55 AM Steinmetz, Paul via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> Trying to find the cause of a performance issue Importing a file from
> MYSQL data base on a Linux server to a P9 i5/OS V7R3.
> Currently using RDB import API via RPGLE, which uses jdk80/64bit in a
> background task.
> We've exhausted the resources and support from RDB, they have been very
> helpful.
> We pull / import every record from PSIW2BRCUSERDB using Power9 RDB API
> utility.
> Production is physical server, with ample resources.
> R&D is a VM, also with ample resources.
>
> R&D is considerably faster than Production.
> Looking for the bottleneck/root cause why Production is slower.
>
> Process is 100% successful, no failures, simply slow as molasses.
> 3.5 m records should not take this long.
> Any thoughts from the group on how pinpoint the cause?
> Also, can anyone in the group recommend alternate solutions.
>
> Production
> WS02PROD   MYSQL      WSO2 Prod Database
> I/P Address.......: aaa.pencor.com
> Port 3306
> 3,389,132 records
> 67 minutes.
>
> R&D
> WSO2DEV    MYSQL      WSO2 Dev Database
> I/P Address.......: bbb.pencor.com
> Port 3306
> 3,355,272 records
> 42 minutes.
>
>
> Thank You
> _____
> Paul Steinmetz
> IBM i Systems Administrator
>
> Pencor Services, Inc.
> 462 Delaware Ave
> Palmerton Pa 18071
>
> 610-826-9117 work
> 610-826-9188 fax
> 610-349-0913 cell
> 610-377-6012 home
>
> psteinmetz@xxxxxxxxxx
> http://www.pencor.com/
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com