MySQL Forums
Forum List  »  Performance

Re: Too Big Created_tmp_disk_tables percent
Posted by: Peter Zaitsev
Date: August 30, 2006 03:53PM

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/

Options: ReplyQuote


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


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.