|
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. |
| |