Hi,
I have a table:
CREATE TABLE http_refer(
rid int unsigned auto_increment,
refer varchar(255),
unique index(rid),
unique index(refer)
);
It is filled with referrers from our webserver log and has 4138 rows.
Today I've tried to execute:
mysql> select max(length(refer)) from http_refer;
or
mysql> select min(length(refer)) from http_refer;
but both queries just hanged and I had to kill them.
Some of table rows is full filled with urls from search engines with long
list of parameters.
My server system : Linux 2.2.18 mysql-3.23.33-log
Any comments?
Saulius Gurklys
mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
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
