WL#183: Limit temp table size

Limit temp table size

Title
Task ID	183
Queue
Version	N/A
Status
Priority	N/A
Copies to	Sergei

Created by	Mdcallag	13 Mar 2011	Done
Supervisor	N/A
Lead Architect
Architecture Review
Implementor
Code Review
QA
Documentation

High-Level Description

Limit per-query and global disk space used for temp tables. This is in the Google 
patch -- check if for ER_TMP_TABLE_MAX_FILE_SIZE_EXCEEDED and 
HA_ERR_TMP_TABLE_MAX_FILE_SIZE_EXCEEDED. But I have no idea if the code in the 
Google patch was a hack or solid.

The problem is that long-running queries with implicit temp tables frequently fill 
disks and many of us prefer not to put mysql temp space on a separate file system 
to protect against it.

Task Dependencies

Others waiting for Task 183

Task 183 is waiting for

Graph

High-Level Specification

Low-Level Design

File Attachments

	Name	Type	Size	By	Date

User Comments

Time Estimates

Name	Hours Worked	Last Updated
Total	0

	Hrs Worked	Current	Original
Total	0	0	0

Funding and Votes

Votes: 0:

Funding: 0 offers, total 0 Euro

Progress Reports

(Sergei - Mon, 04 Apr 2011, 11:12)
	Category updated. --- /tmp/wklog.183.old.25539 2011-04-04 11:12:55.000000000 +0000 +++ /tmp/wklog.183.new.25539 2011-04-04 11:12:55.000000000 +0000 @@ -1,2 +1,2 @@ -WorkLog-RawIdeaBin +Server-RawIdeaBin

(Sergei - Mon, 04 Apr 2011, 11:12)
	Version updated. --- /tmp/wklog.183.old.25539 2011-04-04 11:12:55.000000000 +0000 +++ /tmp/wklog.183.new.25539 2011-04-04 11:12:55.000000000 +0000 @@ -1,2 +1,2 @@ -WorkLog-4.0 +9.x

(Sergei - Tue, 22 Mar 2011, 14:19)
	Observers changed: Sergei

Report Generator:

Saved Reports:

WorkLog v4.0.0
  © 2010 Sergei Golubchik and Monty Program AB
  © 2004 Andrew Sweger <yDNA@perlocity.org> and Addnorya
  © 2003 Matt Wagner <matt@mysql.com> and MySQL AB