socket_instances

Overview

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

See also: Performance Schema in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

DETAILS

SCHEMA

CREATE TABLE `socket_instances` (
  `EVENT_NAME` varchar(128) NOT NULL COMMENT 'NAME from the setup_instruments table, and the name of the wait/io/socket/* instrument that produced the event.',
  `OBJECT_INSTANCE_BEGIN` bigint(20) unsigned NOT NULL COMMENT 'Memory address of the object.',
  `THREAD_ID` bigint(20) unsigned DEFAULT NULL COMMENT 'Thread identifier that the server assigns to each socket.',
  `SOCKET_ID` int(11) NOT NULL COMMENT 'The socket''s internal file handle.',
  `IP` varchar(64) NOT NULL COMMENT 'Client IP address. Blank for Unix socket file, otherwise an IPv4 or IPv6 address. Together with the PORT identifies the connection.',
  `PORT` int(11) NOT NULL COMMENT 'TCP/IP port number, from 0 to 65535. Together with the IP identifies the connection.',
  `STATE` enum('IDLE','ACTIVE') NOT NULL COMMENT 'Socket status, either IDLE if waiting to receive a request from a client, or ACTIVE'
)

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

  • Schema changed in MariaDB Enterprise Server 10.6.5-2: ...

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

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

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

  • Schema changed in MariaDB Enterprise Server 10.5.13-9: ...

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

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

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

  • Schema changed in MariaDB Community Server 10.4.22-14: ...

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

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

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

  • Schema changed in MariaDB Community Server 10.3.32-14: ...

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

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

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

  • Schema changed in MariaDB Community Server 10.2.41-14: ...

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

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

EXTERNAL REFERENCES