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 <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
