search

Malshare / MalShare

http://www.malshare.com
22 stars 4 forks source link

Performance Tuning: 2020 June 30 #56

Closed silascutler closed 4 years ago

silascutler commented 4 years ago

Tracker Ticket

silascutler commented 4 years ago

Increased PHP memory to 1024M to fix:

[Tue Jun 30 17:43:01.808880 2020] [php7:error] [pid 12285] [client XXXXXXXXXXXXX] PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 215572512 bytes)
silascutler commented 4 years ago

Getting an error:

[Tue Jun 30 17:57:56.198688 2020] [php7:warn] [pid 1709] [client XXXXXXXXXXXXXXXx] PHP Warning:  mysqli::__construct(): (HY000/1040): Too many connections in XXXXXXXXXXXXXXX/server_includes.php on line 116
silascutler commented 4 years ago

Changed in /etc/mysql/mysql.conf.d/mysqld.cnf

#max_connections        = 100
...
max_connections        = 5000
silascutler commented 4 years ago

server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting

silascutler commented 4 years ago

Changed mpm_prefork.conf from 150 to 500

silascutler commented 4 years ago

Loading home page took +53 seconds. Still digging

silascutler commented 4 years ago

Loading search page took 23 seconds

silascutler commented 4 years ago

Pushed change: https://github.com/Malshare/Frontend/commit/2b9794ce72a68344cbf483786978f75821437490

silascutler commented 4 years ago

Pulling recent samples really needs to attention. Closing for now