Chris Withers writes:
> Hi,
>
> I've got a problem with 3.23.44-max-nt on Windows 2000 using Berkley tables.
>
> I'm running an import process which inserts a big set of rows ('bout 27
> million), as part of a document indexing process. Each new row uses the
> AUTO_INCREMENT_ID from the previous row. So, I have a loop which basically gets
> the last insert id, and then does an INSERT.
>
[skip]
> Has anyone experienced this or anything similar?
>
> I'm currently trying the same process on a Linux server for comparison...
>
> cheers,
>
> Chris
>
Hi!
There are several possibilities. You could be reaching some OS limits
or haning user / group permission problems.
Try :
* starting / stopping MySQL as a service only
* increase table_cache by a factor of 4
* check free disk space on all drives
--
Consider taking our support. Visit : https://order.mysql.com
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ 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
