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

Asif Iqbal iqbala at qwestip.net
Thu Aug 21 16:06:11 EDT 2003


On Thu, 21 Aug 2003, Rasmus [iso-8859-1] Brøgger wrote:

> 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>

Thanks. So the answer is all my tables are InnoDB according to schema.mysql

>
> /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
>
>

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




More information about the rt-users mailing list