Hello.
> | | open_files_limit | 50 You have a very low value for open_files_limit. Increase it to several thousands. See: http://dev.mysql.com/doc/mysql/en/not-enough-file-handles.html Please next time send you answers to the list. > On 7/20/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > >> What error do you obtain when your connection fails? Please, >> perform the following statements when the problem occurs again and >> provide its' output: > > > One of two scenarios: 1. The mysql client hangs indefinetly after I > enter the password. 2. I get the errors like this: > > $ mysql -u root -p cyrus Enter password: Reading table information > for completion of table and column names You can turn off this > feature to get a quicker startup with -A > > Didn't find any fields in table 'users' Welcome to the MySQL monitor. > Commands end with ; or \g. Your MySQL connection id is 6635 to server > version: 4.0.24 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> > describe users; ERROR 1105: File './cyrus/users.MYD' not found > (Errcode: 24) > >> SHOW STATUS; SHOW VARIABLES; SHOW PROCESSLIST; > > > Here you are (in attachment). > > > ------------------------- > > mysql> show status; show variables; show processlist; > +--------------------------+----------+ | Variable_name | > Value | +--------------------------+----------+ | Aborted_clients > | 2 | | Aborted_connects | 2 | | Bytes_received > | 1862853 | | Bytes_sent | 97051633 | | > Com_admin_commands | 0 | | Com_alter_table | 0 > | | Com_analyze | 0 | | Com_backup_table > | 0 | | Com_begin | 1184 | | Com_change_db > | 8 | | Com_change_master | 0 | | Com_check > | 0 | | Com_commit | 1195 | | Com_create_db > | 0 | | Com_create_function | 0 | | > Com_create_index | 0 | | Com_create_table | 3 > | | Com_delete | 0 | | Com_delete_multi > | 0 | | Com_drop_db | 0 | | > Com_drop_function | 0 | | Com_drop_index | 0 > | | Com_drop_table | 0 | | Com_flush > | 352 | | Com_grant | 0 | | Com_ha_close > | 0 | | Com_ha_open | 0 | | Com_ha_read > | 0 | | Com_insert | 802 | | > Com_insert_select | 0 | | Com_kill | 0 > | | Com_load | 0 | | Com_load_master_data > | 0 | | Com_load_master_table | 0 | | > Com_lock_tables | 4 | | Com_optimize | 0 > | | Com_purge | 0 | | Com_rename_table > | 0 | | Com_repair | 0 | | Com_replace > | 0 | | Com_replace_select | 0 | | Com_reset > | 0 | | Com_restore_table | 0 | | Com_revoke > | 0 | | Com_rollback | 11 | | Com_savepoint > | 0 | | Com_select | 10808 | | Com_set_option > | 506 | | Com_show_binlog_events | 0 | | > Com_show_binlogs | 0 | | Com_show_create | 18 > | | Com_show_databases | 18 | | Com_show_fields > | 227 | | Com_show_grants | 0 | | Com_show_keys > | 0 | | Com_show_logs | 0 | | > Com_show_master_status | 0 | | Com_show_new_master | 0 > | | Com_show_open_tables | 39 | | Com_show_processlist > | 93 | | Com_show_slave_hosts | 0 | | > Com_show_slave_status | 0 | | Com_show_status | > 452 | | Com_show_innodb_status | 0 | | Com_show_tables > | 41 | | Com_show_variables | 5 | | > Com_slave_start | 0 | | Com_slave_stop | 0 > | | Com_truncate | 0 | | Com_unlock_tables > | 3 | | Com_update | 790 | | > Com_update_multi | 0 | | Connections | > 6648 | | Created_tmp_disk_tables | 0 | | > Created_tmp_tables | 2 | | Created_tmp_files | 7 > | | Delayed_insert_threads | 0 | | Delayed_writes > | 0 | | Delayed_errors | 0 | | Flush_commands > | 350 | | Handler_commit | 12 | | Handler_delete > | 0 | | Handler_read_first | 1017 | | > Handler_read_key | 6161 | | Handler_read_next | > 2106 | | Handler_read_prev | 312632 | | Handler_read_rnd > | 75636 | | Handler_read_rnd_next | 5690823 | | > Handler_rollback | 138 | | Handler_update | > 14324 | | Handler_write | 991 | | Key_blocks_used > | 3773 | | Key_read_requests | 21648 | | Key_reads > | 3760 | | Key_write_requests | 1511 | | Key_writes > | 1511 | | Max_used_connections | 4 | | > Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 > | | Open_tables | 19 | | Open_files > | 34 | | Open_streams | 0 | | Opened_tables > | 2807 | | Questions | 22759 | | > Qcache_queries_in_cache | 0 | | Qcache_inserts | 0 > | | Qcache_hits | 0 | | Qcache_lowmem_prunes > | 0 | | Qcache_not_cached | 0 | | > Qcache_free_memory | 0 | | Qcache_free_blocks | 0 > | | Qcache_total_blocks | 0 | | Rpl_status > | NULL | | Select_full_join | 0 | | > Select_full_range_join | 0 | | Select_range | 44 > | | Select_range_check | 0 | | Select_scan > | 8712 | | Slave_open_temp_tables | 0 | | Slave_running > | OFF | | Slow_launch_threads | 0 | | Slow_queries > | 1 | | Sort_merge_passes | 0 | | Sort_range > | 0 | | Sort_rows | 75636 | | Sort_scan > | 1796 | | Table_locks_immediate | 12341 | | > Table_locks_waited | 0 | | Threads_cached | 0 > | | Threads_created | 6647 | | Threads_connected > | 2 | | Threads_running | 1 | | Uptime > | 64050 | +--------------------------+----------+ 133 rows in set > (0.00 sec) > > +---------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+ > | Variable_name | Value > | > +---------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+ > | back_log | 50 > | | basedir | /usr/local/ > | | bdb_cache_size | 8388600 > | | bdb_log_buffer_size | 32768 > | | bdb_home | /var/db/mysql/ > | | bdb_max_lock | 10000 > | | bdb_logdir | > | | bdb_shared_data | OFF > | | bdb_tmpdir | /var/tmp/ > | | bdb_version | Sleepycat Software: Berkeley DB > 3.2.9a: (March 5, 2005) | | > binlog_cache_size | 32768 > | | bulk_insert_buffer_size | 8388608 > | | character_set | koi8_ru > | | character_sets | koi8_ru dec8 dos german1 hp8 > latin1 latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia > hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | | > concurrent_insert | ON | > | connect_timeout | 5 > | | convert_character_set | > | | datadir | /var/db/mysql/ > | | default_week_format | 0 > | | delay_key_write | ON > | | delayed_insert_limit | 100 > | | delayed_insert_timeout | 300 > | | delayed_queue_size | 1000 > | | flush | OFF > | | flush_time | 0 > | | ft_boolean_syntax | + -><()~*:""&| > | | ft_min_word_len | 4 > | | ft_max_word_len | 254 > | | ft_max_word_len_for_sort | 20 > | | ft_stopword_file | (built-in) > | | have_bdb | YES > | | have_crypt | YES > | | have_innodb | YES > | | have_isam | YES > | | have_raid | NO > | | have_symlink | YES > | | have_openssl | NO > | | have_query_cache | YES > | | init_file | > | | innodb_additional_mem_pool_size | 1048576 > | | innodb_autoextend_increment | 8 > | | innodb_buffer_pool_size | 8388608 > | | innodb_data_file_path | ibdata1:10M:autoextend > | | innodb_data_home_dir | > | | innodb_file_io_threads | 4 > | | innodb_force_recovery | 0 > | | innodb_thread_concurrency | 8 > | | innodb_flush_log_at_trx_commit | 1 > | | innodb_fast_shutdown | ON > | | innodb_flush_method | > | | innodb_lock_wait_timeout | 50 > | | innodb_log_arch_dir | ./ > | | innodb_log_archive | OFF > | | innodb_log_buffer_size | 1048576 > | | innodb_log_file_size | 5242880 > | | innodb_log_files_in_group | 2 > | | innodb_log_group_home_dir | ./ > | | innodb_mirrored_log_groups | 1 > | | innodb_max_dirty_pages_pct | 90 > | | innodb_max_purge_lag | 0 > | | innodb_table_locks | ON > | | interactive_timeout | 28800 > | | join_buffer_size | 131072 > | | key_buffer_size | 8388600 > | | language | /usr/local/share/mysql/english/ > | | large_files_support | ON > | | license | GPL > | | local_infile | ON > | | log | OFF > | | log_update | OFF > | | log_bin | OFF > | | log_slave_updates | OFF > | | log_slow_queries | OFF > | | log_warnings | 1 > | | long_query_time | 10 > | | low_priority_updates | OFF > | | lower_case_file_system | OFF > | | lower_case_table_names | 0 > | | max_allowed_packet | 1048576 > | | max_binlog_cache_size | 4294967295 > | | max_binlog_size | 1073741824 > | | max_connections | 40 > | | max_connect_errors | 10 > | | max_delayed_threads | 20 > | | max_insert_delayed_threads | 20 > | | max_heap_table_size | 16777216 > | | max_join_size | 4294967295 > | | max_relay_log_size | 0 > | | max_seeks_for_key | 4294967295 > | | max_sort_length | 1024 > | | max_user_connections | 0 > | | max_tmp_tables | 32 > | | max_write_lock_count | 4294967295 > | | myisam_max_extra_sort_file_size | 268435456 > | | myisam_max_sort_file_size | 2147483647 > | | myisam_repair_threads | 1 > | | myisam_recover_options | OFF > | | myisam_sort_buffer_size | 8388608 > | | net_buffer_length | 16384 > | | net_read_timeout | 30 > | | net_retry_count | 1000000 > | | net_write_timeout | 60 > | | new | OFF > | | open_files_limit | 50 > | | pid_file | > /var/db/mysql/virgin.v.gz.ru.pid | | > log_error | | | > port | 3306 > | | protocol_version | 10 > | | query_alloc_block_size | 8192 > | | query_cache_limit | 1048576 > | | query_cache_size | 0 > | | query_cache_type | ON > | | query_cache_wlock_invalidate | OFF > | | query_prealloc_size | 8192 > | | range_alloc_block_size | 2048 > | | read_buffer_size | 131072 > | | read_only | OFF > | | read_rnd_buffer_size | 262144 > | | rpl_recovery_rank | 0 > | | server_id | 0 > | | slave_net_timeout | 3600 > | | skip_external_locking | ON > | | skip_networking | OFF > | | skip_show_database | OFF > | | slow_launch_time | 2 > | | socket | /tmp/mysql.sock > | | sort_buffer_size | 2097144 > | | sql_mode | 0 > | | table_cache | 64 > | | table_type | MYISAM > | | thread_cache_size | 0 > | | thread_stack | 196608 > | | tx_isolation | REPEATABLE-READ > | | timezone | MSD > | | tmp_table_size | 33554432 > | | tmpdir | /var/tmp/ > | | transaction_alloc_block_size | 8192 > | | transaction_prealloc_size | 4096 > | | version | 4.0.24 > | | version_comment | FreeBSD port: > mysql-server-4.0.24_1 | | > version_compile_os | portbld-freebsd4.11 > | | wait_timeout | 28800 > | > +---------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+ > 142 rows in set (0.01 sec) > > +------+--------+----------------+--------+---------+------+-------+------------------+ > | Id | User | Host | db | Command | Time | State | > Info | > +------+--------+----------------+--------+---------+------+-------+------------------+ > | 2 | ipacct | localhost:2638 | ipacct | Sleep | 2 | | > NULL | | 6570 | root | localhost | NULL | Query | 0 > | NULL | show processlist | > +------+--------+----------------+--------+---------+------+-------+------------------+ > 2 rows in set (0.00 sec) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
