[wp-trac] [WordPress Trac] #32898: Polluted database and Menu Crash

[WordPress Trac]

#32898: Polluted database and Menu Crash
--------------------------+-----------------------------
 Reporter:  davidfhannes  |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Database      |    Version:  4.2.2
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 I have a Woo Commerce website with very large menu structure for the nav
 bar. Recently when I tried to add to the menu structure under
 appearances...Menu and press update the page...the page processes and then
 crashes and gives me a 404 page cannot be found error even though it is
 the same page.

 My server provider informs me that the  postmeta_wp table has 2 million
 rows.

 I went to Woo Commerce…System Status…Tools and cleared the following:

 WC Transients
 Expired Transients
 Customer Sessions

 Still not resolved.

 I have run 2 optimization plugins to no avail to clean out the 2 million
 rows.

 I have added this line to php.ini, which resolved another menu problem,
 but it does not resolve this: max_input_vars = 3000

 Question: Are there things we can do to the settings under PHP
 Configuration editor on the server or php.ini to resolve this?

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