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

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

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.2
    • OTHER
    • 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

          Ascending order - Click to sort in descending order
          rspadim roberto spadim created issue -
          rspadim roberto spadim made changes -
          Field Original Value New Value
          Summary add affected rows in slow query log SLOW QUERY LOG - add affected rows in slow query log
          rspadim roberto spadim made changes -
          Summary SLOW QUERY LOG - add affected rows in slow query log SLOW QUERY LOG - add affected rows (UPDATE / DELETE) in slow query log
          serg Sergei Golubchik made changes -
          Fix Version/s 10.1.0 [ 12200 ]
          serg Sergei Golubchik made changes -
          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!           		hi guys i was running a update and it was logged in slow query
          {noformat}
          # 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;
          {noformat}
          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!
          serg Sergei Golubchik made changes -
          Priority Minor [ 4 ] Major [ 3 ]
          serg Sergei Golubchik made changes -
          Assignee Alexey Botchkov [ holyfoot ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 27203 ] MariaDB v2 [ 43098 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.1 [ 16100 ]
          Fix Version/s 10.1.0 [ 12200 ]
          serg Sergei Golubchik made changes -
          Assignee Alexey Botchkov [ holyfoot ]
          serg Sergei Golubchik made changes -
          Assignee Nirbhay Choubey [ nirbhay_c ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Assignee Nirbhay Choubey [ nirbhay_c ] Sergei Golubchik [ serg ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ] Nirbhay Choubey [ nirbhay_c ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Assignee Nirbhay Choubey [ nirbhay_c ] Sergei Golubchik [ serg ]
          Status Stalled [ 10000 ] In Review [ 10002 ]
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ] Nirbhay Choubey [ nirbhay_c ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Assignee Nirbhay Choubey [ nirbhay_c ] Sergei Golubchik [ serg ]
          Status Stalled [ 10000 ] In Review [ 10002 ]
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ] Nirbhay Choubey [ nirbhay_c ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          nirbhay_c Nirbhay Choubey (Inactive) made changes -
          Component/s OTHER [ 10125 ]
          Fix Version/s 10.1.2 [ 15801 ]
          Fix Version/s 10.1 [ 16100 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 43098 ] MariaDB v3 [ 65606 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 65606 ] MariaDB v4 [ 132106 ]

          People

            nirbhay_c Nirbhay Choubey (Inactive)
            rspadim roberto spadim
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.