NeDi Community

NeDi Software Specific => Database => Topic started by: big on October 02, 2017, 06:51:10 PM

Title: slow access
Post by: big on October 02, 2017, 06:51:10 PM
Hi Folks

Our nedi app seems to have developed an access issue. In many cases when I use the app
to get some device info it responds very quickly. However when I do an interface query the webserver takes forever, a very long time go get the results. I have to believe something is amiss.

I.E. IF name  like gi2/23 is horridly long.....

any ideas on where and how to troubleshoot? I looked at a couple of the system logs and really didn't see anything abnormal. that I could tell

it is a redhat OS 7.3

thanks in advance

Title: Re: slow access
Post by: rickli on October 03, 2017, 10:49:10 AM
Hi, so just listing interfaces takes long? Have a look at the NeDi server with top. Is it swapping? Is mysql eating all the CPU? What is overall IO?

The DB can grow over time, but mostly affects the events table. It makes sense to clean that one out from time to time. There's a maintenance script in the contrib folder, or you can go to System-Database and select "delete events < xy days" from the commands select box...