5.19:Reporting-database-specification/concurrent users/ja

• English

• 5.19 • 5.3 • 5.8

concurrent_users

concurrent_users 表は、過去にシステムを使用していたユーザーの数を追跡します。ログインしたユーザーの数がゼロ以外の値から変更されるたびに（つまり、最初のユーザー以外のユーザーがログインまたはいずれかのユーザーがログアウトするたびに）、1分間以上に1回の頻度で新しい行が追加されます（1分以内に初回のログイン/ログアウトが行われた後、その同じ1分以内に行われるすべてのログイン/ログアウトがまとめられ、1分後に１件のレコードとして書き込まれます）。 日次統計のリセット時間においても新しいレコードが自動的に作成されます。

Description of Data

The following table offers the name (i.e., ID), data type (e.g., BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHAR, etc.), and description for each metric (i.e., column) of the concurrent_users table.

Column Name	Data Type	Description
num_users	INT	Number of users that were logged into the system in the interval specified by start_time and end_time
users	JSON array	This is a list of usernames of users that were logged into the system in the interval specified by start_time and end_time. Users are specified as JSON array of [username1, username2, … usernameN] where N = num_users.
start_time	TIMESTAMP	Start time of the interval for which the num_users and users data in this record remains valid. Time is given in Universal Coordinated Time (UTC), and the time is rounded to a minute. Note that it is normal for this time to differ by a few seconds from the time of state changes reported in the agent_activity table.
end_time	TIMESTAMP	End time of the interval for which the num_users and users data in this record remains valid. Time is given in Universal Coordinated Time (UTC), and the time is rounded to a minute. Note that it is normal for this time to differ by a few seconds from the time of state changes reported in the agent_activity table.

< 前へ | 次へ >