Zm 1.26.5 crash when i want to see system log

[samquad]

when i want to see the system log page on the zm server on ubuntu 14.04, zm always crash and it impossible to see anything else about zm server page web...
Can you helping me please
Samquad

[bbunge]

Possible that MySQL does not have enough connections?

edit /etc/mysql/my.cnf

look for max_connections =

and set the value higher. Suggestion use 1000

restsrt mysql and ZM or just restart the server.

[samquad]

I have updated Max_connections =100 to 1000.
I have the same problem when i see the system log zm crash.
Is it possible to purge the system log?

[bbunge]

You can turn logging off in Options/Logging. Also set log period to 1 day to try to purge corrupt entries. This is just a guess as I've never had log issues.

[samquad]

I changed the value of 1 day instead of 7 days.
The system log always shows:
total log 4981973
available 4981973
displaying 102 (with 1 day log data base limit)


my computer takes 30 seconds to display the 102 log.
there a few months, it was very fast (2 seconds)

[bbunge]

I finally figured out this problem! Actually one of the developers suggested it is a PHP error...

Your problem is likely a PHP error via Apache2.

First, set your connections back to 200 so MySQL does not use up a lot of memory. Restart MySQL

Edit /etc/php5/apache2/php.ini

find memory_limit = 128M and start by going to 256M. Restart Apache Mine is set to 512M as I have 16 cameras doing mocord and up to six people watching the montage at one time.

Use mysqltuner to check your MySQL settings.

bb