Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.12.3 available

The official documentation can be found on https://wiki.ocsinventory-ng.org. Read it before asking your question.

OCS Inventory Ridiculously Slow

Hello,

I'm basically trying to take over the administration of this product without any previous documentation of the setup, so bare with me.

Recently, OCS has become so slow to the point it's unusable. We're running Ver. 2.0.4 on a 2003 R2 server. When attempting to hit the web console on http://ourserver/ocsreports/index.php it spins for roughly three minutes before loading the login screen. We can login, but there is no point in running a report as it will time out. Sometimes it just times out. Same is the case with http://localhost/ocsreports/ on the server itself.

We have never had this problem until recently, so I initially restarted the apache service and eventually rebooted the box as well without luck. I was looking through the apache error logs and came across thousands of the following instance:

Issuing rollback() due to DESTROY without explicit disconnect() of DBD::mysql::db handle database=ocsweb;host=localhost;port=3306 at E:/xampp/perl/site/lib/Apache/Ocsinventory.pm line 64

Can anybody shed any light into this? I'm not positive the two are related, but it seems kind of likely they are connected. Any help would be extremely helpful as the previous admin left no documentation and I'm trying to pick up the pieces here.
in OCS Inventory NG server for Windows by (120 points)

1 Answer

0 votes
Hi,

Have you errors in mysql.log file ? Have you tuned mysql?

Regards

Frank
by (90.2k points)
 
Powered by Question2Answer
...