What can we do to improve the speed…

What can we do to improve the speed and reliability of TracTrac Trac is the place where contributors create issues for bugs or feature requests much like GitHub.https://core.trac.wordpress.org/.? I am seeing two issues in particular: it is terribly slow to complete a request, and web service gets restarted often due to the box maxing out memory.

Possible ideas:

  • We could move from prefork back to threaded mpm to improve memory usage, but then mysqlMySQL MySQL is a relational database management system. A database is a structured collection of data where content, configuration and other options are stored. https://www.mysql.com/. connections become blocking. What’s a possible solution for this?
  • Move Trac from ApacheApache Apache is the most widely used web server software. Developed and maintained by Apache Software Foundation. Apache is an Open Source software available for free. to nginxNGINX NGINX is open source software for web serving, reverse proxying, caching, load balancing, media streaming, and more. It started out as a web server designed for maximum performance and stability. In addition to its HTTP server capabilities, NGINX can also function as a proxy server for email (IMAP, POP3, and SMTP) and a reverse proxy and load balancer for HTTP, TCP, and UDP servers. https://www.nginx.com/. or using nginx as a frontend proxy, which would include a short-lived cache for reports and for users who aren’t logged in. Or, could we configure the existing load balancers in front of it?

I’m most interested in nginx as a frontend proxy through the existing load balancers, as it seems like it’d be the easiest to set up and give us a decent benefit.