It is hard to provide a single answer without knowing the storage engine, and without knowing whether the problem is reading or writing to the database.
Appreciate your revert “gmouse” as always
Since i am a novice at it, Can you please let me know how can i find out if the server is having “Read OR Write” problems to the database ?
Thank you once again !!
If mutex contention or cpu power is not the problem, that will become clear from the disk utilization, as shown by e.g. iostat.
I have got the results from iostat, can you please comment on the status of the same :-