RE: Concurrent queries problem (Gustavo Brian)

18 Aug 2015

      Hi,

After checking CPU (48 cores) none of them get over 15%, there's free memory (119Gb) and 0% reads but high WRITE activity, any idea why?

Thanks,
Gustavo Brian
Developer

-----Original Message-----
From: users-list [mailto:users-list-bounces+gustavo.brian=sunhotels.net@monetdb.org] On Behalf Of users-list-request@monetdb.org
Sent: lunes, 17 de agosto de 2015 12:00
To: users-list@monetdb.org
Subject: users-list Digest, Vol 36, Issue 19

Send users-list mailing list submissions to
	users-list@monetdb.org

To subscribe or unsubscribe via the World Wide Web, visit
	https://www.monetdb.org/mailman/listinfo/users-list
or, via email, send a message with subject or body 'help' to
	users-list-request@monetdb.org

You can reach the person managing the list at
	users-list-owner@monetdb.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of users-list digest..."

Today's Topics:

   1. Concurrent queries problem (Gustavo Brian)
   2. Re: Concurrent queries problem (Martin Kersten)
   3. Inserting in 'raw' mode?? (Vijay Krishna)

----------------------------------------------------------------------

Message: 1
Date: Sun, 16 Aug 2015 17:07:41 +0000
From: Gustavo Brian 
To: "users-list@monetdb.org" 
Subject: Concurrent queries problem
Message-ID: <4A8379DA0ABDFC42B172EDB698BD76E8D46EF829@mailbox02>
Content-Type: text/plain; charset="iso-8859-1"

Hi,

I'm using one big table a my main storage for hotel prices and I'm running queries to get the best prices for specific dates and a couple of filters.
On one test I have a query scanning 30 millions rows in ~400ms but when I try to run several queries at a time monetdb hangs.
I've tried creating a funnel over the database but same result.
What's the best approach if I need to run 150 queries per second ?

Thanks in advance,
Gustavo Brian

Developer

SunHotels

E-mail
Skype
Tel
Fax
Web

Operational Office

gustavo.brian@sunhotels.netmailto:gustavo.brian@sunhotels.net
Gustavo.brian.sunhotels
+34 871 955 649
+34 971 281 460
www.sunhotels.org

SunHotels
Calle Cal?at 6
Pol?gono Son Valent?
07011 Palma de Mallorca
Spain
...
...
Winner of Grand Travel Award - Best Provider in Scandinavia  <<
Confidential and proprietary information notice:
This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.
Please preserve message history when replying to this e-mail