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]