Add config options to control temp tables and filesorts
Bug #568184 reported by
Baron Schwartz
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Server moved to https://jira.percona.com/projects/PS |
Triaged
|
Wishlist
|
Unassigned | ||
| Percona patches |
Won't Fix
|
Undecided
|
Unassigned | ||
Bug Description
I'd like the ability to control whether queries are allowed to use temp tables and filesorts. The following could be very useful as global and session variables:
- Permit or deny on-disk temporary tables.
- Permit or deny on-disk filesorts.
- Set a max permitted temp table size on disk; if exceeded, abort and return an error.
- Ditto for filesort.
Right now a storm of bad queries can easily DOS a server, and this could prevent that.
| Changed in percona-patches: | |
| status: | New → Won't Fix |
| Changed in percona-server: | |
| importance: | Undecided → Wishlist |
| status: | New → Triaged |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #1 |
To post a comment you must log in.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/