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

strcmp() takes 0.37% in OLTP RO

        Details

        • Type: Bug
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Affects Version/s: 10.1
        • Fix Version/s: 10.1
        • Component/s: None
        • Labels:
          None

          Description

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

          Call graphs:

          -   0.37%  mysqld  libc-2.15.so
   - __strcmp_sse42
      + 43.10% Protocol::store_string_aux(char const*, unsigned long, charset_info_st const*, charset_info_st const*)
      + 27.26% ha_innobase::change_active_index(unsigned int)
      + 20.46% open_table(THD*, TABLE_LIST*, Open_table_context*)
      + 7.66% ha_innobase::records_in_range(unsigned int, st_key_range*, st_key_range*)
      + 1.52% Item::set_name(char const*, unsigned int, charset_info_st const*)

          Protocol::store_string_aux() calls my_charset_same(), which does strcmp(). This can be optimized out.

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

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

                    Dates

                    • Created:
                      Updated: