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

[Asif Iqbal]

On Thu, 21 Aug 2003, 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.
>
> >
> >> 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/

Thanks a lot. Let me get back to RTFM. Hopefully this and an upgrade to
RT3.0.5pre should solve my issue.

>
> Although this is for version 3.x, most of the information is still
> correct.
>
> Regards,
>      Harald
>

-- 
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There's no place like 127.0.0.1