Hi, always reply to the list, you'll get better answers.
2005/9/16, OKAN ARI <[EMAIL PROTECTED]>: > 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" <[EMAIL PROTECTED]> > To: <mysql@lists.mysql.com> > Sent: Friday, September 16, 2005 5:13 PM > Subject: Re: innodb and myisam and db optimising > > > 2005/9/16, OKAN ARI <[EMAIL PROTECTED]>: > > 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/[EMAIL PROTECTED] > > -- 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/[EMAIL PROTECTED]
