Re: slow queries and high % of wait I/O
Increasing RAM ( a short-term strategy)
a. The production server "ibdata" file size is approximately 13GB. One line of thought in our group is that if we increase the RAM to 16 GB (it is currently 8GB), then OS file cache should load the entire file in memory and it should help us for the short-term by reducing disk I/O (atleast SELECTS will not require disk reads all the time)... Could you please comment if this will really work?
Long-term strategy:
b. Since we need to read all 25 records for each device_id, we are thinking of storing all the records as BLOB (indexed by device_id).
schema change will be as follows:
create table history (
id int auto_increment,
device_id VARCHAR,
history longBLOB // we will store a serialized object
)
So, instead of 25 disk seeks, this will probably be only 1. Is this a good strategy as our use case DOES NOT require us to search on any of the fields on the table other than deviceid? How does BLOB behave with repeated updates, since it is our use case?
Edited 2 time(s). Last edit at 01/20/2009 11:40PM by jawahar Muthukrishnan.
Subject
Views
Written By
Posted
9334
January 19, 2009 01:58PM
3459
January 19, 2009 04:22PM
3020
January 19, 2009 05:36PM
2711
January 19, 2009 09:00PM
2652
January 19, 2009 11:37PM
Re: slow queries and high % of wait I/O
2563
January 20, 2009 12:50PM
2370
January 21, 2009 12:29AM
2477
January 21, 2009 01:22AM
2316
January 21, 2009 05:23PM
2384
January 20, 2009 12:46AM
2421
January 20, 2009 01:28AM
2265
January 20, 2009 01:27PM
2369
January 20, 2009 08:41PM
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.