Bug #23443 user-defined variables can consume too much memory in the server
Submitted: 18 Oct 2006 21:03 Modified: 16 Jan 2007 5:41
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: General Severity:S1 (Critical)
Version:5.0.26, 4.1.22, 5.1.12, 4.0.27, 3.23.55 OS:Any (*)
Assigned to: Tomash Brechko CPU Architecture:Any
Tags: bfsm_2006_11_02, crash, DoS, Memory, OOM, user defined variables

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[18 Oct 2006 22:13] Shane Bester
typical out of memory crash provoked by this bug

Attachment: crash.txt (plain/text, text), 1.94 KiB.

[18 Oct 2006 22:14] Shane Bester
php app that will cause the above crash. simply 'group by' on 5 int's

Attachment: vars.php (application/octet-stream, text), 653 bytes.