PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
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: owner-SYBPERL-L@list.cren.net
> [mailto:owner-SYBPERL-L@list.cren.net]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                                         
> andrew@qdebit.com
> Chief E-Commerce Engineer
> http://www.qdebit.com
> AMIS , LLC.
> 



-------------------------------------------------------------------------------
Andrew Armstrong                                          andrew@qdebit.com
Chief E-Commerce Engineer                                 http://www.qdebit.com
AMIS , LLC.