List:Cluster« Previous MessageNext Message »
From:Magnus Blåudd Date:October 9 2013 11:24am
Subject:Re: Data retrieval causes query times to spike
View as plain text  
On 10/08/2013 12:56 AM, Raymond Peachey wrote:
> We are running into an issue when a job that runs every few minutes is
> grabbing changed data (determined by triggers) and dumping it out to disk.
> During this process, we often hit a 5 second timeout that we have
> configured for MySQL Cluster, causing a MYSQL HAS GONE AWAY error.


Seems natural that you get "MySQL Server has gone away" in case a query 
which the client send to MySQL Server takes longer to execute than the 
timeout you have set. The MySQL Server simply disconnects the client.

How long does your query normally run when you execute it from the 
mysql> prompt?

/ Magnus
Thread
Data retrieval causes query times to spikeRaymond Peachey7 Oct
  • Re: Data retrieval causes query times to spikeMagnus Blåudd9 Oct
    • Re: Data retrieval causes query times to spikeRaymond Peachey9 Oct
      • Re: Data retrieval causes query times to spikeWagner Bianchi9 Oct
        • Re: Data retrieval causes query times to spikeRaymond Peachey10 Oct
          • Re: Data retrieval causes query times to spikeHendrik Woltersdorf10 Oct
            • Re: Data retrieval causes query times to spikeRaymond Peachey10 Oct
              • Re: Data retrieval causes query times to spikeJohan Andersson10 Oct
                • Re: Data retrieval causes query times to spikeRaymond Peachey10 Oct
                  • Re: Data retrieval causes query times to spikeJohan Andersson10 Oct
                    • Re: Data retrieval causes query times to spikeRaymond Peachey14 Oct
                      • Re: Data retrieval causes query times to spikeHendrik Woltersdorf15 Oct
                        • Re: Data retrieval causes query times to spikeRaymond Peachey15 Oct
                          • Re: Data retrieval causes query times to spikeJohan Andersson15 Oct
                            • Re: Data retrieval causes query times to spikeRaymond Peachey16 Oct
                              • Re: Data retrieval causes query times to spikeRaymond Peachey21 Oct