Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Won't Fix
-
10.6.5
-
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
Activity
| Field | Original Value | New Value |
|---|---|---|
| Rank | Ranked higher |
| issue.field.resolutiondate | 2022-01-27 22:17:01.0 | 2022-01-27 22:17:01.605 |
| Component/s | Scripts & Clients [ 11002 ] | |
| Fix Version/s | N/A [ 14700 ] | |
| Assignee | Sergei Golubchik [ serg ] | |
| Resolution | Won't Fix [ 2 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
No, there is a client setting that would help with this situation. You've pasted it twice yourself: