Details
-
Task
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
Description
The documentation at https://mariadb.com/kb/en/innodb-temporary-tablespaces/ says:
Unlike normal tablespaces, temporary tablespaces are deleted when you stop MariaDB. To shrink temporary tablespaces to their minimum sizes, restart the server.
This means temporary tablespaces will keep growing until MariaDB is restarted. Having to restart MariaDB periodically is not optimal. It would be welcome if MariaDB shrinks temporary tablespaces on disk without restarting.
To achieve this, we would introduce new syntax:
SET GLOBAL innodb_truncate_temporary_tablespace_now=1; |
Attachments
Issue Links
- causes
-
MDEV-33101 Server crashes when starting the server with innodb-force-recovery=6 and enabling the innodb_truncate_temporary_tablespace_now variable.
-
- Closed
-
-
-
- Closed
-
- is blocked by
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
- relates to
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
The documentation at https://mariadb.com/kb/en/innodb-temporary-tablespaces/ says:
> Unlike normal tablespaces, temporary tablespaces are deleted when you stop MariaDB. To shrink temporary tablespaces to their minimum sizes, restart the server. This means temporary tablespaces will keep growing until MariaDB is restarted. Having to restart MariaDB periodically is not optimal. It would be welcome if MariaDB shrinks temporary tablespaces on disk without restarting. |
The documentation at https://mariadb.com/kb/en/innodb-temporary-tablespaces/ says:
{quote}Unlike normal tablespaces, temporary tablespaces are deleted when you stop MariaDB. To shrink temporary tablespaces to their minimum sizes, restart the server.{quote} This means temporary tablespaces will keep growing until MariaDB is restarted. Having to restart MariaDB periodically is not optimal. It would be welcome if MariaDB shrinks temporary tablespaces on disk without restarting. |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Component/s | Storage Engine - InnoDB [ 10129 ] | |
| Assignee | Marko Mäkelä [ marko ] |
| Link | This issue relates to MENT-1304 [ MENT-1304 ] |
| Assignee | Marko Mäkelä [ marko ] | Thirunarayanan Balathandayuthapani [ thiru ] |
| Fix Version/s | 10.12 [ 28320 ] |
| Link |
This issue blocks |
| Link |
This issue is blocked by |
| Priority | Minor [ 4 ] | Critical [ 2 ] |
| Fix Version/s | 11.2 [ 28603 ] | |
| Fix Version/s | 11.0 [ 28320 ] |
| Fix Version/s | 11.3 [ 28565 ] | |
| Fix Version/s | 11.2 [ 28603 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | In Testing [ 10301 ] |
| Assignee | Thirunarayanan Balathandayuthapani [ thiru ] | Matthias Leich [ mleich ] |
| Link |
This issue is blocked by |
| Description |
The documentation at https://mariadb.com/kb/en/innodb-temporary-tablespaces/ says:
{quote}Unlike normal tablespaces, temporary tablespaces are deleted when you stop MariaDB. To shrink temporary tablespaces to their minimum sizes, restart the server.{quote} This means temporary tablespaces will keep growing until MariaDB is restarted. Having to restart MariaDB periodically is not optimal. It would be welcome if MariaDB shrinks temporary tablespaces on disk without restarting. |
The documentation at https://mariadb.com/kb/en/innodb-temporary-tablespaces/ says:
{quote}Unlike normal tablespaces, temporary tablespaces are deleted when you stop MariaDB. To shrink temporary tablespaces to their minimum sizes, restart the server.{quote} This means temporary tablespaces will keep growing until MariaDB is restarted. Having to restart MariaDB periodically is not optimal. It would be welcome if MariaDB shrinks temporary tablespaces on disk without restarting. To achieve this, we would introduce new syntax: {code:sql} SET GLOBAL innodb_truncate_temporary_tablespace_now=1; {code} |
| Link |
This issue is blocked by |
| Link |
This issue is blocked by |
| Assignee | Matthias Leich [ mleich ] | Thirunarayanan Balathandayuthapani [ thiru ] |
| Status | In Testing [ 10301 ] | Stalled [ 10000 ] |
| Link | This issue is part of TODO-4253 [ TODO-4253 ] |
| Link |
This issue relates to |
| Comment |
[ Fix for |
| Status | Stalled [ 10000 ] | In Testing [ 10301 ] |
| Assignee | Thirunarayanan Balathandayuthapani [ thiru ] | Matthias Leich [ mleich ] |
| Labels | Preview_11.3 |
| Assignee | Matthias Leich [ mleich ] | Thirunarayanan Balathandayuthapani [ thiru ] |
| Status | In Testing [ 10301 ] | Stalled [ 10000 ] |
| Link |
This issue is blocked by |
| Priority | Critical [ 2 ] | Blocker [ 1 ] |
| Link |
This issue blocks |
| Link |
This issue relates to |
| Link |
This issue is blocked by |
| issue.field.resolutiondate | 2023-10-27 08:34:40.0 | 2023-10-27 08:34:40.267 |
| Fix Version/s | 11.3.1 [ 29416 ] | |
| Fix Version/s | 11.3 [ 28565 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Link |
This issue causes |
| Remote Link | This issue links to "Page (MariaDB Confluence)" [ 36722 ] |
| Remote Link | This issue links to "Page (MariaDB Confluence)" [ 36722 ] |
| Link |
This issue causes |
| Zendesk Related Tickets | 169792 |