501 lines
16 KiB
Plaintext
501 lines
16 KiB
Plaintext
Verify [No socket from X Plugin should be reported]
|
|
Verify [Check the IP and PORT of TCP socket]
|
|
Check if clinet_socket are reported in proper way in PFS
|
|
Verify [Checking if X Plugin reports 1 connections]
|
|
connecting...
|
|
active session is now 'NAME_2'
|
|
Verify [Checking if X Plugin reports 2 connections]
|
|
connecting...
|
|
active session is now 'NAME_3'
|
|
Verify [Checking if X Plugin reports 3 connections]
|
|
connecting...
|
|
active session is now 'NAME_4'
|
|
Verify [Checking if X Plugin reports 4 connections]
|
|
connecting...
|
|
active session is now 'NAME_5'
|
|
Verify [Checking if X Plugin reports 5 connections]
|
|
connecting...
|
|
active session is now 'NAME_6'
|
|
Verify [Checking if X Plugin reports 6 connections]
|
|
connecting...
|
|
active session is now 'NAME_7'
|
|
Verify [Checking if X Plugin reports 7 connections]
|
|
connecting...
|
|
active session is now 'NAME_8'
|
|
Verify [Checking if X Plugin reports 8 connections]
|
|
connecting...
|
|
active session is now 'NAME_9'
|
|
Verify [Checking if X Plugin reports 9 connections]
|
|
connecting...
|
|
active session is now 'NAME_10'
|
|
Verify [Checking if X Plugin reports 10 connections]
|
|
connecting...
|
|
active session is now 'NAME_11'
|
|
Verify [Checking if X Plugin reports 11 connections]
|
|
Verify [Peer addresses of all sockets should be set to ::ffff:127.0.0.1]
|
|
Verify [Peer ports should be unique]
|
|
Check if we have connection ACTIVE and IDLE state
|
|
STATE
|
|
IDLE
|
|
ACTIVE
|
|
0 rows affected
|
|
switched to session NAME_11
|
|
closing session NAME_11
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
switched to session NAME_10
|
|
closing session NAME_10
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
switched to session NAME_9
|
|
closing session NAME_9
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
switched to session NAME_8
|
|
closing session NAME_8
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
switched to session NAME_7
|
|
closing session NAME_7
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
switched to session NAME_6
|
|
closing session NAME_6
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
switched to session NAME_5
|
|
closing session NAME_5
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
switched to session NAME_4
|
|
closing session NAME_4
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
switched to session NAME_3
|
|
closing session NAME_3
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
switched to session NAME_2
|
|
closing session NAME_2
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
switched to session default
|
|
Verify [Checking if X Plugin reports 1 connections]
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
No socket should be reported by X Plugin
|
|
Verify [Checking if data in column `COUNT_READ` had increased]
|
|
Verify [Checking if data in column `COUNT_READ` had increased]
|
|
Verify [Checking if data in column `COUNT_READ` had increased]
|
|
Verify [Checking if data in column `COUNT_READ` had increased]
|
|
Verify [Checking if data in column `COUNT_WRITE` had increased]
|
|
Verify [Checking if data in column `COUNT_WRITE` had increased]
|
|
Verify [Checking if data in column `COUNT_WRITE` had increased]
|
|
Verify [Checking if data in column `COUNT_WRITE` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_WRITE` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_WRITE` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_WRITE` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_WRITE` had increased]
|
|
Verify [Checking if data in column `SUM_TIMER_READ` had increased]
|
|
Verify [Checking if data in column `SUM_TIMER_READ` had increased]
|
|
Verify [Checking if data in column `SUM_TIMER_READ` had increased]
|
|
Verify [Checking if data in column `SUM_TIMER_READ` had increased]
|
|
Verify [Checking if data in column `SUM_TIMER_WRITE` had increased]
|
|
Verify [Checking if data in column `SUM_TIMER_WRITE` had increased]
|
|
Verify [Checking if data in column `SUM_TIMER_WRITE` had increased]
|
|
Verify [Checking if data in column `SUM_TIMER_WRITE` had increased]
|
|
connecting...
|
|
active session is now 'second_session'
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
connecting...
|
|
active session is now 'temporary_connection'
|
|
Verify [Checking if data in column `COUNT_MISC` had increased]
|
|
closing session temporary_connection
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
switched to session default
|
|
Verify summary table
|
|
Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|