Hi,
On Tue, Dec 16, 2003 at 10:23:05PM +1100, Chris Nolan wrote :
> How heavy is your usage of TEMPORARY TABLES? I don't use them much
> myself, but I'm sure that the others on the list will have something
> to say in that regard.
Here are the relevant numbers:
Created_tmp_disk_tables | 21911
Created_tmp_tables | 329778
This is from an uptime of about 40 hours which makes the
Created_tmp_disk_tables around 6% during this time.
> To get a better look at MySQL's usage of memory, you could try looking
> at the output of
> SHOW STATUS .
I don't want to look silly, but actually having the show status
output in front of me doesn't tell me much about the memory usage;
at least I can't find it ;)
There are things like Qcache_lowmem_prunes & Qcache_free_memory but
this are the only ones related to memory. Can you advise me where to
look at exactly?
- Markus
Ps: I'm using version 4.0.14
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
