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
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