Menu
▾
▴
luciddb-users — Mailing list for users of LucidDB
You can subscribe to this list here.
| 2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(28) |
Jun
(2) |
Jul
(10) |
Aug
(1) |
Sep
(7) |
Oct
|
Nov
(1) |
Dec
(7) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008 |
Jan
(5) |
Feb
(7) |
Mar
(10) |
Apr
(12) |
May
(30) |
Jun
(21) |
Jul
(19) |
Aug
(17) |
Sep
(25) |
Oct
(46) |
Nov
(14) |
Dec
(11) |
| 2009 |
Jan
(5) |
Feb
(36) |
Mar
(17) |
Apr
(20) |
May
(75) |
Jun
(143) |
Jul
(29) |
Aug
(41) |
Sep
(38) |
Oct
(71) |
Nov
(17) |
Dec
(56) |
| 2010 |
Jan
(48) |
Feb
(31) |
Mar
(56) |
Apr
(24) |
May
(7) |
Jun
(18) |
Jul
(2) |
Aug
(34) |
Sep
(17) |
Oct
(1) |
Nov
|
Dec
(18) |
| 2011 |
Jan
(12) |
Feb
(19) |
Mar
(25) |
Apr
(11) |
May
(26) |
Jun
(16) |
Jul
(2) |
Aug
(10) |
Sep
(8) |
Oct
(1) |
Nov
|
Dec
(5) |
| 2012 |
Jan
(1) |
Feb
(3) |
Mar
(3) |
Apr
|
May
(2) |
Jun
|
Jul
(3) |
Aug
(1) |
Sep
(2) |
Oct
|
Nov
(2) |
Dec
|
|
From: Mauro F. <mau...@gm...> - 2011-06-08 18:15:44
|
I would have an information about the script to create indexes (create_index.sql),this file create indexes not only for fake foreign keys but also to optimize the query. it's possible to analyze it without optimization? Best Regards Mauro Fagnoni -- ----------------------------------------------- [-------WHOAMI------] Mauro Fagnoni [----------ICQ#---------] 279572903 [--------MSNID--------] mau...@ya... [--YAHOOMSNID--] mau...@gm... [--GOOGLETALK--] mau...@gm... [-GOOGLEWAVE-] mau...@go... [------JABBER-------] mau...@gm... [------SKYPE--------] mauro.fagnoni [-----LinuxUser#----] 346345 [----------Blog---------] http://kingmauro.wordpress.com ----------------------------------------------- |
|
From: Mauro F. <mau...@gm...> - 2011-06-08 13:35:13
|
I would have an information about the script to create indexes (create_index.sql),this file create indexes not only for fake foreign keys but also to optimize the query. it's possible to analyze it without optimization? Best Regards Mauro Fagnoni -- ----------------------------------------------- [-------WHOAMI------] Mauro Fagnoni [----------ICQ#---------] 279572903 [--------MSNID--------] mau...@ya... [--YAHOOMSNID--] mau...@gm... [--GOOGLETALK--] mau...@gm... [-GOOGLEWAVE-] mau...@go... [------JABBER-------] mau...@gm... [------SKYPE--------] mauro.fagnoni [-----LinuxUser#----] 346345 [----------Blog---------] http://kingmauro.wordpress.com ----------------------------------------------- |
|
From: victor.savkin <vic...@tr...> - 2011-06-02 14:53:52
|
This is the query I use:
select
oi.order_id,
oi.trnx_type,
oi.branch_id,
pc.category,
pr.product_description
from
svv.order_item oi,
svv.order_header oh,
svv.prod_cat pc,
svv.product pr
where
oi.prod_code = pr.prod_code and oi.branch_id = pr.branch_id
and oi.prod_code = pc.prod_code and oi.branch_id = pc.branch_id
and oi.order_id = oh.order_id and oi.branch_id = oh.branch_id
and oh.modified_date between TIMESTAMP'2010-01-01 00:00:00' and
TIMESTAMP'2010-02-01 00:00:00'
I investigated a bit further and I have more information. All threads are
able to get a result set (which is about 33000 rows). 7 threads can iterate
over the result set. But the 8th thread can only iterate over 5000 (each
time it's a bit different) rows and than it gets blocked on
resultSet.next(). Killing the application doesn't help. The session remains
open.
Thanks,
Victor
--
View this message in context: http://luciddb-users.1374590.n2.nabble.com/LucidDB-Gets-Stuck-Processing-Many-Concurrent-Queries-tp6424597p6431504.html
Sent from the luciddb-users mailing list archive at Nabble.com.
|
|
From: victor.savkin <vic...@tr...> - 2011-06-02 13:15:43
|
Thanks for your response Nick. Victor -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/Problems-with-Idle-Connections-tp6424556p6431098.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: Nicholas G. <ngo...@dy...> - 2011-06-01 21:17:34
|
On Jun 1, 2011, at 9:00 AM, victor.savkin wrote: > 3. 7 queries disappear from DBA_SQL_STATEMENTS but one is there. For each > thread it takes about 10 seconds to perform the query except the one that > gets stuck (I waited for 10 minutes, no result). Interesting... I've not observed this behavior before. Are the queries identical? Can you share their contents? Nick |
|
From: Nicholas G. <ngo...@dy...> - 2011-06-01 21:11:03
|
My best guess: vJDBC (which is our client server protocol for remote connections) does have a "ping" over HTTP to keep it open. My best guess (I haven't looked into this code for ages so it's a guess) is that vJDBC might have it's own timer thread that runs to mark connections as stale (and after we get the vJDBC notification is when we mark it as unused). I'm not sure we've ever noticed this as typically the connection time out for most BI / DW workloads is usually 20, 30, 60 min - ish. If the vJDBC timer is 30 or 60 seconds itself this could make a big difference (as you noted) in smaller times. Nick On Jun 1, 2011, at 1:39 PM, victor.savkin wrote: > I'm not sure why it's happening. Why setting connectionTimeoutMillis to 1 > second makes luciddb to keep an idle connection for more than 2 minutes. > It's not a problem, it's just a bit confusing. |
|
From: victor.savkin <vic...@tr...> - 2011-06-01 20:39:58
|
Hi Nick, Thanks for your reply. You are right, last time I didn't restart my server after changing "connectionTimeoutMillis". After I restarted the database server it started closing idle sessions. However, I was experimenting a bit more and I have one question: 1. I set my connectionTimeoutMillis to 60 seconds. Then I ran my app several times each time leaving an open connection. Each time it took about 90 seconds for luciddb to release my connection. 2. I set my connectionTimeoutMillis to 1 second. Then I ran my app several times each time leaving an open connection. Each time it took about 150 seconds for luciddb to release my connection. I'm not sure why it's happening. Why setting connectionTimeoutMillis to 1 second makes luciddb to keep an idle connection for more than 2 minutes. It's not a problem, it's just a bit confusing. One more time, thank you for your prompt reply. Victor -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/Problems-with-Idle-Connections-tp6424556p6428729.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: victor.savkin <vic...@tr...> - 2011-06-01 16:00:52
|
Hi Nicholas, Thank you for your response. Answering your questions: 1. I'm creating 8 separate connections. 2. I don't think that there is a limit to 8 threads somewhere. I can run another query using 12 parallel threads and everything works fine. 3. 7 queries disappear from DBA_SQL_STATEMENTS but one is there. For each thread it takes about 10 seconds to perform the query except the one that gets stuck (I waited for 10 minutes, no result). I can also see several blocked threads with similar name (something like qtp5016452-42). Thanks, Victor -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/LucidDB-Gets-Stuck-Processing-Many-Concurrent-Queries-tp6424597p6427586.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: Nicholas G. <ngo...@dy...> - 2011-05-31 23:46:19
|
Welcome Victor to LucidDB community! On May 31, 2011, at 2:08 PM, victor.savkin wrote: > When I don't > close connections properly I always receive: 'Cache scratch memory > exhausted'. Well, I think you've already identified the key point here. Database connections should be closed... that's why programmers take such care to make sure it's in the finally() blocks, etc. However, sometimes, in rare cases they don't which is why we have things like the connectionTimeutMillis param. > Step to reproduce: > 1. Write a small java app querying luciddb. > 2. When the app starts kill it, so the connection won't be closed. > 3. Repeat steps 1-2 more than expectedConcurrentStatements times. > 4. Next time you'll get "Cache scratch memory exhausted". I just verified (since we did have an HTTP regression between 0.9.2 and 0.9.3) that LucidDB does actually shutdown sessions that are idle. If a connection is running a long query when client is killed, the connection timeout will only start it's timer once the query has been returned (I didn't test this, but I'm pretty sure). So... is it possible that there are long running SQL statements are still running on those orphaned connections? If so, they'll only be marked as available for timing out when that query is done. Some helpful system views in determining: http://pub.eigenbase.org/wiki/LucidDbSystemViews#DBA_SQL_STATEMENTS http://pub.eigenbase.org/wiki/LucidDbSystemViews#DBA_SESSIONS Also, some helpful statements if you're trying to prune failed clients that can't receive a result when they're ready: http://pub.eigenbase.org/wiki/LucidDbSysRoot_KILL_SESSION http://pub.eigenbase.org/wiki/LucidDbSysRoot_KILL_STATEMENT LucidDB does not kill statements while they're running for connectionTimeoutMillis; it's only for non attached sessions. If a connection is open, but unused, there's a ping that keeps coming back as well that keeps it available. If you're killing the application, the ping will be gone so this is probably not an issue for you. > hoping that luciddb will recreate the connections. But it didn't help. To > make it work I have to restart the database which is unacceptable in > production. connectionTimeoutMillis only takes effect at startup. Is it possible that you changed it to 2 minutes but hadn't restarted the server prior to your test? Nick |
|
From: Nicholas G. <ngo...@ba...> - 2011-05-31 22:14:49
|
On May 31, 2011, at 2:18 PM, victor.savkin wrote: > I have a heavy query. I'm trying to run this query in parallel using X > threads. How are you trying to do parallel? Are they all separate connections, queries that you are running separately or are you using a UNIONed dataset with degreeOfParallelism? > But each time I'm running it in 8 threads I got 7 responses but 1 thread > always gets stuck. I don't get any answer from luciddb. If I run all 8 > queries with a small random delay, so they won't be started at the same time > it works fine. Could you help me to understand what is causing the issue? Can you determine if all 8 queries are being executed (check the Trace.log for the statement logging). I know of no artificial limit to 8 threads. If one is being run, but is stuck you should also see it in http://pub.eigenbase.org/wiki/LucidDbSystemViews#DBA_SQL_STATEMENTS Can you confirm that you see 8 records for your queries in there, and that 7 of the 8 return successfully (disappear) but that one remains? |
|
From: victor.savkin <vic...@tr...> - 2011-05-31 21:18:41
|
Hi Guys, I have a heavy query. I'm trying to run this query in parallel using X threads. It works fine in 5 threads. It works fine in 7 threads. But each time I'm running it in 8 threads I got 7 responses but 1 thread always gets stuck. I don't get any answer from luciddb. If I run all 8 queries with a small random delay, so they won't be started at the same time it works fine. Could you help me to understand what is causing the issue? LucidDB configuration: expectedConcurrentStatements is 12 Thanks, Victor -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/LucidDB-Gets-Stuck-Processing-Many-Concurrent-Queries-tp6424597p6424597.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: victor.savkin <vic...@tr...> - 2011-05-31 21:08:25
|
Hi Guys, I really struggle to tackle one problem I have with luciddb. When I don't close connections properly I always receive: 'Cache scratch memory exhausted'. Step to reproduce: 1. Write a small java app querying luciddb. 2. When the app starts kill it, so the connection won't be closed. 3. Repeat steps 1-2 more than expectedConcurrentStatements times. 4. Next time you'll get "Cache scratch memory exhausted". I assume luciddb doesn't release memory allocated to those connections. So I tried to fix it by setting connectionTimeoutMillis = 120000 (2 minutes) hoping that luciddb will recreate the connections. But it didn't help. To make it work I have to restart the database which is unacceptable in production. Could you help me with this situation? Thanks, Victor -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/Problems-with-Idle-Connections-tp6424556p6424556.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: Brandon J. <usb...@gm...> - 2011-05-27 13:33:20
|
We are running LucidDB in a production environment and are very happy with it. Like with any product, it takes a bit of time to get hold of the reins and use it effectively. The speed increases we get and the relaxed feeling we have not being tied in to a reoccurring license fee is unmatched. Also we have accurate answers and have not lost data. Lucid's built in mechanisms for pulling data into itself and allowing joining on tables within itself that exist through connections to other databases is really cool. For our setup, we use another great software called Pentaho Data Integration for most of our ETL that streams into Lucid. Both companies are great to work with supportwise and so are the communities that follow them. You'll be amazed at the concentration of smart people around these products. Brandon |
|
From: a_n_d_r_e_a <and...@gm...> - 2011-05-27 07:16:37
|
It works, I don t have space problem, but the IT provaide in that machine some "fast" disk and I would try if the performance are better Thanks Andrea -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/Move-db-dat-tp6406789p6409997.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: Matt C. <mca...@pe...> - 2011-05-26 18:32:18
|
I can confirm that a symbolic link works not just for db.dat but for the complete catalog folder as well. HTH, Matt 2011/5/26 Nicholas Goodman <ngo...@dy...> > On May 26, 2011, at 5:21 AM, a_n_d_r_e_a wrote: > > > Hi all, > > I have to set up a new database, it is possible to "move" db.dat in an > other > > folder? or in an other disk? > > Unfortunately the location of the db.dat is fixed inside the catalog/ dir > of a LucidDB installation. However, I recall that doing a symbolic link on > the file is sufficient. So, as long as your not using Windoze you can > > 1) shutdown LucidDB > 2) mv db.dat /newlocation/db.dat > 3) ln -s /newlocation/db.dat > 4) Startup LucidDB. > > Disclaimer: I haven't tried this in a while; let us know if there's any > issues with it. > > Often (and I have no idea if this is the case for you) the db.dat is well > beyond the size it actually should be due to unused and "yet to be > deallocated" pages sitting around. Make sure you keep doing "alter system > deallocate old" regularly. > > Nick > > ------------------------------------------------------------------------------ > vRanger cuts backup time in half-while increasing security. > With the market-leading solution for virtual backup and recovery, > you get blazing-fast, flexible, and affordable data protection. > Download your free trial now. > http://p.sf.net/sfu/quest-d2dcopy1 > _______________________________________________ > luciddb-users mailing list > luc...@li... > https://lists.sourceforge.net/lists/listinfo/luciddb-users > > |
|
From: Nicholas G. <ngo...@dy...> - 2011-05-26 16:23:58
|
On May 26, 2011, at 5:21 AM, a_n_d_r_e_a wrote: > Hi all, > I have to set up a new database, it is possible to "move" db.dat in an other > folder? or in an other disk? Unfortunately the location of the db.dat is fixed inside the catalog/ dir of a LucidDB installation. However, I recall that doing a symbolic link on the file is sufficient. So, as long as your not using Windoze you can 1) shutdown LucidDB 2) mv db.dat /newlocation/db.dat 3) ln -s /newlocation/db.dat 4) Startup LucidDB. Disclaimer: I haven't tried this in a while; let us know if there's any issues with it. Often (and I have no idea if this is the case for you) the db.dat is well beyond the size it actually should be due to unused and "yet to be deallocated" pages sitting around. Make sure you keep doing "alter system deallocate old" regularly. Nick |
|
From: a_n_d_r_e_a <and...@gm...> - 2011-05-26 12:21:39
|
Hi all, I have to set up a new database, it is possible to "move" db.dat in an other folder? or in an other disk? Thanks Andrea -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/Move-db-dat-tp6406789p6406789.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: Kevin S. <kse...@dy...> - 2011-05-25 18:23:24
|
Levent, install.bat does some busy-work and spits out a few files (one called "classpath.gen"). Go to the bin folder and try running lucidDbServer, then once it starts up completely run sqllineClient. Most people usually run these directly from the command prompt (which you can get with Start > Run > "cmd.exe") where the messages are quickly visible. Windows will close a cmd window by itself if there is no prompt for input, which we don't do in the case of install.bat. If you're still having trouble, consult: http://pub.eigenbase.org/wiki/LucidDbGettingStarted On Wed, May 25, 2011 at 6:24 AM, lsofttm <Don...@gm...> wrote: > Hello Eric > I'm Levent > I'm a student and I work on luciddb. > when I started to install the luciddb (win 32) > it has crashed.The last thing I have seen that a small black screen(MS DOS > screen) and it's just disappeared. > I have slown down it but I have seen nothing on the black screen. > I 'm sending a photo of the black screen. > I thinkmaybe you can show me the way or figure out.. > Thanks for helping.. > > By the way: > I'm using Microsoft XP SP3 > And I have downloaded luciddb win32(also 64) > http://luciddb-users.1374590.n2.nabble.com/file/n6402691/25.05.jpg > > -- > View this message in context: > http://luciddb-users.1374590.n2.nabble.com/Experiences-with-luciddb-tp6368689p6402691.html > Sent from the luciddb-users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > vRanger cuts backup time in half-while increasing security. > With the market-leading solution for virtual backup and recovery, > you get blazing-fast, flexible, and affordable data protection. > Download your free trial now. > http://p.sf.net/sfu/quest-d2dcopy1 > _______________________________________________ > luciddb-users mailing list > luc...@li... > https://lists.sourceforge.net/lists/listinfo/luciddb-users > |
|
From: lsofttm <Don...@gm...> - 2011-05-25 13:24:48
|
Hello Eric I'm Levent I'm a student and I work on luciddb. when I started to install the luciddb (win 32) it has crashed.The last thing I have seen that a small black screen(MS DOS screen) and it's just disappeared. I have slown down it but I have seen nothing on the black screen. I 'm sending a photo of the black screen. I thinkmaybe you can show me the way or figure out.. Thanks for helping.. By the way: I'm using Microsoft XP SP3 And I have downloaded luciddb win32(also 64) http://luciddb-users.1374590.n2.nabble.com/file/n6402691/25.05.jpg -- View this message in context: http://luciddb-users.1374590.n2.nabble.com/Experiences-with-luciddb-tp6368689p6402691.html Sent from the luciddb-users mailing list archive at Nabble.com. |
|
From: Eric F. <ep...@me...> - 2011-05-16 13:37:03
|
Hi all, I want to make a case for the use of LucidDB, and am looking for LucidDB users who are able to point to concrete successes (in production, not just benchmarks). I don't need to contact anyone, but could use some success stories. Anyone have any good stories? Thanks Eric |
|
From: Nicholas G. <ngo...@dy...> - 2011-05-10 17:35:59
|
Our next meetup will be May 25 at SQLstreams offices near Civic Center in SFO, 5-7pm. http://www.meetup.com/San-Francisco-Eigenbase-Developers/events/17618441/ It's an informal gathering of Eigenbase/LucidDB developers and users. Drop by for a beer, hear some nerdy happenings about the foundation/projects. Here's the topics we're bringing in from SFO's northern, much cloudier neighbor: GitHub migration plans/discussion Scriptable SQL/MED datasources update (and UDPs) 0.9.4 Release Planning CouchDB SQL/MED adapter LucidDB User Forums LAUNCH! (Eigenbase dev forums?) SQLstream will likely have some additional topics as well; more the merrier! Look forward to seeing bay area folks there! Nick PS - I'm starting to get recognized on the Wednesday Alaska Airlines SEA-SFO flights for these meetups. :) |
|
From: rails.info i. <rai...@gm...> - 2011-05-10 06:36:34
|
Dear Nicholas, I know, right, but it's an awesome name ;-) Anyway, I'd like to thank you for taking the time to reply. I must say though that it appears that LucidDB is still in an experimental phase. (Don't take this the wrong way :P ) On Sun, May 8, 2011 at 10:00 PM, Nicholas Goodman <ngo...@dy...>wrote: > On May 8, 2011, at 4:47 AM, rails.info info wrote: > > so, no update on this yet ? > > Dear Rails, > > Your parents, Mr and Mrs Info certainly arrived at an interesting given > name for you. :) The list is a volunteer group; one can't expect people > who generously give their time/advice/code away for free to respond to every > request on your timeline. People tend to respond to questions that interest > them. > > On Wed, May 4, 2011 at 10:44 AM, rails.info info <rai...@gm...>wrote: > >> How do you create a superuser for LucidDB. I've tried looking at >> http://pub.eigenbase.org/wiki/LucidDbGrant , but I'm not able to figure >> it out. >> > > Some of this is incomplete, as noted on the > http://www.luciddb.org/roadmap.html page. "security features incomplete" > is, however, not a great description of the state of it. Here's some more > info: > > As of 0.9.3 (which is the latest GA release) there is not a way to "enable > a role" via the SQL standard syntax. Much of that work has been completed > in 0.9.4 (which is now just entering release candidate phase). So, in 0.9.3 > all of our system views/procedures are granted to a role, DBA. There is > not, however a way to allow another user to enable that DBA role and gain > access to the privileges of that role. As an administrator, this seems > pretty lame I'm sure. > > In short, in 0.9.3, if you want to give a user Admin privileges you need to > use the existing super user (sa) and grant the new user all privs on all the > admin objects (kill_session, etc). In 0.9.4, a user can simply execute "set > role DBA" if they've been granted that role and get those privileges. > > Not, I'm betting, the answer anyone wants to hear (including the LucidDB > devs). However, 0.9.4 is coming and does improve this substantially! > > Nick > PS - BTW, John V. Sichi was the primary developer who did most of this > work! Even though he's departed the project and is no longer actively > contributing it's definitely worth thanking him for this work prior to his > departure! > > > ------------------------------------------------------------------------------ > WhatsUp Gold - Download Free Network Management Software > The most intuitive, comprehensive, and cost-effective network > management toolset available today. Delivers lowest initial > acquisition cost and overall TCO of any competing solution. > http://p.sf.net/sfu/whatsupgold-sd > _______________________________________________ > luciddb-users mailing list > luc...@li... > https://lists.sourceforge.net/lists/listinfo/luciddb-users > > |
|
From: Felipe I. <pli...@ho...> - 2011-05-10 01:25:47
|
Thanks Nick, i fell welcome already! That is not exactly what i needed, but I used it to get the data that I wanted, so Thank you very much man! Att. Felipe Issa. From: ngo...@dy... Date: Sun, 8 May 2011 10:12:12 -0700 To: luc...@li... Subject: Re: [luciddb-users] Disk Usage Feilpe - welcome to the community. On May 3, 2011, at 5:06 PM, Felipe Issa wrote:I'm doing a research on LucidDB, and I'd like to know if there is a way to determine how much space in disk LucidDB use to allocate a given schema.Yes, there is! It actually gives column by column and index by index allocated storage figures. Here's a query, that we are including in our upcoming release of our Admin tools to show such information: select table_schem as schema, table_name, index_name, pages*32/1024 as "SizeInMB" from sys_boot.jdbc_metadata.index_info_internal where table_schem = '<<your schema>>' order by 1,2,4 desc; NOTE: This requires current stats to produce any results, so prior to running this, you'll need to analyze your tables/schema (http://pub.eigenbase.org/wiki/AppLib_ESTIMATE_STATISTICS_FOR_SCHEMA) Anyway, thanks for your help!Of course! Let us know what you see and any further q's you might have about it! Kind Regards,Nick ------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ luciddb-users mailing list luc...@li... https://lists.sourceforge.net/lists/listinfo/luciddb-users |
|
From: Nicholas G. <ngo...@dy...> - 2011-05-08 20:06:33
|
On May 8, 2011, at 4:47 AM, rails.info info wrote: > so, no update on this yet ? Dear Rails, Your parents, Mr and Mrs Info certainly arrived at an interesting given name for you. :) The list is a volunteer group; one can't expect people who generously give their time/advice/code away for free to respond to every request on your timeline. People tend to respond to questions that interest them. > On Wed, May 4, 2011 at 10:44 AM, rails.info info <rai...@gm...> wrote: > How do you create a superuser for LucidDB. I've tried looking at http://pub.eigenbase.org/wiki/LucidDbGrant , but I'm not able to figure it out. Some of this is incomplete, as noted on the http://www.luciddb.org/roadmap.html page. "security features incomplete" is, however, not a great description of the state of it. Here's some more info: As of 0.9.3 (which is the latest GA release) there is not a way to "enable a role" via the SQL standard syntax. Much of that work has been completed in 0.9.4 (which is now just entering release candidate phase). So, in 0.9.3 all of our system views/procedures are granted to a role, DBA. There is not, however a way to allow another user to enable that DBA role and gain access to the privileges of that role. As an administrator, this seems pretty lame I'm sure. In short, in 0.9.3, if you want to give a user Admin privileges you need to use the existing super user (sa) and grant the new user all privs on all the admin objects (kill_session, etc). In 0.9.4, a user can simply execute "set role DBA" if they've been granted that role and get those privileges. Not, I'm betting, the answer anyone wants to hear (including the LucidDB devs). However, 0.9.4 is coming and does improve this substantially! Nick PS - BTW, John V. Sichi was the primary developer who did most of this work! Even though he's departed the project and is no longer actively contributing it's definitely worth thanking him for this work prior to his departure! |
|
From: Nicholas G. <ngo...@dy...> - 2011-05-08 17:43:55
|
Feilpe - welcome to the community. On May 3, 2011, at 5:06 PM, Felipe Issa wrote: > I'm doing a research on LucidDB, and I'd like to know if there is a way to determine how much space in disk LucidDB use to allocate a given schema. Yes, there is! It actually gives column by column and index by index allocated storage figures. Here's a query, that we are including in our upcoming release of our Admin tools to show such information: select table_schem as schema, table_name, index_name, pages*32/1024 as "SizeInMB" from sys_boot.jdbc_metadata.index_info_internal where table_schem = '<<your schema>>' order by 1,2,4 desc; NOTE: This requires current stats to produce any results, so prior to running this, you'll need to analyze your tables/schema (http://pub.eigenbase.org/wiki/AppLib_ESTIMATE_STATISTICS_FOR_SCHEMA) > Anyway, thanks for your help! Of course! Let us know what you see and any further q's you might have about it! Kind Regards, Nick |
17 messages has been excluded from this view by a project administrator.
