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
I have just installed redhat linux 9 which ships with mysql
3.23.56. Mysql has to be setup so that it can use innodb tables,
and data inserts (blobs) should be able to handle at least 8M
at a time. The machine has two P III 933MHz CPU's,
1.128G RAM (512M*2 + 128M), and a 36 Gig hd with 1 Gig swap a
