If you have the slow query log enabled, grab some
slow queries from there and run EXPLAIN.
From there, you can figure out how the optimizer is executing the query.
I found that approach to be very useful in
optimizing individual queries and making indexing decisions.
I can't quite make out w
Dimitar,
Just looking over the server status, it looks
like you have a high rate of temp table to disk.
Created_tmp_disk_tables 5454
Created_tmp_files 1010
Created_tmp_tables 3
I would try increasing the max_heap_table_size.
Increasing the tmp_table_size alone wouldn't be enoug
Hi
I am using Mysql 4.1 on
CPU 2 Xeon 3.0 Ghz + 2 Virtual (Hyperthreads) (I think it is not using the 2nd
processor)
Memory 4GB
I think that the read from the HDD is 50mb per 1 sec, but I am not sure.
I have very big problem with performance, because there are very bad search
queries, but ev
