Howdy all,
I've got a few questions about the table cache and the
tmp_table_size.
First off, a little background info. The server has
been running now for 193 hours. I've got 3 GB of RAM
on my box and I'm running RH linux. The MySQL
installation is version 4.0.13.
After taking a look at Show Status I noticed that the
Opened Tables value was 10188. Does this qualify as
big? It seems like it but I'm not sure. The table
cache is set to the default value (64). My max
connections is 100 and the largest set of joins I do
is 6. Furthermore the max number of concurrent
connections is only 9, at least for now. So should I
bump the table cache to 600 like the docs say? I
assume that linux can handle that no problem, but I
don't know linux well so perhaps that's not true.
Second, show status showed that
Created_tmp_disk_tables = 111223. Again, I'm assuming
that this is big and that I should adjust the
tmp_table_size server variable. The tmp_table_size is
set to the default (33554432). So, if I'm reading the
docs correctly, MySQL will create the temp table on
disk if the table will exceed ~33MB in size? That
seems awfully large. Does that suggest that there are
some queries that are doing full joins or something to
that effect? Is there any guideline on how large I
should make this value (something similar to the
guidelines on innodb_buffer_pool_size or
key_cache_size)?
Does anyone know if the new book High Performance
MySQL covers serving tuning in detail? There seems to
be a lot that I could do, but most of the
documentation that I've come across seems to be
lacking in explanation of the basic concepts.
Thanks for any advice,
Tripp
__________________________________
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
http://photos.yahoo.com/ph/print_splash
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
