List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:February 14 2000 12:55am
Subject:Re[4]: Question about perfomance REGEXP and mysql 3.23.8
View as plain text  
Hi!

>>>>> "Andrew" == Andrew Sitnikov <sitnikov@stripped> writes:

Andrew> Hello ,
smc> Can you try 3.23.9 and see if it has the same problem ??

Andrew> 3.22.22
Andrew> SELECT count(id) FROM tblRecords WHERE body REGEXP '[[:<:]]12' or body
> REGEXP '[[:<:]]pay';
Andrew> +-----------+
Andrew> | count(id) |
Andrew> +-----------+
Andrew> |      3987 |
Andrew> +-----------+
Andrew> 1 row in set (15.58 sec)

<cut>

Andrew> 3.23.9
Andrew> SELECT count(id) FROM tblRecords WHERE body REGEXP '[[:<:]]12' or body
> REGEXP '[[:<:]]pay';
Andrew> +-----------+
Andrew> | count(id) |
Andrew> +-----------+
Andrew> |      3988 |
Andrew> +-----------+
Andrew> 1 row in set (1 min 11.11 sec)

Andrew> Interesting also value of count() :)

I am now running this on my 3.23.11 version:

mysql> select count(*) from tblRecords where body regexp '[[:<:]]12' or body REGEXP
> '[[:<:]]pay';
+----------+
| count(*) |
+----------+
|     3987 |
+----------+
1 row in set (4.21 sec)

What do you get when doing:

mysql> show table status like "tblRecords";
+------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+----------------+---------+
| Name       | Type   | Row_format | Rows | Avg_row_length | Data_length | Max_data_length
| Index_length | Data_free | Auto_increment | Create_time         | Update_time         |
Check_time | Create_options | Comment |
+------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+----------------+---------+
| tblRecords | MyISAM | Dynamic    | 3987 |           5296 |    21117172 |      2147483647
|        49152 |         0 |           3988 | 2000-02-07 18:36:55 | 2000-02-07 18:36:56 |
NULL       |                |         |
+------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+----------------+---------+

Any change to get an account on your computer so that we can login
onto your site and test this there?

Did you compile MySQL 3.22 and 3.23 with the same options and the same
compiler?

Regards,
Monty
Thread
Question about perfomance REGEXP and mysql 3.23.8Andrew Sitnikov30 Jan
  • Re: Question about perfomance REGEXP and mysql 3.23.8sasha30 Jan
  • Re: Question about perfomance REGEXP and mysql 3.23.8sinisa30 Jan
    • Re[2]: Question about perfomance REGEXP and mysql 3.23.8Andrew Sitnikov30 Jan
Re[2]: Question about perfomance REGEXP and mysql 3.23.8Andrew Sitnikov30 Jan
  • Re: Re[2]: Question about perfomance REGEXP and mysql 3.23.8Benjamin Pflugmann30 Jan
  • Re[2]: Question about perfomance REGEXP and mysql 3.23.8Michael Widenius2 Feb
    • Re[3]: Question about perfomance REGEXP and mysql 3.23.8Andrew Sitnikov2 Feb
Re[4]: Question about perfomance REGEXP and mysql 3.23.8Andrew Sitnikov1 Feb
  • Re[4]: Question about perfomance REGEXP and mysql 3.23.8Michael Widenius14 Feb