Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Andrew Armstrong <andrew at qdebit dot com>
Subject: Re: RES: Linux and Devices
Date: Sep 20 2000 6:49PM

I just found the stuff on sybase for 11.0.3-6 and support of Raw devices in
redhat 6.1 kernel 2.2.12. Thanks anyway.

Quoting André de oliveira Castanheira

> Armstrong,
> ASE 11.0.3 supports raw devices, just download ASE 11.0.3 from sybase
> site
> and read installation manual.
> Bye
> André
> -----Mensagem original-----
> De:
> []Em nome de Andrew Armstrong
> Enviada em: Wednesday, September 20, 2000 2:58 PM
> Para: SybPerl Discussion List
> Assunto: Linux and Devices
> I have some questions for anybody that is running Sybase on Linux. Since
> there
> is no raw file device support in Redat Linux, Sybase is forced to store
> it's
> databases as files. I have set up a database to be the maximum file size
> of
> 2GB.
> The machine that Sybase runs on is a 6-way Xeon.
> I have configured the database to run as 4 processes and also to run as
> 2
> processes in the past. I have noticed that there is not a great
> performance
> boost from running multiple processes in the current setup.
> What I would like to determine is whether or not the database stored as
> a
> file
> is locked by the kernel every time the database needs to write to the
> database.
> It makes sense to me that if the database is treated as a normal linux
> FS
> file,
> then the kernel would put a write lock on the file whenever it needs to
> do
> an
> update , insert or delete.
> If my assumption about the locking is correct, it would also make sense
> that
> running multiple sybase processes would not give much of a performance
> boost
> ,
> if every time one of the processes needs to write to the database the
> entire
> database file is locked.
> If anybody out there has run into similar problems or knows how to
> bypass
> the
> problem please let me know.
> Also, if anybody out there has found a way to support raw file devices
> in
> linux
> please let me know where I can find documentation on this.
> ----------------------------------------------------------------------------
> ---
> Andrew Armstrong                                         
> Chief E-Commerce Engineer

Andrew Armstrong                                
Chief E-Commerce Engineer