Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

memory usage and the thread cache [message #3039] Sat, 03 May 2008 10:12 jrabbit Messages: 13 Registered: December 2007 Junior Member I'm trying to get a better understanding of thread memory usage. Assuming the following buffers were allocated during a query, and the thread is to be returned to the thread cache rather than closed at the end of the query. If they were used, are the following buffers kept allocated, or are they released before the thread is put in the cache? 1. The thread stack (I think this stays allocated) 2. The connection buffer (This may be released or shrunk?) 3. The result buffer (This may be released or shrunk?) 4. The read_buffer 5. The read_rnd_buffer 6. The sort_buffer 7. The myiasm_sort_buffer 8. The bulk_insert_buffer 9. The binlog cache buffer Thanks for any assistance. Report message to a moderator

	memory usage and the thread cache By: jrabbit on Sat, 03 May 2008 10:12
	Re: memory usage and the thread cache By: debug on Wed, 14 May 2008 05:26

Previous Topic:	MERGE STORAGE ENGINE Vs UNION ALL
Next Topic:	MySQL take too much time to start

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]