Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
None
-
Distro······: Debian GNU/Linux 11 (bullseye)
Kernel······: Linux 5.10.0-33-amd64
Uptime······: up 9 weeks, 3 days, 21 hours, 42 minutes
Load········: 0.03 (1m), 0.07 (5m), 0.06 (15m)
Processes···: 152 (root), 7 (user), 159 (total)
CPU·········: Intel(R) Xeon(R) Gold 6152 CPU @ 2.10GHz (4 vCPU)
Memory······: 7.8Gi used, 7.4Gi avail, 15Gi total
Distro······: Debian GNU/Linux 11 (bullseye) Kernel······: Linux 5.10.0-33-amd64 Uptime······: up 9 weeks, 3 days, 21 hours, 42 minutes Load········: 0.03 (1m), 0.07 (5m), 0.06 (15m) Processes···: 152 (root), 7 (user), 159 (total) CPU·········: Intel(R) Xeon(R) Gold 6152 CPU @ 2.10GHz (4 vCPU) Memory······: 7.8Gi used, 7.4Gi avail, 15Gi total
Description
The server consumes memory on usage on Information schema.
This server only contains MariaDB running on it.
MariaDB [(none)]> system free -h
|
total used free shared buff/cache available
|
Mem: 15Gi 6.9Gi 361Mi 109Mi 8.3Gi 8.3Gi
|
Swap: 487Mi 87Mi 400Mi
|
MariaDB [(none)]> SELECT table_schema AS "name", SUM(data_length + index_length) AS "size", COUNT(table_name) as "tables" FROM information_schema.TABLES GROUP BY table_schema;
|
|
|
+----------------------------------------------------+-----------+--------+
|
| name | size | tables |
|
+----------------------------------------------------+-----------+--------+
|
| information_schema | 212992 | 82 |
|
| mysql | 118759424 | 31 |
|
| performance_schema | 0 | 80 |
|
| prod_2ertest_fr | 135168000 | 456 |
|
| prod_bageops_fr | 121749504 | 466 |
|
|*** | 138428416 | 500 |
|
+----------------------------------------------------+-----------+--------+
|
53 rows in set (3.600 sec)
|
|
|
MariaDB [(none)]>
|
MariaDB [(none)]> system free -h
|
total used free shared buff/cache available
|
Mem: 15Gi 7.2Gi 153Mi 109Mi 8.2Gi 8.0Gi
|
Swap: 487Mi 87Mi 400Mi
|
MariaDB [(none)]>
|
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
The server consumes memory on usage on Information schema.
This server only contains MariaDB running on it. ``` MariaDB [(none)]> system free -h total used free shared buff/cache available Mem: 15Gi 6.9Gi 361Mi 109Mi 8.3Gi 8.3Gi Swap: 487Mi 87Mi 400Mi MariaDB [(none)]> SELECT table_schema AS "name", SUM(data_length + index_length) AS "size", COUNT(table_name) as "tables" FROM information_schema.TABLES GROUP BY table_schema; +----------------------------------------------------+-----------+--------+ | name | size | tables | +----------------------------------------------------+-----------+--------+ | information_schema | 212992 | 82 | | mysql | 118759424 | 31 | | performance_schema | 0 | 80 | | prod_2ertest_fr | 135168000 | 456 | | prod_bageops_fr | 121749504 | 466 | |*** | 138428416 | 500 | +----------------------------------------------------+-----------+--------+ 53 rows in set (3.600 sec) MariaDB [(none)]> MariaDB [(none)]> system free -h total used free shared buff/cache available Mem: 15Gi 7.2Gi 153Mi 109Mi 8.2Gi 8.0Gi Swap: 487Mi 87Mi 400Mi MariaDB [(none)]> ``` |
The server consumes memory on usage on Information schema.
This server only contains MariaDB running on it. {noformat} MariaDB [(none)]> system free -h total used free shared buff/cache available Mem: 15Gi 6.9Gi 361Mi 109Mi 8.3Gi 8.3Gi Swap: 487Mi 87Mi 400Mi MariaDB [(none)]> SELECT table_schema AS "name", SUM(data_length + index_length) AS "size", COUNT(table_name) as "tables" FROM information_schema.TABLES GROUP BY table_schema; +----------------------------------------------------+-----------+--------+ | name | size | tables | +----------------------------------------------------+-----------+--------+ | information_schema | 212992 | 82 | | mysql | 118759424 | 31 | | performance_schema | 0 | 80 | | prod_2ertest_fr | 135168000 | 456 | | prod_bageops_fr | 121749504 | 466 | |*** | 138428416 | 500 | +----------------------------------------------------+-----------+--------+ 53 rows in set (3.600 sec) MariaDB [(none)]> MariaDB [(none)]> system free -h total used free shared buff/cache available Mem: 15Gi 7.2Gi 153Mi 109Mi 8.2Gi 8.0Gi Swap: 487Mi 87Mi 400Mi MariaDB [(none)]> {noformat} |
This is expected. It needs to open all tables to calculate the result of your query and open tables aren't immediately closed, but go into the table cache, in case you'll need them again
| Component/s | Information Schema [ 14413 ] | |
| Fix Version/s | N/A [ 14700 ] | |
| Resolution | Not a Bug [ 6 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
Memory usage by MariaDB on server:
ps -eo pid,ppid,cmd,%mem,%cpu --sort=-%mem | headPID PPID CMD %MEM %CPU