Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

Blue Forest http://www.lslnet.com at 11:08 on July 8, 2006


Solaris, dsync=true circumstances, the establishment of a database is very slow!

Solaris8, Sybase12.5.3 first established five device, and then create a database!
If the dsync=true devices, the establishment of a database required 13 minutes
If the dsync=false devices, the establishment of a database needs only 30 seconds

Create database db_name
On dev1= "256M" dev2= "256M" dev3= "256M" dev4= "256M"
Log on dev5= "100M"
Go
Documents related to the investigation on a Sybase System, dsync=false Sybase does not recommend the use of the devices to store data.
In dsync=true circumstances, the establishment of a database of how slow? Is not the way to improve

Solaris, dsync=true circumstances, the establishment of a database is very slow!

You are directly in the file system built on the right equipment, dsync=true OS is not passed when the buffercache, write disk directly, of course, will slow dsync=false when the OS will use the buffercache single reliable worse. But worse still really did not expect so many.

Solaris, dsync=true circumstances, the establishment of a database is very slow!

Check on speed and delayed I/O

Solaris, dsync=true circumstances, the establishment of a database is very slow!

File System is built directly on the equipment, not only from the disk optimization I/O respect? Is it because the writing is so much speed difference between the speed?

Solaris, dsync=true circumstances, the establishment of a database is very slow!

Dsync difference may be opened and closed, but you can test articulated other, equally slowly. Another disk init also slower?

Solaris, dsync=true circumstances, the establishment of a database is very slow!

For key equipment should be opened or dsync!

Solaris, dsync=true circumstances, the establishment of a database is very slow!

Testing very slowly in the server, disk init soon! Since the system is small, no raid controller, a direct link SCSI hard disk!

Solaris, dsync=true circumstances, the establishment of a database is very slow!

Solaris, dsync=true circumstances, the establishment of a database is very slow!

Will be directly connected SCSI disk so fast? Not right

Solaris, dsync=true circumstances, the establishment of a database is very slow!

Solaris, dsync=true circumstances, the establishment of a database is very slow!

Almost 13 minutes, dsync=false when only 30 seconds, too fast instead.



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com