Re: Need Perfomance / Tuning Help

2005-11-21 Thread Gleb Paharenko
Hello. >Is there a way to find out which statements take a full table scan to >optimize them ? See: http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html Marco Schierhorn wrote: > Hey, we´ve a site ( PHP ) where several 1.000 are online at the same time. > They´re running ma

Need Perfomance / Tuning Help

2005-11-21 Thread Marco Schierhorn
Hey, we´ve a site ( PHP ) where several 1.000 are online at the same time. They´re running many sql statements. Is there a way to find out which statements take a full table scan to optimize them ? And i need some help with configuring the my.cnf. Below you´ll find our one. Which options should