Jump to content

Fuwa pls - SQL Error, 504 Bad Gateway


Fuwa pls  

25 members have voted

  1. 1. Do you encounter similar SQL / Gateway error issues?


This poll is closed to new votes


Recommended Posts

^ Random MySQL server restarts ought to do the trick.  :holo:

 

The issues were resulting from automatic table flushing on the MySQL side and Piwik (our analytics software) running its archiving task once per hour (pretty much aggregating what happened in the last hour, which can be quite a lot).

 

Still, should this happen anymore, especially the 504 Gateway Timeouts (which were caused by the server being busy from the archiving task) we're going to need to consider upgrading server hardware, which would be nasty - or I'd have to look into more efficient alternatives.

Link to comment
Share on other sites

^ Random MySQL server restarts ought to do the trick.  :holo:

 

The issues were resulting from automatic table flushing on the MySQL side and Piwik (our analytics software) running its archiving task once per hour (pretty much aggregating what happened in the last hour, which can be quite a lot).

 

Still, should this happen anymore, especially the 504 Gateway Timeouts (which were caused by the server being busy from the archiving task) we're going to need to consider upgrading server hardware, which would be nasty - or I'd have to look into more efficient alternatives.

I don't understand why this archiving and normal operations can't happen simultaneously.  The server isn't running on a single-core processor, right?  It should be able to handle multiple tasks at once, as long as the archiving is set to run in the background (low priority).  Can't archiving be skipped or delayed during high-traffic periods?

Link to comment
Share on other sites

The archiving task was also severely limited by some factors (the database user not being able to import files directly, for example) and I made sure to fix those first, and now I can look into it further. Shouldn't be too much of an issue anymore, though.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...