I don't know if any of you people have ever had this trouble, but it's been a messy one here. Whenever a website of ours get lots of traffic, MySQL gets too slow to connect. Whenever it connects, the queries are fast. Since lots of our scripts relies on database connections, it has become a big problem to our website and we've been unable to answer to our costumers what is going on. a mysqladmin status shows the following: Uptime: 441237 Threads: 29 Questions: 23849146 Slow queries: 11390 Opens: 90355 Flush tables: 8 Open tables: 128 Queries per second avg: 54.051 We know that 54 queries per second should be a lot, but it's not. We've already had more traffic than that. A show processlist rarely shows more than 30 processes. The machine is a Linux SMP with 2 CPUs PIII 800MHz and 1G of RAM. What could possibly be wrong? Also, our setup for file-max is big enough to support lots of connections. We, of course, do lots of concurrent updates and selects in some (not all) tables. For the MySQL specialists out there, these are the variables returned by a show variables. Are there any values that could be changed so that the connection wouldn't be so slow? Are there people with the same problems out there? I'm waiting for a shout from the wild... :) Thanks. -- Leonardo Dias Catho Online WebDevelopper http://www.catho.com.br/
Variable_name Value ansi_mode OFF back_log 100 basedir /usr/local/mysql/ binlog_cache_size 32768 character_set latin1 character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 concurrent_insert ON connect_timeout 5 datadir /usr/local/mysql/data/ delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 0 have_bdb NO have_gemini NO have_innobase NO have_isam YES have_raid NO have_ssl NO init_file interactive_timeout 28800 join_buffer_size 1929216 key_buffer_size 134213632 language /usr/local/mysql/share/mysql/english/ large_files_support ON locked_in_memory OFF log ON log_update OFF log_bin OFF log_slave_updates OFF long_query_time 10 low_priority_updates OFF lower_case_table_names 0 max_allowed_packet 9048064 max_binlog_cache_size 4294967295 max_connections 500 max_connect_errors 10 max_delayed_threads 20 max_heap_table_size 16777216 max_join_size 4294967295 max_sort_length 1024 max_tmp_tables 32 max_write_lock_count 4294967295 myisam_recover_options OFF myisam_sort_buffer_size 8388608 net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 open_files_limit 0 pid_file /usr/local/mysql/data/mysql.pid port 3306 protocol_version 10 record_buffer 1531904 query_buffer_size 0 safe_show_database OFF server_id 0 skip_locking ON skip_networking OFF skip_show_database OFF slow_launch_time 2 socket /tmp/mysql.sock sort_buffer 4194296 table_cache 128 table_type MYISAM thread_cache_size 0 thread_stack 65536 timezone UTC tmp_table_size 9048568 tmpdir /tmp/ version 3.23.30-gamma-log wait_timeout 28800
--------------------------------------------------------------------- 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