I'm using mysql Ver 11.16 Distrib 3.23.49, for slackware-linux-gnu (i386).
Everything was just fine for months, but yeasterday I started to use one of the tables by connecting to it with MS Access 2000. The table has ~100000 records. And the strange thing: it was working for few hours (queries, updates, etc.. everything from Access through myODBC 2.50), and then suddenly it frozen! So I checked the server - every table on the server worked just fine. "Describe problematic_table" also ok. But "select * from problematic_table limit 10" : freeze. "Select * from another_table" : OK. I have no idea why only one table stoped working. I shutdowned the server and brought it up and it is ok now. But what was the reason for freezing the table ? -- ./ premax ./ [EMAIL PROTECTED] --------------------------------------------------------------------- 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
