[wp-trac] [WordPress Trac] #26050: Continual Admin Page POST (HeartBeats?) Can Cause SQL Connection Issues

[WordPress Trac]

#26050: Continual Admin Page POST (HeartBeats?) Can Cause SQL Connection Issues
-------------------------------------+------------------------------
 Reporter:  optimized-marketing.com  |       Owner:
     Type:  defect (bug)             |      Status:  new
 Priority:  normal                   |   Milestone:  Awaiting Review
Component:  General                  |     Version:  3.7.1
 Severity:  normal                   |  Resolution:
 Keywords:                           |
-------------------------------------+------------------------------

Comment (by azaozz):

 Not sure I completely understand the problem.

 > If multiple admin pages are open for long periods of time(ex. over
 night) the SQL Connections associated with the POSTs will begin to
 progressively have longer sleep times.

 What exactly causes the SQL Connections to have "sleep times"? Would they
 have "sleep time" when you have visitors to your site? I know some hosting
 companies have limits for "SQL connections per hour" or similar, probably
 this is the problem.

 Heartbeat behaves very similarly to autosave. The differences are that it
 runs on all admin pages vs. only Add/Edit Post, and connects less
 frequently when the user is not active. Have you had problems with your
 host when leaving the Edit Post page loaded overnight?

 > Is this the expected experience/results? Should there be a sleep setting
 on these POSTs to stop after a given time frame?

 Unfortunately it is impossible to guess what the user's intentions are.
 When a web page is left loaded in the browser, the most common reason is
 that the user would come back to it and continue to use it.

 Most computers would "fall sleep" after a period of inactivity, usually
 10-30min. Been testing adding the same functionality to heartbeat, however
 that would affect the other functios. For example post locks will be
 released too.

 Related: #25073.

--
Ticket URL: <http://core.trac.wordpress.org/ticket/26050#comment:1>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software