List:General Discussion« Previous MessageNext Message »
From:Pooly Date:September 16 2005 2:37pm
Subject:Re: innodb and myisam and db optimising
View as plain text  
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/
Thread
innodb and myisam and db optimisingOKAN ARI16 Sep
  • Re: innodb and myisam and db optimisingPooly16 Sep
Re: innodb and myisam and db optimisingPooly16 Sep