Thanks for your answer.
I´m alreay logging slow queries, i gather no results.
But when I take a look with the "MySQL Administrator" Tool
i see that there are many full table scans.
I want to discover which queries produce this full table scans.
I´ve read that in MySQL 5 full table scans are logged
I suggest checking out your slow query logs:
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
the queries are logged, so going into a client and running an explain
on the slow queries should help you out.
-Sheeri
On 11/21/05, ESV Media GmbH <[EMAIL PROTECTED]> wrote:
> Hey, we´ve a si
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 ?
We´ve a cpu percentage of nearly 50 % with only 30 Members online.
And i´ve seen that there are so
