Re: Too Big Created_tmp_disk_tables percent
In your case problem is probably different - you have some BLOB/TEXT columns in queries which use temporary tables.
These can't use in memory tables as MEMORY storage engine does not support dynamic length rows.
If you can't get rid of these in your queries placing your temporary directory on ram drive is best you can do.
Also table_cache=32k
Do you really want to have table cache of 32768 open tables ? table_cache specifies number of entries not size.
Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog -
http://www.mysqlperformanceblog.com
MySQL Consulting
http://www.mysqlperformanceblog.com/mysql-consulting/
Subject
Views
Written By
Posted
15596
August 30, 2006 03:47PM
Re: Too Big Created_tmp_disk_tables percent
9387
August 30, 2006 03:53PM
6672
August 30, 2006 04:00PM
6789
January 03, 2007 09:33AM
6196
January 11, 2007 12:53PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.