On Wed, 2 Aug 2000, Boaz Rymland wrote:
> Hello ppl,
>
> I'm looking for some impressions / feedback from people who run/tested
> the latest MySQL alpha versions (latest is 3.23.22 , from yesterday). At
> my work, we use a stable older version MySQL and we experience problem
> especially when it's databases are becoming large. Sometimes we get
> MySQL to use 97% cpu, and this is when it gets stuck and stops
No experience with alpha version, but I've used MySQL for a long time with
quite big tables (~400,000 entries) under very high loads and never saw a
problem and the CPU utilization only gets to the level you describe if
someone does something stupid (forget to set fields as INDEXED or using
Brute Force (TM) for lack of knowledge of SQL). Of course, this is not
neccasrily your case, but it might be worth checking exactly under what
circumstances does the 95% CPU util occurs.
---
Gilad Ben-Yossef <[EMAIL PROTECTED]>
Tel: +972-54756701
GP: Is Eris true? Fax: +972-15154756701
M2: Everything is true. HTTP: http://benyossef.com
GP: Even false things? GPG: 64C5 8B59 74D5 8FAE F097
M2: Even false things are true. 8DF8 4590 CE75 F444 6178
GP: How can that be? SMS: http://benyossef.com/how.html
M2: I don't know man,I didn't do it. IRC: Fidros
=================================================================
To unsubscribe, send mail to [EMAIL PROTECTED] with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail [EMAIL PROTECTED]
