Uploaded image for project: 'MariaDB Server'
  1. MDEV-4412

SLOW QUERY LOG - add affected rows (UPDATE / DELETE) in slow query log

    Details

    • Type: Task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Fix Version/s: 10.1.2
    • Component/s: OTHER
    • Labels:
      None

      Description

      hi guys i was running a update and it was logged in slow query

      # Time: 130422 10:34:20
      # User@Host: rspadim[rspadim] @  [179.233.54.101]
      # Thread_id: 10019  Schema: 19_org  QC_hit: No
      # Query_time: 17.094863  Lock_time: 0.000066  Rows_sent: 0  Rows_examined: 1301065
      SET timestamp=1366637660;
      UPDATE `nf_itens` SET `valor_produto_grandeza`='pl' WHERE  `id_item`=1;
      

      the point is... how many rows it changed? could it be logged in slow query log? since my write speed is slow, since it's a raid1 (faster read than write)

      tnkx!

        Attachments

          Activity

            People

            • Assignee:
              nirbhay_c Nirbhay Choubey
              Reporter:
              rspadim roberto spadim
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 1 hour
                1h
                Remaining:
                Time Spent - 30 minutes Remaining Estimate - 30 minutes
                30m
                Logged:
                Time Spent - 30 minutes Remaining Estimate - 30 minutes
                30m