>Description:
Com_select not increment when used QUERY_CACHE and if query exists in cache
>How-To-Repeat:
1. enable QUERY_CACHE
2. Run 2 equal SELECT statment
>Originator: Andrew Sitnikov
>Organization:
Infonet Ltd.
>Severity: non-critical
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.5a-beta-standard (Official MySQL-standard binary)
>Server: /usr/local/mysql/bin/mysqladmin Ver 8.38 Distrib 4.0.5a-beta, for pc-linux
>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.5a-beta-standard-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 day 8 min 0 sec
Threads: 1 Questions: 1230149 Slow queries: 5 Opens: 2553 Flush tables: 1 Open
tables: 512 Queries per second avg: 14.159
>Environment:
System: Linux gap 2.4.20-grsec #1 SMP Fri Dec 6 23:17:05 EET 2002 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/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2
-mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 1384072 Oct 1 19:10 /lib/libc.so.6
-rw-r--r-- 1 root root 25215016 Oct 1 18:56 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Oct 1 18:56 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official
MySQL-standard binary' '--with-extra-charsets=complex'
'--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile'
'--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static'
'--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro'
'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' 'CXX=gcc'
---------------------------------------------------------------------
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
