Forum Stats

  • 3,727,536 Users
  • 2,245,406 Discussions
  • 7,852,848 Comments

Discussions

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

User_2MOTF
User_2MOTF Member Posts: 2 Red Ribbon

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

Best Answer

Answers

  • User_ONCZQ
    User_ONCZQ Member Posts: 2 Green Ribbon

    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
    User_2MOTF Member Posts: 2 Red Ribbon

    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

Sign In or Register to comment.