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
