Per thread buffers: What are they really?

[dwellman]

Basically commenting on http://www.mysqlperformanceblog.com/2006/05/17/mysql-server- memory-usage

When computing maximum memory usage for a thread I have one source that says:

another that says:

yet another:

Regardless, all attest the importance of keeping per thread memory allocation reasonable; hoverver, there is no way to even generically estimate what it could/should be?

[xxclixxx]

I’m not sure how it does it, but a tool I found tells you at the top what the max possible usage would be with the settings you have:

[URL]http://rackerhacker.com/mysqltuner/[/URL]

[dwellman]

mysqltuner uses the first method. In full disclosure, that is the very reason why I sought a hard, fast answer. But there doesn’t seem to be one.