Hi,
always reply to the list, you'll get better answers.
2005/9/16, OKAN ARI <okanari@stripped>:
> My actual DB isoptimized well about field types. I am using tinyint If i
> need etc;)
> But my problem is about examining logs, because
>
> 1. I dont' want to know how to reach mysql logs? Can you explain me how can
> I examine detailed mysql logs?
> 2. Can you basicly define transaction and its advantages and disadvantages?
>
> Thank you
>
>
> ----- Original Message -----
> From: "Pooly" <pooly7@stripped>
> To: <mysql@stripped>
> Sent: Friday, September 16, 2005 5:13 PM
> Subject: Re: innodb and myisam and db optimising
>
>
> 2005/9/16, OKAN ARI <okanari@stripped>:
> > 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?
>
> 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.
>
> --
> 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=1
>
>
--
Pooly
Webzine Rock : http://www.w-fenec.org/
