How to improve IO of Solaris machine

pawanshirbhate
pawanshirbhate used Ask the Experts™
on
Hello,

I want to improve IO of T5220 solaris 10 (sparc) machine. Can anybody please help me to do that?

IO of T5220 seems to be very slow as compared to other machines. if anybody can help me out to tune this architecture to have efficient IO.

-Pawan
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2007

Commented:
how many disks do you have in that machine and what application? What is the memory size?

Author

Commented:
It has two disks. One is having ZFS and other is having UFS. each disk is of 200GB.  RAM is of 32GB with 64 CPUs.
Top Expert 2007

Commented:
what application do you run and why you think io needs improvement?
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Author

Commented:
i running postgres and doing bulk copy.

i am inserting huge data into the database. currently, i am getting 30K inserts/sec...whereas, i want to achieve 2 Millions inserts/sec.

'zpool iostat' is showing write speed of 1.2M/sec.



Running a large database on only 2 disks is madness. A single disk can only achieve 150-200 IOPS, which is totally insufficient for running databases.

You need to acquire an appropriately sized storage array to archieve the performance you want. You probably need at least 40 disks in the array (a rough estimate).
Distinguished Expert 2017
Commented:
Agree with robocat that achieving the IO performance you want with a single disk is madness.

robocat pointed out you are IO bound because of the seek/read/write on/to a single spindle (single drive).

Besides gaining fault tolerance, you may see some performance improvement if each of your existing disks were members of a pair in RAID 1
http://www.acnc.com/04_01_01.html

Not sure where the 40disks comes from, but better performance can be achieved where there are more individual disks.

You have invested heavily in a huge pump (CPU) with a huge reservoir (Memory) pushing data through a straw (one disk).

Top Expert 2007

Commented:
If you have such a requirement, then it is recommended to have external storage with multiple disks where you can distribute your database files for better read / write performance.

Author

Commented:
Thanks all for providing valuable information.

Yes, you guys are right that i would need to check for external storage or ZFS with more disk for distributed IO.


The "Sun Storage 7110 Unified Storage System" is a very nice system for a reasonable price :-)

I've requested that this question be deleted for the following reason:

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Not enough information to confirm an answer.

If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

Experts-Exchange Auto Deleter
I would state that adequate answers were provided by the experts and propose to split points amongst the participants.
Distinguished Expert 2017

Commented:
Holy 2009 question.

I think a blunt assessment following disclosure of single "disk" setup does not lend itself to Avail opportunity to enhance ?I/O pergormance.


https:#a24909524

https:#a24911248 supporting
Omarfarid's and other comments seemed to nudge/edge towards trying to figure out what the asker's expectations and willingness to do .....
I agree with arnold that the two linked comments by arnold and myself are an adequate answer to the question.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial