Dear All, I use Mysql for half year. At this moment, I encounter a big problem that I can not query any data from my server. The following is my configuration. Platform: Solaris 2.7 on Sun Ultra2 Mysql version: 3.22.29 Table Name: mailhead; Record count: 2003478 Status: mysql> select count(*) from mailhead; +----------+ | count(*) | +----------+ | 2003478 | +----------+ 1 row in set (2.24 sec) mysql> select * from mailhead where serial_no=900000; ERROR 1030: Got error 134 from table handler mysql> show variables; +----------------------------+---------------------------------+ | Variable_name | Value | +----------------------------+---------------------------------+ | back_log | 5 | | connect_timeout | 5 | | basedir | /var/mysql/ | | datadir | /usr/local/mysql/var/ | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | join_buffer | 33550336 | | flush_time | 0 | | key_buffer | 8388600 | | language | /var/mysql/share/mysql/english/ | | log | OFF | | log_update | OFF | | long_query_time | 10 | | low_priority_updates | OFF | | max_allowed_packet | 1048576 | | max_connections | 100 | | max_connect_errors | 10 | | max_delayed_insert_threads | 20 | | max_join_size | 4294967295 | | max_sort_length | 1024 | | max_write_lock_count | 4294967295 | | net_buffer_length | 16384 | | pid_file | /usr/local/mysql/var/mysqld.pid | | port | 3306 | | protocol_version | 10 | | record_buffer | 131072 | | skip_locking | OFF | | skip_networking | OFF | | socket | /tmp/mysql.sock | | sort_buffer | 2097144 | | table_cache | 64 | | thread_stack | 65536 | | tmp_table_size | 8191992 | | tmpdir | /var/tmp/ | | version | 3.22.29 | | wait_timeout | 28800 | +----------------------------+---------------------------------+ 37 rows in set (0.00 sec) I can insert record into mailhead, but can not retrieve data from it. Help ! Help ! Help ! Thanks,
--------------------------------------------------------------------- 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
