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

check_table_name() takes 0.19% in OLTP RO

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • 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.19%  mysqld  mysqld
   - check_table_name(char const*, unsigned long, bool)
      + 83.81% st_select_lex::add_table_to_list(THD*, Table_ident*, st_mysql_lex_string*, unsigned long, thr_lock_type, enum_mdl_type, List<Index_hint>*, List<String>*, st_mysql_lex_string*)
      + 16.19% MYSQLparse(THD*)

          There're a couple of problems with check_table_name():

          • use_mb(system_charset_info) condition should be moved out of the loop
          • check_for_path_chars condition should be moved out of the loop

            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: