Re: innodb and myisam and db optimising

2005-09-16 Thread Pooly
To: > 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. > > >

Re: innodb and myisam and db optimising

2005-09-16 Thread Pooly
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.h

innodb and myisam and db optimising

2005-09-16 Thread OKAN ARI
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