MySQL ODBC Connector - innodb and myisam and db optimising

Author

innodb and myisam and db optimising

OKAN ARI

2005-09-16, 9:23 am

------ =_NextPart_000_0034_
01C5BAE0.4ED35300
Content-Type: text/plain;
charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable

I have a web site that have 100unique users online at the same time. I =
will optimize DB structure.

1. Is there anysource about mysql optimization and performance tricks?
2. I can change the DB type, which is the best for high mysql traffic =
web sites, innoDB or MyIsam?

Thanks
------ =_NextPart_000_0034_
01C5BAE0.4ED35300--

Pooly

2005-09-16, 9:23 am

2005/9/16, OKAN ARI <okanari@aribem.com>:
> I have a web site that have 100unique users online at the same time. I wi=
ll optimize DB structure.
>=20
> 1. Is there anysource about mysql optimization and performance tricks?

you might want to look here :
http://dev.mysql.com/doc/mysql/en/query-speed.html

> 2. I can change the DB type, which is the best for high mysql traffic web=
sites, innoDB or MyIsam?

http://dev.mysql.com/doc/mysql/en/internal-locking.html
It depends on your website. If it's massive select over few
updates/inserts, go for MyISAM, unless you need transaction.

Check for slows queries. If you don't have access to the slow query
logs, the best is to log query time on a per page basis (or per
script/template which is better, depending your website).

check the field type, no nee to have an integer to store a state value
which is 0 or 1 for instance.

--=20
Pooly
Webzine Rock : http://www.w-fenec.org/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Pooly

2005-09-16, 11:23 am

Hi,

always reply to the list, you'll get better answers.

2005/9/16, OKAN ARI <okanari@aribem.com>:
> My actual DB isoptimized well about field types. I am using tinyint If i
> need etc;)
> But my problem is about examining logs, because
>=20
> 1. I dont' want to know how to reach mysql logs? Can you explain me how c=
an
> I examine detailed mysql logs?
> 2. Can you basicly define transaction and its advantages and disadvantage=
s?
>=20
> Thank you
>=20
>=20
> ----- Original Message -----
> From: "Pooly" <pooly7@gmail.com>
> To: <mysql@lists.mysql.com>
> Sent: Friday, September 16, 2005 5:13 PM
> Subject: Re: innodb and myisam and db optimising
>=20
>=20
> 2005/9/16, OKAN ARI <okanari@aribem.com>:
>=20
> you might want to look here :
> http://dev.mysql.com/doc/mysql/en/query-speed.html
>=20
eb[color=darkred]
>=20
> http://dev.mysql.com/doc/mysql/en/internal-locking.html
> It depends on your website. If it's massive select over few
> updates/inserts, go for MyISAM, unless you need transaction.
>=20
> Check for slows queries. If you don't have access to the slow query
> logs, the best is to log query time on a per page basis (or per
> script/template which is better, depending your website).
>=20
> check the field type, no nee to have an integer to store a state value
> which is 0 or 1 for instance.
>=20
> --
> Pooly
> Webzine Rock : http://www.w-fenec.org/
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql? unsub...ib
em.co=
m
>=20
>=20

--=20
Pooly
Webzine Rock : http://www.w-fenec.org/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links