[rt-users] Searching on requestor in large databases

[Blair Zajac]

Mat,

Could you tell us what was poorly set up and what changes were made to
have it work well?

Best,
Blair

Matthew Watson wrote:
> 
> Update on this..
> 
>  After doing various things with indexes, I got our dba to have a looky at
> it, and smartly he checked out the mysql cnf.. and rightly so, it was setup
> pretty bad. After tweeking my.cnf and apache/mod_perl we have this system
> running much better. Although it still barks a bit sometimes when a big
> query has a lock on a table (so heaps of other queries bottle up behind it)
> 
> Mat.

-- 
Blair Zajac <blair at orcaware.com>
Web and OS performance plots - http://www.orcaware.com/orca/