[ic] 4.9.9 slowdown in admin screens
racke at linuxia.de
Tue Nov 18 21:06:19 EST 2003
On Tue, 18 Nov 2003 10:38:41 -0800
Ed LaFrance <edl at newmediaems.com> wrote:
> At 11:28 AM 11/18/2003 -0500, you wrote:
> > > Which database are you using? Which operating system? Which
> > > Perl version?
> >Perl 5.6.1 no threads
> >Ic 4.9.9
> >Redhat 9.0
> >mysql Ver 12.22 Distrib 4.0.16
> >4.9.8, same setup (other than 4.9.9 upgrade) we had no slowness issues
> >in the backend.
> I would suggest turning on mysql logging and then seeing what kind of
> queries are being received from IC when you are trying to navigate the
> backend (if you see alot of 'select * from table' without filtering
> criteria, that is very likely to bog down the Admin when dealing with large
> tables). Also, run top and observe it when trying these operations. These
> would be my first steps to trying to identify the bottleneck.
The UI uses the mv_metadata and access table, which aren't SQL databases
in the standard foundation setup.
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
More information about the interchange-users