Members   Search   Help    Register    Login   Home

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

InnoDB and Temporary Tables [message #617] Sun, 21 January 2007 17:19 aronrosenberg Messages: 16 Registered: September 2006 Junior Member Our application uses only InnoDB tables and thus our server is heavily optimized towards innodb memory usage and the like. The only MyISAM tables are the mysql ones. Should we try and force temporary tables to be of InnoDB? Would we do this by changing the default table type in my.cnf to InnoDB? Is it better to have temp tables as Innodb instead of myisam? Report message to a moderator

	InnoDB and Temporary Tables By: aronrosenberg on Sun, 21 January 2007 17:19
	Re: InnoDB and Temporary Tables By: Peter on Sun, 21 January 2007 17:24
	Re: InnoDB and Temporary Tables By: aronrosenberg on Sun, 21 January 2007 17:26
	Re: InnoDB and Temporary Tables By: Peter on Sun, 21 January 2007 17:41
	Re: InnoDB and Temporary Tables By: aronrosenberg on Sun, 21 January 2007 17:43
	Re: InnoDB and Temporary Tables By: Peter on Sun, 21 January 2007 17:52
	Re: InnoDB and Temporary Tables By: aronrosenberg on Sun, 21 January 2007 17:55
	Re: InnoDB and Temporary Tables By: Peter on Sun, 21 January 2007 17:58

Previous Topic:	Need some help with big tables
Next Topic:	NDB and Character Indexes

Goto Forum:

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