Hi -
I have MySQL 3.23.42 running on OpenBSD 3.0, Pentium III, 256mb ram. MySQL was installed with the following commands: pkg_add mysql-client-3.23.42.tgz pkg_add mysql-server-3.23.42.tgz mysqladmin reports the following: ---------- mysqladmin Ver 8.21 Distrib 3.23.42, for unknown-openbsd3.0 on i386 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.42-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/mysql/mysql.sock Uptime: 18 hours 21 min 49 sec Threads: 2 Questions: 1800 Slow queries: 11 Opens: 15 Flush tables: 1 Open tables: 9 Queries per second avg: 0.027 ----------- I have a table that contains about 500,000 rows. I am connecting to it with Microsoft Access 97 via MyODBC 2.50.39. If I click the key field of the table (defined as an auto_increment integer) and then click the 'Sort A-Z' or 'Sort Z-A' buttons, the table is displayed in the desired sorted order, usually within 10-15 seconds. 5 other columns in the table (all varchar) have indexes. If I click 'Sort A-Z' or 'Sort Z-A' buttons, MS Access usually freezes up. If I tail /var/mysql/myhost.err, I see the following: warning: got signal 14 from thread 18 Any ideas / suggestions? Many thanks - Jim __________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.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
