issue with table hit rows in server my sql

  • Resolved shabbirpadela

    (@shabbirpadela)


    3 years, 2 months ago

    CPU_TIME:214 table_rows_read:377967125 SELECTS:10959 ROWS_UPDATED:556 ROWS_FETCHED:1252978 BUSY_TIME:215 ONNECTED_TIME:413 BYTES_SENT:152253154 BYTES_RECEIVED:2471781 WAIT_TIME:1

    Top table row reads:
    DB_USER: **** — TOTAL_CONNECTIONS: 78 — CONNECTED_TIME: 413 — CPU_TIME: 215 — TABLE_ROW_READS: 378583516 — SELECT_COMMANDS: 10968 — UPDATE_COMMANDS: — BUSY_TIME: 215 — BYTES_SENT: 152531682 — BYTES_RECEIVED: 2474173 — WAIT_TIME (IO): 0

    Top WAIT (IO) TIME:
    DB_USER: **** — TOTAL_CONNECTIONS: 78 — CONNECTED_TIME: 413 — CPU_TIME: 215 — TABLE_ROW_READS: 378583560 — SELECT_COMMANDS: 10969 — UPDATE_COMMANDS: — BUSY_TIME: 215 — BYTES_SENT: 152531682 — BYTES_RECEIVED: 2474277 — WAIT_TIME (IO): 0

    COMMAND: Query
    INFO: SELECT t1.* FROM wp_postmeta AS t1 JOIN (SELECT meta_id FROM wp_postmeta WHERE 1 ORDER BY meta_id LIMIT 615000, 1000) AS t2 USING (meta_id)

    Open connections

    Table rows read hit 377967125 > 300000000

    Cause of this query our serve performance face some issue

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Yani

    (@yaniiliev)

    I don’t follow, what is the issue here?

    Thread Starter shabbirpadela

    (@shabbirpadela)

    Cause of this query and action schedule of all in one plugin
    all server resources utilized and row read limit exceed
    how to control this?

    Plugin Author Yani

    (@yaniiliev)

    The plugin is exporting the database.
    It is reading 1000 records at a time. It writes them to the backup and so on.
    If you need to read less than 1,000 records at a time, you can change this by editing AI1WM_MAX_SELECT_RECORDS in constants.php around line 431.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘issue with table hit rows in server my sql’ is closed to new replies.