thread_stack must be removed to avoid problems for amd64

Bug #650936 reported by Pavel Zheltouhov
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mysql-5.1 (Debian)
New
Undecided
Unassigned
mysql-5.5 (Ubuntu)
Confirmed
Wishlist
Unassigned

Bug Description

Description of thread_stack variable :
The default of 192KB (256KB for 64-bit systems) is large enough for normal operation. If the thread stack size is too small, it limits the complexity of the SQL statements that the server can handle, the recursion depth of stored procedures, and other memory-consuming actions.
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_thread_stack

Thus, Debian / Ubuntu have exactly the set thread_stack = 192K on any platform, on amd64 it may have broken some of the complex triggers.

Soren Hansen (soren)
summary: - hread_stack must be removed to avoid problems for amd64
+ thread_stack must be removed to avoid problems for amd64
Thierry Carrez (ttx)
Changed in mysql-5.1 (Ubuntu):
importance: Undecided → Wishlist
status: New → Confirmed
Revision history for this message
Clint Byrum (clint-fewbar) wrote :

Moving to mysql-5.5 .. I think the appropriate thing to do is to remove this explicit setting and let the server's default take over.

affects: mysql-5.1 (Ubuntu) → mysql-5.5 (Ubuntu)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.