How Can I receive data in the table performance_schema.host_cache about bad connections on database.

User_2MOTF

I have several abort_connections records in my database and I would like to know which instrumentation to enable in the performance schema settings to receive this information.

Can someone help me?

Thank's

William

User_ONCZQ

HI William,

Good to see that you got the required info. Hope this solution answered your question

I think we cannot get this info from any of the meta tables in information schema and performance schema.

Thanks

Srinivas

User_ONCZQ

you can see Aborted connections info in your error log

you can grep your error log with aborted connections

cat <location of errorlogfile > | grep Aborted

Thanks

Srinivas

User_2MOTF

Hi Srinivas

Follows output:

2020-12-07T16:27:31.793163-03:00 18892 [Note] Aborted connection 18892 to db: 'AUTCOM' user: 'envia' host: '191.255.226.44' (Got timeout reading communication packets)

2020-12-07T16:28:41.197646-03:00 18947 [Note] Aborted connection 18947 to db: 'AUTCOM' user: 'envia' host: '191.255.226.44' (Got timeout reading communication packets)

2020-12-07T16:30:28.515654-03:00 19021 [Note] Aborted connection 19021 to db: 'AUTCOM' user: 'envia' host: '191.255.226.44' (Got timeout reading communication packets)

2020-12-07T16:31:53.383054-03:00 19064 [Note] Aborted connection 19064 to db: 'AUTCOM' user: 'envia' host: '191.255.226.44' (Got timeout reading communication packets)

2020-12-07T16:32:07.728633-03:00 19132 [Note] Aborted connection 19132 to db: 'AUTCOM' user: 'usuario_citel1' host: '192.168.15.11' (Got an error reading communication packets)

2020-12-07T16:32:12.563115-03:00 19077 [Note] Aborted connection 19077 to db: 'AUTCOM' user: 'envia' host: '191.255.226.44' (Got timeout reading communication packets)

2020-12-07T16:32:18.712830-03:00 19144 [Note] Aborted connection 19144 to db: 'AUTCOM' user: 'usuario_citel1' host: '192.168.15.11' (Got an error reading communication packets)

2020-12-07T16:32:18.712898-03:00 19141 [Note] Aborted connection 19141 to db: 'AUTCOM' user: 'usuario_citel1' host: '192.168.15.11' (Got an error reading communication packets)

2020-12-07T16:32:26.441823-03:00 19153 [Note] Aborted connection 19153 to db: 'AUTCOM' user: 'usuario_citel1' host: '192.168.15.11' (Got an error reading communication packets)

2020-12-07T16:36:32.220723-03:00 19238 [Note] Aborted connection 19238 to db: 'AUTCOM' user: 'envia' host: '191.255.226.44' (Got timeout reading communication packets)

Best regards

User_ONCZQ

HI William,

Good to see that you got the required info. Hope this solution answered your question

I think we cannot get this info from any of the meta tables in information schema and performance schema.

Thanks

Srinivas