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