*** dyki has joined #ingres | 01:19 | |
*** grantc has joined #ingres | 01:29 | |
*** ChanServ sets mode: +o grantc | 01:29 | |
*** atrofast has joined #ingres | 03:11 | |
pboro | I had never thought about this... but it looks pretty cool: http://developers.sun.com/learning/javaoneonline/sessions/2009/pdf/TS-4904.pdf | 03:11 |
---|---|---|
thiagomz | Guys, on imadb how can I known if a session is active ? | 05:23 |
thiagomz | that means .. it is processing.... and not IDEL | 05:23 |
thiagomz | IDLE | 05:24 |
thiagomz | ima_server_sessions_extra | 05:24 |
thiagomz | session_state <> of what ? | 05:24 |
*** rossand has joined #ingres | 05:27 | |
*** ChanServ sets mode: +o rossand | 05:27 | |
magnusg| | thiagomz, a typical idle session has session_state = CS_EVENT_WAIT and session_wait_reason = BIOR | 05:29 |
thiagomz | magnusg|: tkz | 05:30 |
magnusg| | most other combinations of session_state and session_wait_reason shows some kind of activity or possibly a problem such as waiting for mutex | 05:32 |
thiagomz | my server is with a high cpu utilization... i wanna known who are my users using cpu.... | 05:32 |
thiagomz | anyone has a SQL query to identify active sessions ? | 05:33 |
magnusg| | We use ima to monitor session activity | 05:34 |
thiagomz | magnusg|: how ? | 05:34 |
magnusg| | First I'd like to point to the column session_cpu in ima_server_sessions_extra. When it works it gives information which is useful. Problem is that it only works on limited platforms/versions. It works on windows but fior the rest you need a fix for bug 119586 | 05:38 |
thiagomz | magnusg|: I am using ingres 2.6, and i do haven´t that collumn :-( | 05:42 |
magnusg| | We collect information about sessions from ima_server_sessions ,ima_server_sessions_extra and ima_log_transactions every tenth second or so, stores the information in a tables and run reports where we calculate different states, how long sessions been in that state etc | 05:43 |
magnusg| | It's a C-program we wrote for a customer a year ago. | 05:43 |
magnusg| | What operating system are you using? | 05:44 |
thiagomz | rhel 4.6 64bit | 05:45 |
thiagomz | Linux sel-dip-01.sev.intra 2.6.9-67.ELlargesmp #1 SMP Wed Nov 7 14:07:22 EST 2007 x86_64 x86_64 x86_64 GNU/Linux | 05:46 |
magnusg| | OK, I thought that if you were on windows it might have been worth while to get a later version of the imadb database in case the underlying structure which ima_server_sessions_extra is using were in place. But on Linux it doesn't work. | 05:47 |
thiagomz | is possible update my imadb from a new version of ingres ? | 05:49 |
magnusg| | In some cases yes | 05:50 |
thiagomz | humm... | 05:50 |
magnusg| | The definitions in imadb relies on underlying structures sometimes they are in place even there is no imadb table/column defined. | 05:54 |
*** Alex| is now known as Alex|off | 06:01 | |
*** cthibert has joined #ingres | 06:05 | |
thiagomz | magnusg|: do you known how to exclude myself from my query result ? http://pastebin.com/m75243d41 | 06:07 |
thiagomz | i mean... my own session | 06:11 |
magnusg| | I would suggest either where a.db_name <> 'imadb' or where a.db_name = 'The_DB_users_are_using' | 06:14 |
magnusg| | You might also want to use where a.db_name <> '' to get rid of system threads | 06:15 |
thiagomz | good answer... i was thinking i a complex way ...hehehe... | 06:18 |
thiagomz | ;) | 06:20 |
thiagomz | guys, i was monitoring my dbms´s ... and i always have insert into session.XXXX update session.XXXXX, what can be ajusted to comport a lot of operations in temporary tables ? dmf cache ? sort area ? | 06:57 |
*** DerMeister has joined #ingres | 07:12 | |
*** Alex|off is now known as Alex| | 07:40 | |
*** Alex| is now known as Alex|off | 07:43 | |
atrofast | Alex|off: ping | 07:48 |
*** Alex|off is now known as Alex| | 07:55 | |
atrofast | Alex|: Would it be possible for you to create a user i nthe community LDAP that has @ in the username? I've tried from the web form but it doesn't let me | 08:07 |
Alex| | email addresses are no longer allowed as names | 08:08 |
atrofast | But there are still users that have it and I suspect it is causing issues with review board | 08:15 |
Alex| | there are still many out there, rtight | 08:17 |
Alex| | right | 08:18 |
Alex| | but no new users can be created... | 08:18 |
atrofast | Ah but I need one to debug :) | 08:18 |
atrofast | Can't one be directly written to the LDAP? | 08:18 |
Alex| | you can create the user in ldap directly but Im not sure if you can log in then because that would mean adding him to the forum as well, which is not allowed..... | 08:18 |
atrofast | I only need it in the ldap, reviewboard just queries uid, and mail attributes | 08:21 |
Alex| | easiest thing is to copy an existing ldap user to another name | 08:22 |
*** dyki has quit IRC | 08:29 | |
*** Deyan has joined #ingres | 08:31 | |
Deyan | hellloooo | 08:32 |
Deyan | grantc: you got a kudos from me on Ohloh ;D | 08:32 |
grantc | Hi Deyan, oh really? thanks | 08:32 |
Deyan | yeah mate | 08:32 |
Deyan | :D | 08:32 |
*** Deyan has quit IRC | 08:37 | |
*** magnusg| has quit IRC | 08:56 | |
*** Alex| is now known as Alex|off | 09:20 | |
*** Alex|off is now known as Alex| | 09:30 | |
*** rossand has quit IRC | 10:29 | |
*** mull has joined #ingres | 12:04 | |
*** Alex| is now known as Alex|off | 12:07 | |
thiagomz | see you guys on monday... cya ! | 12:57 |
*** thiagomz has quit IRC | 12:57 | |
*** rossand has joined #ingres | 13:22 | |
*** ChanServ sets mode: +o rossand | 13:22 | |
*** cthibert has left #ingres | 13:29 | |
*** mull has quit IRC | 14:03 | |
*** DerMeister has quit IRC | 14:06 | |
*** FrankW has joined #ingres | 14:32 | |
*** grantc has quit IRC | 15:20 | |
*** FrankW has quit IRC | 15:41 | |
*** rossand has quit IRC | 17:26 | |
*** toumi01 has left #ingres | 19:07 | |
*** rossand has joined #ingres | 19:32 | |
*** ChanServ sets mode: +o rossand | 19:32 | |
*** omega187 has joined #ingres | 20:22 | |
*** rossand has quit IRC | 20:58 | |
*** Alex|off is now known as Alex| | 23:15 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!