Re: MySQL still hanging on Win2K :-(

[Miguel Angel Solórzano <miguel@xxxxxxxxx>]

At 22:00 01/12/01 +0000, Chris Withers wrote:
Hi,

I have a Win2000 machine and I would like to do a test with
your problem. Please can you send me more specify details
(definition table and SQL statements) so as I can build a
C/C++ client program for try to repeat the issue ?.

Regards,
Miguel
> Hi again, Sinisa...
>
> Chris Withers wrote:
> >
> > Okay, table_cache increased from 64 to 256...
> >
> > > * check free disk space on all drives
>
> Well, it got up to indexing 10,000 documents this time but then hung 
> again. Now,
> I don't know if this is because increasing the table_cache made a 
> difference or
> because it was just lucky and got further this time.
>
> Looking at 'mysqladmin processlist', it has hung on 'Opening table' again, if
> that helps...
>
> I'm gonna try table_cache at 1024 to see if that is the cause. If it is, what
> could I be doign that needs this number to be so high?
>
> Of course, it also brings my following questions back into play:
>
> > > * starting / stopping MySQL as a service only
> >
> > Well, I run MySQL in a DOS box not as a service. Would running it as as 
> service
> > help? If so, why?
>
> Hope you can help...
>
> cheers,
>
> Chris
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread92842@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail 
> <mysql-unsubscribe-solorzano=intermol.com.br@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--
For technical support contracts, goto https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Miguel A. Solórzano <miguel@xxxxxxxxx>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
       <___/   www.mysql.com


---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92861@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php