Question on slow queries

2003-11-13 Thread Luis Lebron 
I just started logging slow queries. Today I found the following lines in
the slow query log.

# Query_time: 14  Lock_time: 0  Rows_sent: 293  Rows_examined: 293
use storyboards;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `rwt_screens`;


What exact does the third line mean?

thanks,


Luis R. Lebron
Sigmatech, Inc

RE: Question on slow queries

2003-11-13 Thread Victor Pendleton 
A full table scan was performed on the rwt_screens table. The /* ... */
means that if the dbms is 4.0.x then do not cache this query.

-Original Message-
From: Luis Lebron [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 8:52 AM
To: Mysql (E-mail)
Subject: Question on slow queries


I just started logging slow queries. Today I found the following lines in
the slow query log.

# Query_time: 14  Lock_time: 0  Rows_sent: 293  Rows_examined: 293
use storyboards;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `rwt_screens`;


What exact does the third line mean?

thanks,


Luis R. Lebron
Sigmatech, Inc

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]