[rt-devel] Slow queries, part 2, custom fields

Iain Price iain.price at post.serco.com
Thu Oct 2 06:28:51 EDT 2003


Jesse Vincent wrote:

>
>  
>
>>humans than the previous multi-requestor-email one...
>>
>>Notably all this is only a big issue because RT locks the database 
>>during the query, hence preventing all other activity by other users RT 
>>sessions...
>>    
>>
>
>Can you verify that you're using mysql 4.0.x with InnoDB tables for all
>of RT's tables?
>
>  
>
Its a 'custom' compiled 4.0.13 with query logging enabled.

Table types, hmm gosh i'll have to work out how to do that - the db was 
built by the install script for rt 3.0.2
Dunno if this is right, but a mysqldump rt3 dumps create statements 
ending in Type=MyISAM... i dont really know anything about table types 
in mysql tho, i'd not even considered this :)  should i be changing 
something? :) (how? lol)

Thanks,
Iain

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pallas.eruditorum.org/pipermail/rt-devel/attachments/20031002/604e4d77/attachment.htm


More information about the Rt-devel mailing list