[rt-users] Re: RT 3.0 Speed

Simon Woodward sw-lists at onyx.net
Wed May 7 10:56:14 EDT 2003


Still browsing about this one ... have just found :

mysqladmin -u root -p extended-status

| Handler_read_rnd_next    | 135533867  |

Handler_read_rnd_next : Number of requests to read the next row in the
datafile. This will be high if you are doing a lot of table scans.
Generally this suggests that your tables are not properly indexed or
that your queries are not written to take advantage of the indexes you
have.

Any thoughts on this ???

Cheers,

Simon.

-- 
Simon Woodward <sw-lists at onyx.net>
Onyx Internet




More information about the rt-users mailing list