The performance problem turned out to be some missing indexes that became
significant (because of data volumes) right at the same time.
OTOH, the lightly loaded machine just crashed again for the second time in
under 48 hours. I am in the process of building out a box to take over there
and run serial console on.
-----Original Message-----
From: Mark Hahn [mailto:hahn@coffee.psychology.mcmaster.ca]
Sent: Friday, June 02, 2000 3:41 PM
To: George Sexton
Subject: RE: 2.2.16pre7 SMP Crashes
> One other data point. The heavily used machine is running Sybase Adaptive
> Server Anywhere, and we are hitting MAJOR performance problems with
> 2.2.16pre7. Queries that used to finish instantly are now taking over 5
> minutes to complete with the dbsrv process sitting pegged at 100% CPU
Usage
> for one processor.
but why? have you done even elementary exploration like top/vmstat/etc?
-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in
the body of a message to majordomo@vger.rutgers.edu
Please read the FAQ at http://www.tux.org/lkml/
This archive was generated by hypermail 2b29 : Wed Jun 07 2000 - 21:00:16 EST