Re: [iqug] Linux filesystem tuning for IQ

[Sathish J]

Dear iqug Team ,

I have one strange request from my IQ Customer. 

Customer  needs a procedure - which will be called before any sql query is applied to IQ DB from BI Tool. 

This Procedure will direct a dynamically route the sql query to  base table or summary table based on query conditions. 

Is it possible to  CALL / invoke or fork procedure before any sql start running into database and route the as per business rules. so that the  complexity is hidden from BI Tool and performance is improved based on selection of table or views . 

Regards ,

Sathish J  

 

On Thu, May 12, 2011 at 5:31 PM, <Mark...@sybase.com> wrote:

Leonid,

 

Raw devices were removed from RHEL 5.0.  Due to insistence, they were quickly added back in to 5.1.  Red Hat has agreed to keep the support around through at least the 6.x line as well.

 

From a tuning perspective, I don't know how much help there is out there specific to IQ! .  Most customers use raw devices.  Those that choose to use filesystems generally don't tune the filesystem.  Typically, customers look to the system administrators for knowledge on tuning the filesystems for various workloads as they should be the ones "in the know" on how to do this properly given that we want large IOs.

 

Mark

============================================================

Mark D. Mumy

IQ/RAP Technology Specialist, Global FSI Solutions

Sybase, an SAP Company

VOICE: 972.687.6478

MOBILE: 347.820.2136

mailto:Mark...@sybase.com

============================================================

 

From: Leonid Gvirtz <lgv...@yahoo.com> [mailto:Leonid Gvirtz <lgv...@yahoo.com>]
Sent: Thursday, May 12, 2011 8:09 AM
To: <iq...@dssolutions.com>
Subject: [iqug] Linux filesystem tuning for IQ

 

 

Hi

Using of raw devices, as opposed to filesystems, has been definite recommendation for IQ storage for years. Unfortunately, there is a trend in a Linux world to abandon raw devices support in f! uture versions of Linux, particularly RHEL. Raw devices has be! en alrea dy deprecated in RHEL 5, although the functionality is still available. I'm trying to investigate alternatives for raw devices on RHEL.

It appears that IQ doesn't support IQ files directly on block devices (like /dev/sda), so the only viable alternative I can see for now is a to use regular files on a filesystem with direct I/O. I read in IQ Sizing Guide that such a filesystem should be tuned in order to avoid splitting of relatively large I/Os performed by IQ into smaller units on the filesystem level. From the Sizing Guide:

Proper configuration of the filesystems must be done to ensure that Sybase IQ continues to perform at its peak levels. Typically, this means that the filesystem should be configured to allow for very large disk operations that are not broken down into much smaller units of works on disk.

I'm looking for recommendations for tuning of Linux filesystems (ext3?) for IQ storage. Any suggestions are welcome.

Thanks in advanc! e
Leonid Gvirtz
http://www.gvirtz-consulting.com

--
You received this message because you are subscribed to the Google Groups "iqug" group.
To post to this group, send email to iq...@googlegroups.com.
To unsubscribe from this group, send email to iqug+uns...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/iqug?hl=en.