[wp-trac] [WordPress Trac] #59319: Pages > All Pages Memory leak with high amount of pages big DB

[WordPress Trac]

#59319: Pages > All Pages Memory leak with high amount of pages big DB
---------------------------------------------+-----------------------------
 Reporter:  harpp333                         |      Owner:  (none)
     Type:  defect (bug)                     |     Status:  new
 Priority:  normal                           |  Milestone:  Awaiting Review
Component:  Administration                   |    Version:
 Severity:  critical                         |   Keywords:
  Focuses:  ui, administration, performance  |
---------------------------------------------+-----------------------------
 Env: About 60K pages+ database size is about 6GB 5GB or so in wp_posts

 1. Create a lot of pages 30 – 200K
 2. Click on Pages > All Pages in WP Admin
 Memory Leak Occurs

 1. Delete all pages besides 1
 2. Click on Pages > All Pages tab
 Memory Leak does not occur

 PHP Fatal error: Allowed memory size of 10485760000 bytes exhausted (tried
 to allocate 163840 bytes) that is 10GB and still crashing.

 Turned on all possible settings to the maximum

 I've tried disabling all plugins, changing the theme ect, optimizing
 cleaning database. nothing helps. Probably some sort of logic issue in how
 it fetches data to show in the all pages tab, maybe it's trying to grab
 Gigs of data at a time....

 Let you guys figure it out.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/59319>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform