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.
Now, the process doing this seems to hang every so often. It doens't happen
every time and it doesn't happen at the same point each time; sometimes it's
after indexing 900 documents, sometimes after 6,000.
Once it's hung, I can still get MySQL to do things, here's the output of:
mysqladmin processlist
+----+---------+-----------+---------+---------+------+---------------+--------
| Id | User | Host | db | Command | Time | State | Info
+----+---------+-----------+---------+---------+------+---------------+--------
| 1 | indexer | localhost | indexer | Query | 3134 | Opening table | INSERT
| 3 | ODBC | localhost | | Query | 0 | | show pr
+----+---------+-----------+---------+---------+------+---------------+--------
mysqladmin showstatus
Uptime: 4943 Threads: 2 Questions: 1140255 Slow queries: 0 Opens: 15
Flush tables: 1 Open tables: 0 Queries per second avg: 230.681
I can connect to this server fine with the client software. I can change the
database I'm using and I can do 'show tables', but as soon as I try and select
anything from any table in _any_ database, the client hangs in a similar way to
the indexing process and the onyl way I can get back is to kill the mysql.exe
process in the task manager.
Has anyone experienced this or anything similar?
I'm currently trying the same process on a Linux server for comparison...
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
