>>>>> "V" == V Yau <[EMAIL PROTECTED]> writes: V> Dear All V> I am using MySQL 3.22.8-beta on solaris 2.6 x86 with apache 1.3.3 and V> PHP 3.0.5 on a Pentium 350 mhz box. V> I have mainly 2 ways to connect to the mysqld. One way is V> via the C API living on a linux box somewhere else V> and another way is to connect it via Apache/PHP from a web V> page and generate the day into HTML on the fly. V> Either way, it has been working fine since October. I have decided V> to upgrade the Intel Pentium box to a dual 450 CPU with 512 GB V> of memory. V> The hardware upgrade was done earlier today and everything V> is brought back to normal. But now, I am seeing V> some problems with certain mysqld that was working before V> the hardware upgrade. I have using mysqld to store logs V> from various services that we offer to people. These logs V> are flat file that I parsed everyday. I have now about 84 days V> of log file and each day we generate about 1.5 GB of logs. V> Basically, if I do queries that involve data more than 5 days, I V> am seeing that mysqld decreases from an initial 30 to 40% CPU V> consumption (when the query was first submitted) to 0% CPU consumption V> (as if the query is done). This happens within 1.5 min V> from when the query is fire off. Of course, the browser or the V> C program is still running and no data is being returned V> and mysqld stays 0% CPU consumption.... V> Did I do anything wrong or do I need to recompile mysqld V> now that I have a dual pentium box (as opposed to 1 CPU V> before this morning's upgrade) ? Hi! You shouldn't have to do nothing to get the use of 2 CPU:s What does 'mysqladmin proc' say when this happens? Are you sure you don't have a full disk when this happens? On solaris you can also get some information what happens with: /usr/proc/bin/pstack 'pid of mysqld' Note that in MySQL 3.22.14 'mysqladmin proc' gives you much more information about what is happening! Regards, Monty ----------------------------------------------------------- Send a mail to [EMAIL PROTECTED] with unsubscribe mysql [EMAIL PROTECTED] in the body of the message to unsubscribe from this list.
