>Description:
When I do 'SHOW PROCESSLIST' on my server currently, the line for 'system user' is
as follows:
+--------+-------------+--------------+---------+---------+------------+-----------------------+------------------+
| Id | User | Host | db | Command | Time | State
| Info |
+--------+-------------+--------------+---------+---------+------------+-----------------------+------------------+
| 495801 | system user | none | NULL | Connect | 4294967211 | Reading
master update | NULL |
A few minutes before, and for a number of days, it had been displaying very low ( <
100s) numbers.
Subtracting the number from 2 ** 32 gives what looks like a sensible figure, so this
may be
a signed/unsigned bug.
>How-To-Repeat:
Hard to say; MySQL has been up for approaching 64 days - not sure if that's
significant. Doing SLAVE STOP; SLAVE START; has no effect.
>Fix:
Unknown (except to work around it as shown above).
>Submitter-Id: <submitter ID>
>Originator: root
>Organization:
NewsNow Publishing Limited
>MySQL support: none
>Synopsis: SHOW PROCESSLIST displays incorrect slave latency in MySQL 3.23
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.49 (Source distribution) (actually debian 'woody' stable
>distribution package)
>Environment:
Machine: Dell PowerEdge 2650 2xPIV Xeon 2.6 GHz w. PERC 3/Di RAID controller
OS: Debian GNU/Linux 'woody/stable' distribution, with custom-compiled kernel 2.4.24.
System: Linux craven 2.4.24dell-poweredge-2650 #1 SMP Tue Jan 6 13:09:17 GMT 2004 i686
unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Apr 24 2003 /lib/libc.so.6 -> libc-2.2.5.so
-rwxr-xr-x 1 root root 1153784 Apr 8 2003 /lib/libc-2.2.5.so
-rw-r--r-- 1 root root 2391002 Apr 8 2003 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 8 2003 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --exec-prefix=/usr
--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql
--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info
--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler
--with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile
--with-raid --enable-thread-safe-client --without-readline
--with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql
--without-bench --with-client-ldflags=-lstdc++ --with-extra-charsets=all
Output from 'mysqladmin extended-status':
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 1451 |
| Aborted_connects | 83 |
| Bytes_received | 2448140052 |
| Bytes_sent | 2623702023 |
| Com_admin_commands | 0 |
| Com_alter_table | 14 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 3 |
| Com_change_master | 1 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 1 |
| Com_create_function | 3 |
| Com_create_index | 0 |
| Com_create_table | 2 |
| Com_delete | 822956 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 2 |
| Com_grant | 2 |
| Com_insert | 444024318 |
| Com_insert_select | 21493 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 2 |
| Com_repair | 0 |
| Com_replace | 7483359 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 256096442 |
| Com_set_option | 6 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 28 |
| Com_show_fields | 2306 |
| Com_show_grants | 0 |
| Com_show_keys | 1 |
| Com_show_logs | 0 |
| Com_show_master_stat | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 9664 |
| Com_show_slave_stat | 50086 |
| Com_show_status | 3493 |
| Com_show_tables | 51398 |
| Com_show_variables | 15 |
| Com_slave_start | 9 |
| Com_slave_stop | 2 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 438517298 |
| Connections | 495919 |
| Created_tmp_disk_tables | 46128 |
| Created_tmp_tables | 21109117 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 469877458 |
| Handler_read_first | 18906 |
| Handler_read_key | 2525559616 |
| Handler_read_next | 4139975078 |
| Handler_read_prev | 128884706 |
| Handler_read_rnd | 702074073 |
| Handler_read_rnd_next | 1905626083 |
| Handler_update | 614894262 |
| Handler_write | 1093816057 |
| Key_blocks_used | 375048 |
| Key_read_requests | 3055797252 |
| Key_reads | 36320841 |
| Key_write_requests | 4000436705 |
| Key_writes | 2454498112 |
| Max_used_connections | 167 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 1011 |
| Open_files | 1100 |
| Open_streams | 0 |
| Opened_tables | 1181 |
| Questions | 1286277263 |
| Select_full_join | 20032929 |
| Select_full_range_join | 0 |
| Select_range | 730912 |
| Select_range_check | 0 |
| Select_scan | 970609 |
| Slave_running | ON |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 143150 |
| Sort_merge_passes | 0 |
| Sort_range | 9428966 |
| Sort_rows | 683500382 |
| Sort_scan | 21109125 |
| Table_locks_immediate | 1219862742 |
| Table_locks_waited | 2321875 |
| Threads_cached | 99 |
| Threads_created | 168 |
| Threads_connected | 69 |
| Threads_running | 1 |
| Uptime | 5518396 |
+--------------------------+------------+
Output from 'mysqladmin variables':
+---------------------------------+-----------------------------------------------------------------------------------------------------------------------------
| Variable_name | Value
+---------------------------------+-----------------------------------------------------------------------------------------------------------------------------
| back_log | 300
| basedir | /usr/local/mysql-standard-4.0.16-pc-linux-i686/
| bdb_cache_size | 8388600
| bdb_log_buffer_size | 0
| bdb_home |
| bdb_max_lock | 10000
| bdb_logdir |
| bdb_shared_data | OFF
| bdb_tmpdir |
| bdb_version | Sleepycat Software: Berkeley DB 3.2.9a: (February
14, 2002)
| binlog_cache_size | 32768
| character_set | latin1
| character_sets | latin1 big5 cp1251 cp1257 croat czech danish dec8
dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru k
| concurrent_insert | ON
| connect_timeout | 10
| datadir | /var/lib/mysql/
| delay_key_write | ON
| delayed_insert_limit | 100
| delayed_insert_timeout | 300
| delayed_queue_size | 1000
| flush | OFF
| flush_time | 0
| have_bdb | DISABLED
| have_gemini | NO
| have_innodb | DISABLED
| have_isam | YES
| have_raid | YES
| have_openssl | NO
| init_file |
| innodb_additional_mem_pool_size | 1048576
| innodb_buffer_pool_size | 8388608
| innodb_data_file_path |
| innodb_data_home_dir |
| innodb_file_io_threads | 4
| innodb_force_recovery | 0
| innodb_thread_concurrency | 8
| innodb_flush_log_at_trx_commit | OFF
| innodb_fast_shutdown | OFF
| 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
| interactive_timeout | 28800
| join_buffer_size | 131072
| key_buffer_size | 402649088
| language | /usr/share/mysql/english/
| large_files_support | ON
| locked_in_memory | OFF
| log | OFF
| log_update | OFF
| log_bin | ON
| log_slave_updates | OFF
| log_long_queries | ON
| long_query_time | 8
| low_priority_updates | OFF
| lower_case_table_names | 0
| max_allowed_packet | 16776192
| max_binlog_cache_size | 4294967295
| max_binlog_size | 104857600
| max_connections | 600
| max_connect_errors | 10000
| 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 | 100
| myisam_max_extra_sort_file_size | 256
| myisam_max_sort_file_size | 2047
| myisam_recover_options | 0
| myisam_sort_buffer_size | 134217728
| net_buffer_length | 16384
| net_read_timeout | 30
| net_retry_count | 10
| net_write_timeout | 60
| open_files_limit | 0
| pid_file | /var/run/mysqld/mysqld.pid
| port | 3306
| protocol_version | 10
| record_buffer | 1044480
| record_rnd_buffer | 1044480
| query_buffer_size | 1044480
| safe_show_database | OFF
| server_id | 4
| slave_net_timeout | 3600
| skip_locking | ON
| skip_networking | OFF
| skip_show_database | OFF
| slow_launch_time | 2
| socket | /var/run/mysqld/mysqld.sock
| sort_buffer | 1048568
| sql_mode | 0
| table_cache | 4000
| table_type | MYISAM
| thread_cache_size | 200
| thread_stack | 131072
| transaction_isolation | READ-COMMITTED
| timezone | GMT
| tmp_table_size | 4194304
| tmpdir | /tmp/
| version | 3.23.49-log
| wait_timeout | 3600
+---------------------------------+-----------------------------------------------------------------------------------------------------------------------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
