innodb and myisam and db optimising

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

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

Re: innodb and myisam and db optimising

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