Hi all. I'm having trouble this a process that just keeps running. To view this process I'm using the msql SHOW PROCESSLIST command. Here's the message I'm seeing:
38 | bb50 | localhost | bb50 | Query | 197 | Copying to tmp table | select a.pk1,a.sos_id_pk2, a.name, count(q.pk1) from assessment a left jo | This process starts up and locks the assessment table. Pretty soon other processes that need to access that table start to lock. Here's my setting: mysql> show variables; +----------------------------+---------------------------------------------------+ | Variable_name | Value | +----------------------------+---------------------------------------------------+ | back_log | 5 | | connect_timeout | 5 | | basedir | /usr2/local/blackboard/mysql/ | | datadir | /usr2/local/blackboard/mysql/data/ | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | join_buffer | 10481664 | | flush_time | 0 | | key_buffer | 65007616 | | language | /usr2/local/blackboard/mysql/share/mysql/english/ | | log | OFF | | log_update | OFF | | long_query_time | 10 | | low_priority_updates | OFF | | max_allowed_packet | 1047552 | | max_connections | 500 | | 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 | /usr2/local/blackboard/mysql/data/bb5mysql.pid | | port | 3307 | | protocol_version | 10 | | record_buffer | 520192 | | skip_locking | ON | | skip_networking | OFF | | socket | /tmp/bb50_mysql.sock | | sort_buffer | 15728632 | | table_cache | 65535 | | thread_stack | 131072 | | tmp_table_size | 20971512 | | tmpdir | /tmp/ | | version | 3.22.32 | | wait_timeout | 31536000 | +----------------------------+---------------------------------------------------+ 37 rows in set (0.00 sec) Can somone tell me what the settings should be to fix this problem? I've ran this process for about 400 sec and it never failed. I have lots of ram 3GB and lots of HD space. Let me know if you need my config file. Thank You, Justin A. Stanczak Web Manager Shake Learning Resource Center Vincennes University (812)888-5813 --------------------------------------------------------------------- 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