Re: Slow Database
A quick glance, you may want to pay some attention to these values
Created_tmp_disk_tables 10300
Created_tmp_tables 11584
Do you need to increate the tmp_table_size to reduce the use of disk for storing the tmp table.
Open_tables 68
Opened_tables 2640
Maybe increasing the table_cache can reduce the opening and closing of table files.
Slow_queries 510
Turn on the slow log to see what is the queries that are slow and see if it can be optimised further.
Subject
Views
Written By
Posted
9710
May 31, 2006 11:29AM
3835
May 31, 2006 12:06PM
3160
May 31, 2006 12:43PM
2970
May 31, 2006 07:43PM
2884
June 01, 2006 12:19AM
3622
June 01, 2006 04:14AM
2772
June 01, 2006 06:40PM
3310
June 02, 2006 02:17AM
Re: Slow Database
3100
June 05, 2006 10:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.