We are running MySQL 3.23.37 (Official MySQL binary) on Redhat 7.0 kernel 2.4.3 using the built in replication. After some time (usually 2 hours or so) the master server starts to crash and replication stops dead. Its seems that all queries suddenly start to take 200 times longer to execute. Here is the relevant information from the binary log (the slave's replication thread stops at position 165791771):: # at 165791547 #010420 15:11:34 server id 1 Query thread_id=590431 exec_time=0 error_code=0 use pollit; SET TIMESTAMP=987804694; UPDATE pollit.sitelog set views=views+1 where pageID='104' and logdate='20010420'; # at 165791659 #010420 15:11:34 server id 1 Query thread_id=590431 exec_time=0 error_code=0 use pollit; SET TIMESTAMP=987804694; UPDATE pollit.sitelog set views=views+1 where pageID='325' and logdate='20010420'; # at 165791771 #010420 15:11:14 server id 1 Query thread_id=604315 exec_time=205 error_code=0 use adserver; SET TIMESTAMP=987804674; UPDATE LOW_PRIORITY bancamp_rel_set SET views=views+1 ,track=track+(1/weight) WHERE BID='518794397' AND setID='18114'; # at 165791923 #010420 15:11:14 server id 1 Query thread_id=604297 exec_time=205 error_code=0 use adserver; SET TIMESTAMP=987804674; UPDATE LOW_PRIORITY bancamp_rel_set SET views=views+1 ,track=track+(1/weight) WHERE BID='518819786' AND setID='32880'; # at 165792075 All the queries before pos 165791771 have exec_time <= 2 and all the queries after exec_time > 205. Thousands of queries pile up in the process list on the master. Stopping the slave using 'slave stop' immediately fixes the problem. Environment: The servers are (1) PIII 800 with 1024MB of RAM and an IBM deskstar 75GXP HD on a abit VP6 and 3com 3c980 nic running about 900 (small) queries per second. System: Linux dbserv1.localdomain 2.4.3 #1 Mon Apr 9 16:34:23 PDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 20000731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx 1 root root 14 Mar 2 05:45 /lib/libc.so.6 -> libc-2.1.92.so -rwxr-xr-x 1 root root 4776568 Aug 30 2000 /lib/libc-2.1.92.so -rw-r--r-- 1 root root 22607104 Aug 30 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Aug 30 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldfla gs=-all-sta tic --with-client-ldflags=-all-static --disable-shared show variables; +---------------------------------+----------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- --------+ | Variable_name | Value | +---------------------------------+----------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- --------+ | ansi_mode | OFF | | back_log | 50 | | basedir | /usr/local/mysql-3.23.37-pc-linux-gnu-i686/ | | 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 | 2 | | 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_innodb | NO | | have_isam | YES | | have_raid | NO | | have_ssl | NO | | init_file | | | interactive_timeout | 28800 | | join_buffer_size | 131072 | | key_buffer_size | 268431360 | | language | /usr/local/mysql-3.23.37-pc-linux-gnu-i686/share/mysql/english/ | | large_files_support | ON | | locked_in_memory | OFF | | log | OFF | | log_update | OFF | | log_bin | ON | | log_slave_updates | OFF | | long_query_time | 10 | | low_priority_updates | OFF | | lower_case_table_names | 0 | | max_allowed_packet | 1047552 | | max_binlog_cache_size | 4294967295 | | max_binlog_size | 1073741824 | | max_connections | 2500 | | max_connect_errors | 1000000 | | max_delayed_threads | 20 | | max_heap_table_size | 16777216 | | max_join_size | 4294967295 | | max_sort_length | 1024 | | max_user_connections | 0 | | max_tmp_tables | 32 | | max_write_lock_count | 4294967295 | | myisam_recover_options | OFF | | myisam_max_extra_sort_file_size | 256 | | myisam_max_sort_file_size | 2047 | | myisam_sort_buffer_size | 67108864 | | 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/mysqld.pid | | port | 3306 | | protocol_version | 10 | | record_buffer | 8384512 | | query_buffer_size | 0 | | safe_show_database | OFF | | server_id | 1 | | skip_locking | ON | | skip_networking | OFF | | skip_show_database | OFF | | slow_launch_time | 2 | | socket | /tmp/mysql.sock | | sort_buffer | 8388600 | | table_cache | 1600 | | table_type | MYISAM | | thread_cache_size | 16 | | thread_stack | 65536 | | transaction_isolation | READ-COMMITTED | | timezone | PDT | | tmp_table_size | 1048576 | | tmpdir | /tmp/ | | version | 3.23.37-log | | wait_timeout | 28800 | +---------------------------------+----------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- --------+ 79 rows in set (0.00 sec) --------------------------------------------------------------------- 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
