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

handler::rebind_psi() takes 0.07% in OLTP RO

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.1
        • Fix Version/s: 10.1.6
        • Component/s: OTHER
        • Labels:
          None

          Description

          Data comes from Sandy Bridge system running sysbench OLTP RO in 1 thread against 1 table.

          Call graphs:

          -   0.07%  mysqld  mysqld
   - handler::rebind_psi()
      + 73.91% open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*)
      + 26.09% open_table(THD*, TABLE_LIST*, Open_table_context*)

          Most time spent for function call convention. It also adds ~0.03% to open_table(). Try to make it inline.

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Github revision

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  svoj Sergey Vojtovich added a comment -

                  Sergei Golubchik, please review fix for this bug.

                  Show
                  svoj Sergey Vojtovich added a comment - Sergei Golubchik , please review fix for this bug.
                  Hide
                  Permalink
                  svoj Sergey Vojtovich added a comment -

                  Sergei Golubchik, please review updated fix.

                  Show
                  svoj Sergey Vojtovich added a comment - Sergei Golubchik , please review updated fix.

                    People

                    • Assignee:
                      svoj Sergey Vojtovich
                      Reporter:
                      svoj Sergey Vojtovich
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Agile