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

LP #673622: Add more information to TABLE_STATISTICS and USER_STATISTICS

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Olivier Doucet last update 24-05-2013 05:11:15

      Hello,

      The MySQL Server Facebook Edition offers many useful fields in table_statistics :

      • `TABLE_ENGINE` varchar(192) NOT NULL DEFAULT '',
      • `ROWS_INSERTED` bigint(21) NOT NULL DEFAULT '0',
      • `ROWS_UPDATED` bigint(21) NOT NULL DEFAULT '0',
      • `ROWS_DELETED` bigint(21) NOT NULL DEFAULT '0',
      • `ROWS_READ` bigint(21) NOT NULL DEFAULT '0',
      • `ROWS_REQUESTED` bigint(21) NOT NULL DEFAULT '0',
      • `IO_READ_BYTES` bigint(21) NOT NULL DEFAULT '0',
      • `IO_READ_REQUESTS` bigint(21) NOT NULL DEFAULT '0',
      • `IO_READ_SVC_USECS` bigint(21) NOT NULL DEFAULT '0',
      • `IO_READ_SVC_USECS_MAX` bigint(21) NOT NULL DEFAULT '0',
      • `IO_READ_WAIT_USECS` bigint(21) NOT NULL DEFAULT '0',
      • `IO_READ_WAIT_USECS_MAX` bigint(21) NOT NULL DEFAULT '0',
      • `IO_READ_OLD_IOS` bigint(21) NOT NULL DEFAULT '0',
      • `IO_WRITE_BYTES` bigint(21) NOT NULL DEFAULT '0',
      • `IO_WRITE_REQUESTS` bigint(21) NOT NULL DEFAULT '0',
      • `IO_WRITE_SVC_USECS` bigint(21) NOT NULL DEFAULT '0',
      • `IO_WRITE_SVC_USECS_MAX` bigint(21) NOT NULL DEFAULT '0',
      • `IO_WRITE_WAIT_USECS` bigint(21) NOT NULL DEFAULT '0',
      • `IO_WRITE_WAIT_USECS_MAX` bigint(21) NOT NULL DEFAULT '0',
      • `IO_WRITE_OLD_IOS` bigint(21) NOT NULL DEFAULT '0',
      • `IO_INDEX_INSERTS` bigint(21) NOT NULL DEFAULT '0'

      There are also new fields in user_statistics :

      • `ROWS_DELETED` bigint(21) NOT NULL DEFAULT '0',
      • `ROWS_INSERTED` bigint(21) NOT NULL DEFAULT '0',
      • `ROWS_READ` bigint(21) NOT NULL DEFAULT '0',

      This could be useful to add it in Percona Server.

      Related commits in Facebook edition are : (may missed some, I'm not a mysql internals guru) :
      http://bazaar.launchpad.net/~mysqlatfacebook/mysqlatfacebook/5.1/revision/3431

      Other revisions you may take a look at :
      3563 ; 3548 ; 3547 ; 3434 ; 3424 ;

        Smart Checklist

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated: