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

mariadb client hangs when starting to access a database with 300 600-column tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Won't Fix
    • 10.6.5
    • N/A
    • Scripts & Clients
    • None
    • Centos 8 VM, 32GB memory

    Description

      Build tested: ColumnStore 6.2.2-1
      Server version: 10.6.5-2-MariaDB MariaDB Server

      After creating 300 600-column InnoDB tables using the attached scripts, the following command would hang. Is there a server setting the would help with this situation?

      [centos8:root~]# mariadb mytest
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
      

      It also hang with the following

      [centos8:root~]# mariadb
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 1811
      Server version: 10.6.5-2-MariaDB MariaDB Server
       
      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> use mytest
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
      

      Accessing the same database this way works fine

      mariadb mytest -e 'show tables;'
      

      It does not hang when accessing other databases. While hanging, the mariadb process is utilizing almost 100% CPU.

          PID USER      PR  NI    VIRT    RES    SHR S  %CPU  %MEM     TIME+ COMMAND                                                                                            
        11847 root      20   0   57156  23804   7260 R  99.0   0.1   0:12.63 mariadb                                                                  
      

      Attachments

        1. wideTableInnodb-1.sql
          14 kB
          Daniel Lee
        2. createTablesInnodb.sh
          0.3 kB
          Daniel Lee

        Activity

          People

            serg Sergei Golubchik
            dleeyh Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.