Members   Search   Help    Register    Login   Home

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

What would cause all tmp tables to be created on disk instead of ram? [message #1207] Fri, 04 May 2007 23:59  JGilbert Messages: 31 Registered: May 2007 Location: Chicago, IL Member I've been running the db for a few hours after my last attempts at solving this, and it is still creating all the tmp tables on disk. Is this something innodb does because of how it handles joins or something? It has already created a few thousand tmp tables on disk. What would be some causes of this? I know what causes MySQL to create tmp tables, but I'm not sure why 100% of them are written to the hard drive instead of to the ram. I think I'm doing really well at optimizing things as best I can but this specific stat troubles me because it makes me think that the unused ram (almost 6 out of the 8 gigs available) is being wasted when it could easily satisfy the needs of those tmp table creation requests. Any help would be warmly welcomed and greatly appreciated. Thanks in advance for any advice. Big fan of this blog. Report message to a moderator

	What would cause all tmp tables to be created on disk instead of ram? By: JGilbert on Fri, 04 May 2007 23:59
	Re: What would cause all tmp tables to be created on disk instead of ram? By: JGilbert on Sat, 05 May 2007 00:04
	Re: What would cause all tmp tables to be created on disk instead of ram? By: sterin on Sat, 05 May 2007 06:13
	Re: What would cause all tmp tables to be created on disk instead of ram? By: JGilbert on Sat, 05 May 2007 10:02
	Re: What would cause all tmp tables to be created on disk instead of ram? By: sterin on Sat, 05 May 2007 19:45
	Re: What would cause all tmp tables to be created on disk instead of ram? By: JGilbert on Sun, 06 May 2007 23:33
	Re: What would cause all tmp tables to be created on disk instead of ram? By: kmike on Sun, 06 May 2007 05:32
	Re: What would cause all tmp tables to be created on disk instead of ram? By: JGilbert on Sun, 06 May 2007 23:39
	Re: What would cause all tmp tables to be created on disk instead of ram? By: kmike on Mon, 07 May 2007 00:42
	Re: What would cause all tmp tables to be created on disk instead of ram? By: JGilbert on Mon, 07 May 2007 11:03
	Re: What would cause all tmp tables to be created on disk instead of ram? By: JGilbert on Tue, 08 May 2007 15:49
	Re: What would cause all tmp tables to be created on disk instead of ram? By: JGilbert on Fri, 08 June 2007 17:08
	Re: What would cause all tmp tables to be created on disk instead of ram? By: JGilbert on Fri, 08 June 2007 17:09
	Re: What would cause all tmp tables to be created on disk instead of ram? By: sterin on Sat, 09 June 2007 04:53
	Re: What would cause all tmp tables to be created on disk instead of ram? By: JGilbert on Sun, 10 June 2007 01:07
	Re: What would cause all tmp tables to be created on disk instead of ram? By: sterin on Mon, 11 June 2007 18:07
	Re: What would cause all tmp tables to be created on disk instead of ram? By: JGilbert on Mon, 18 June 2007 20:09
	Re: What would cause all tmp tables to be created on disk instead of ram? By: JGilbert on Mon, 18 June 2007 20:10
	Re: What would cause all tmp tables to be created on disk instead of ram? By: JGilbert on Tue, 11 September 2007 13:31

Previous Topic:	CPU 100%
Next Topic:	Out of memory error and duplicate entry error (in error log)

Goto Forum:

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