PROFILING Table

Overview

A description for this Information-schema Table has not yet been added to this Documentation.

USAGE

DETAILS

SYNONYMS

SCHEMA

CREATE TEMPORARY TABLE `PROFILING` (
  `QUERY_ID` int(20) NOT NULL,
  `SEQ` int(20) NOT NULL,
  `STATE` varchar(30) NOT NULL,
  `DURATION` decimal(9,6) NOT NULL,
  `CPU_USER` decimal(9,6),
  `CPU_SYSTEM` decimal(9,6),
  `CONTEXT_VOLUNTARY` int(20),
  `CONTEXT_INVOLUNTARY` int(20),
  `BLOCK_OPS_IN` int(20),
  `BLOCK_OPS_OUT` int(20),
  `MESSAGES_SENT` int(20),
  `MESSAGES_RECEIVED` int(20),
  `PAGE_FAULTS_MAJOR` int(20),
  `PAGE_FAULTS_MINOR` int(20),
  `SWAPS` int(20),
  `SOURCE_FUNCTION` varchar(30),
  `SOURCE_FILE` varchar(20),
  `SOURCE_LINE` int(20)
)

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

11.4 Enterprise

  • Not present.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

  • Schema changed in MariaDB Enterprise Server 10.6.7-3: ...

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

  • Schema changed in MariaDB Community Server 10.6.6: ...

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

  • Schema changed in MariaDB Enterprise Server 10.5.15-10: ...

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

  • Schema changed in MariaDB Community Server 10.5.14: ...

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

  • Schema changed in MariaDB Enterprise Server 10.4.24-15: ...

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

  • Schema changed in MariaDB Community Server 10.4.23: ...

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

  • Schema changed in MariaDB Enterprise Server 10.3.34-15: ...

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

  • Schema changed in MariaDB Community Server 10.3.33: ...

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

  • Schema changed in MariaDB Community Server 10.2.2: ...

Release Series

History

11.4 Enterprise

  • Not present.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

  • Schema changed in MariaDB Enterprise Server 10.6.7-3: ...

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

  • Schema changed in MariaDB Enterprise Server 10.5.15-10: ...

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

  • Schema changed in MariaDB Enterprise Server 10.4.24-15: ...

EXTERNAL REFERENCES