OGG Extract Capturing Data from MySQL 5.6 is Very Slow (Doc ID 1930612.1)

Last updated on JULY 31, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

Oracle GoldenGate Capture for MySQL
Version 12.1.2.0.1 17597485 19147930
Linux, x64, 64bit (optimized), MySQL Enterprise on Jul 3 2014 10:48:55

MySQL
Server Version: 5.6.16-enterprise-commercial-advanced-log

2014-07-16 09:50:41 INFO OGG-01021 Command received from GGSCI: STATUS.
  303 records processed as of 2014-07-16 09:52:09 (rate 1,delta 1)
  604 records processed as of 2014-07-16 09:57:09 (rate 1,delta 1)
  905 records processed as of 2014-07-16 10:02:10 (rate 1,delta 1)
  1205 records processed as of 2014-07-16 10:07:10 (rate 1,delta 0)

2014-07-16 10:10:56 INFO OGG-01021 Command received from GGSCI: REPORT.

The trace shows:

SUMMARY STATISTICS

General statistics:
 0.07% Checking messages (includes checkpointing)
   0.00% Checking periodic tasks
20.08% Waiting for more data
 0.00% Converting ASCII data to internal
79.76% Reading input records
 0.00% Writing output records (replicate_io)
   0.00% Mapping columns
   0.00% Outputting data records
   0.00% Performing SQL statements
 0.00% Executing BATCHSQL statements
 0.00% Executing SQL statements
 0.00% Preparing SQL statements
 0.00% Commit operations
 0.00% Rollback operations
 0.06% Checkpointing

VAM INTERFACE SUMMARY STATISTICS
 0.01% Executing VAM API call to VAMInitialize
79.73% Executing VAM API call to VAMRead
 0.00% Executing VAM API call to VAMControl
20.24% Executing GoldenGate Extract internal calls

when a slow read happens this can be seen:

09:36:32.686 (231057) * --- entering READ_EXTRACT_RECORD --- *
09:36:32.686 (231057) entering VAMRead
09:36:32.686 (231057) exited VAMRead
09:36:32.686 (231057) entering VAMRead
09:36:33.687 (232058) exited VAMRead
09:36:33.687 (232058) exited READ_EXTRACT_RECORD (stat=520, seqno=0, rba=0)
09:36:33.687 (232058) entering IPC_read_TCP with hndl->ip.sock -1 and listen_sock 5

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms