Re: queries take too many time

2002-04-08 Thread Dicky Wahyu Purnomo
On Tue, 9 Apr 2002 13:17:59 +0800 Alvin Chen <[EMAIL PROTECTED]> wrote: > hi. I'm using MySQL 3.23.38, default settings for the mysql variables(my-large.cnf), > linux 2.2.14-5.0smp kernel - Red Hat 6.2, Records 140750, Size 101.0 MB, mem 1G, CPU >PIII 800. > But for some

queries take too many time

2002-04-08 Thread Alvin Chen
hi. I'm using MySQL 3.23.38, default settings for the mysql variables(my-large.cnf), linux 2.2.14-5.0smp kernel - Red Hat 6.2, Records 140750, Size 101.0 MB, mem 1G, CPU PIII 800. But for some reason queries take too many time. During the long query, I did a "mysqladmin proc"