[rt-users] httpd's are more than 10%

[Rasmus Brøgger]

On Thu, Aug 21, 2003 at 06:15:57PM +0200, Harald Wagener wrote:
> 
> On Donnerstag, 21. August 2003, at 17:12 Uhr, Asif Iqbal wrote:
> 
> >On Thu, 21 Aug 2003, Harald Wagener wrote:
> >
> >>
> >>On Donnerstag, 21. August 2003, at 16:55 Uhr, Asif Iqbal wrote:
> >>
> >>>On Thu, 21 Aug 2003, [iso-8859-2] Ale¹ Su¹nik wrote:
> >>>>mysql config?
> >>>my-medium.cnf
> >>>
> >>>I commented out all the references to innodb to avoid any further
> >>>crash in my
> >>>mysql.
> >>
> >>Are Your rt databases innodb or MyISAM? They will be faster if You run
> >
> >Innodb I think. How can I confirm that ?
> 
> 
> You can change the table type by issuing
> 
> > ALTER TABLE tablename TYPE=InnoDB;
> 
> at the mysql prompt.
> 
> I don't know of a quick method to find out if You are currently using 
> InnoDB databases.
> 
If it's a default RT3 install the information is in
<pathtort>/etc/schema.<dbname>

/rhb

> >
> >>an optimized innodb setup.
> >
> >How do you run an optimized innodb setup ?
> >
> >Sorry for all these newbie questions ?
> >
> 
> This is documented in the mysql documentation. I did do it 'by the 
> book', have a look at http://www.mysql.com/doc/en/index.html. There are 
> three or four variables controlling how much memory MySQL uses, and 
> another three or four that control innodb. InnoDB is described in 
> Chapter 7.5
> 
> Another good resource is Jeremy Zawodny's web site at
> http://jeremy.zawodny.com/mysql/
> 
> Although this is for version 3.x, most of the information is still 
> correct.
> 
> Regards,
>     Harald
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm