Buy Percona ServicesBuy Now!

Find all sql statements larger than X bytes?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Find all sql statements larger than X bytes?

    Can any of the tools in Percona Toolkit log all SQL queries where the statement text is larger than a certain size?

  • #2
    I don't think there is any filter exists to log queries on basis of query size. However, queries do log "Bytes Sent" information against each query which is amount of bytes sent for the result of the query. Along with that, you can log extended information and stats for Percona Server in slow log as described in https://www.percona.com/doc/percona-..._extended.html

    Comment


    • #3
      You can use pt-kill with a custom filter: https://www.percona.com/doc/percona-...pt-kill-filter

      Comment

      Working...
      X