[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:  Autosave                 |     Version:  3.7.1
 Severity:  normal                   |  Resolution:
 Keywords:                           |     Focuses:
-------------------------------------+------------------------------

Comment (by heydonovan):

 Replying to [comment:8 azaozz]:

 That's exactly what we were thinking. Instead of writing to the database,
 check for persistent caching, and write the
 `_edit_lock` modifications straight to memcached.

 Replying to [comment:9 nacin]:

 We do know that when a ton of authors are editing a bunch of different
 posts, the load average on the server almost quadruples. I've enabled POST
 logging, and about 95% of the requests within that time period are from
 "wp-refresh-post-lock". Looking at some of our logs, I can see it was
 requested more than 5000+ times, so that would account for a lot of posts
 being edited at once. I'll see if I can dig up some more data.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/26050#comment:10>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform