MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: failed queries of large tables with error mysqld got signal 11
Posted by: Rick James
Date: March 07, 2015 01:36AM

You have a lot of VARIABLES set to 20G. You have a lot of tmp tables being generated -- the SELECT, the ALTERs. Those can conspire to run well past your physical RAM size; this is a no-no.

How much RAM do you have?

Shrink those 20G settings to something less than 1G.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
failed queries of large tables with error mysqld got signal 11
Chris Paciorek
March 06, 2015 04:59PM
Re: failed queries of large tables with error mysqld got signal 11
Peter Brawley
March 06, 2015 06:16PM
Re: failed queries of large tables with error mysqld got signal 11
Chris Paciorek
March 06, 2015 06:23PM
Re: failed queries of large tables with error mysqld got signal 11
Peter Brawley
March 07, 2015 12:19AM
Re: failed queries of large tables with error mysqld got signal 11
Rick James
March 07, 2015 01:36AM


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.