Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-1957

LP #1089031: Slow query log XtraDB extensions not tested in MTR

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Laurynas Biveinis last update 11-02-2013 08:11:27

      XtraDB provides the following info for the slow query log:
      InnoDB_trx_id,
      InnoDB_IO_r_ops,
      InnoDB_IO_r_bytes,
      InnoDB_IO_r_wait,
      InnoDB_rec_lock_wait,
      InnoDB_queue_wait,
      InnoDB_pages_distinct.

      Of these, only InnoDB_trx_id (and perhaps InnoDB_pages_distinct) could be considered tested. The I/O reads are not bumped in MTR because all the data is in the buffer pool, and the lock/queue waits are not even remotely tested.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist