>Description:
Queries to a table with BLOBs are very slow. I query
select id,name,lator,lonor,latpp,lonpp,width,height from segments order by name
The table is defined as:
create table segments (
id int not null auto_increment primary key,
name char(100) unique,
scale int not null,
dpi int not null,
width int not null,
height int not null,
lator double,
lonor double,
map mediumblob,
latpp double,
lonpp double,
index(id),
index(name));
>How-To-Repeat:
try the select statement
>Fix:
?
>Submitter-Id: <submitter ID>
>Originator: Andrej Andrejko <[EMAIL PROTECTED]>
>Organization:
>MySQL support: none
>Synopsis: slow queries with BLOBS
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.21-beta (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.7 Distrib 3.23.21-beta, for redhat-linux-gnu on
>i386
TCX Datakonsult AB, by Monty
Server version 3.23.21-beta-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 2 days 9 hours 37 min 8 sec
Threads: 2 Questions: 5700 Slow queries: 98 Opens: 22 Flush tables: 1 Open
tables: 8 Queries per second avg: 0.027
>Environment:
System: Linux andrej 2.2.16-17smp #1 SMP Wed Jul 26 15:53:36 EDT 2000 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 20000724 (experimental)
Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++'
CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Aug 5 2000 /lib/libc.so.6 ->
libc-2.1.91.so
-rwxr-xr-x 1 root root 4615653 Jul 25 2000 /lib/libc-2.1.91.so
-rw-r--r-- 1 root root 22294328 Jul 25 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jul 25 2000 /usr/lib/libc.so
Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr
--bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec
--localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man
--infodir=/usr/share/info --without-debug --without-readline --enable-shared
--with-extra-charsets=complex --without-bench --localstatedir=/var/lib/mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --enable-assembler
--with-mysqld-user=mysql
---------------------------------------------------------------------
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
