>Description:
I'm using Mysql 4.0.1 with query caching:
set-variable = query_cache_limit=10M
set-variable = query_cache_size=10M
set-variable = query_cache_startup_type=1
The Command:
mysqldump -q -K -t --tab='.' \
--fields-optionally-enclosed-by='"' \
--fields-terminated-by=',' sched oweek
The first execution of the command writes the expected
data to oweek.txt.
Any subsequent executions do not. This is because of query caching.
I can run --> mysql -e "reset query cache" <-- which will enable
the next call to mysqldump to write data.
I believe that mysqldump should write data whether query caching
is enabled/disabled or not-flushed/flushed.
>How-To-Repeat:
Execute a mysqldump command more than once.
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Nick Pasich
>Organization:
>MySQL support: email support
>Synopsis: Problem with mysqldump when using query caching
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.1-alpha (Source distribution)
>Server: /usr/local/MYSQL/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for
>pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.1-alpha-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /usr/local/MYSQL/mysql.sock
Uptime: 13 hours 49 min 48 sec
Threads: 2 Questions: 1653 Slow queries: 2 Opens: 135 Flush tables: 15 Open
tables: 3 Queries per second avg: 0.033
>Environment:
System: Linux NICK 2.4.18-ac3 #1 Mon Mar 4 12:38:33 PST 2002 i586 unknown
Architecture: i586
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from
/usr/local/GCC/gcc-2.95.3/lib/gcc-lib/i586-pc-linux-gnulibc1/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-O3 -march=i586' CXX='gcc' CXXFLAGS='-O3
-march=i586 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Feb 24 20:49 /lib/libc.so.4 -> libc.so.4.7.6
-rwxr-xr-x 1 root root 623620 Feb 26 1996 /lib/libc.so.4.5.26
-rwxr-xr-x 1 bin bin 634880 Aug 13 1996 /lib/libc.so.4.7.5
-rwxr-xr-x 1 root wheel 634880 Apr 29 1996 /lib/libc.so.4.7.6
lrwxrwxrwx 1 root root 14 Feb 24 20:49 /lib/libc.so.5 ->
libc.so.5.4.46
-rwxr-xr-x 1 bin bin 562683 Aug 12 1996 /lib/libc.so.5.0.9
-rwxr-xr-x 1 bin bin 558615 Apr 12 1997 /lib/libc.so.5.2.18
-rwxr-xr-x 1 bin bin 1816182 Dec 6 1996 /lib/libc.so.5.4.17
-rwxr-xr-x 1 bin bin 1760718 Aug 13 1996 /lib/libc.so.5.4.2
-rwxr-xr-x 1 bin bin 1861963 Apr 15 1997 /lib/libc.so.5.4.23
-rwxr-xr-x 1 bin bin 1868689 May 30 1997 /lib/libc.so.5.4.33
-rwxr-xr-x 1 bin bin 1760174 Aug 18 1996 /lib/libc.so.5.4.4
-rwxr-xr-x 1 bin bin 1874736 Feb 1 1998 /lib/libc.so.5.4.44
-rwxr-xr-x 1 bin bin 1427975 Jun 20 1998 /lib/libc.so.5.4.46
-rw-r--r-- 1 bin bin 1131866 Jun 20 1998 /usr/lib/libc.a
lrwxrwxrwx 1 bin bin 19 Feb 24 13:36 /usr/lib/libc.so ->
/lib/libc.so.5.4.46
Configure command: ./configure --enable-shared --enable-assembler --without-debug
--prefix=/usr/local/MYSQL --localstatedir=/usr/local/MYSQL/DB
--with-unix-socket-path=/usr/local/MYSQL/mysql.sock --with-extra-charsets=none
--without-innodb
---------------------------------------------------------------------
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
