Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revision Both sides next revision | ||
documentation:2.1:browseablesessionbackend [2019/06/11 18:44] xguimard |
documentation:2.1:browseablesessionbackend [2019/06/28 14:32] maxbes |
||
---|---|---|---|
Line 12: | Line 12: | ||
^ Feature ^ Fields to index ^ | ^ Feature ^ Fields to index ^ | ||
| Database cleanup //(cron)// | _session_kind _utime | | | Database cleanup //(cron)// | _session_kind _utime | | ||
- | | Session explorer | _session_kind ipAddr _utime //WHATTOTRACE// | | + | | Session explorer | _session_kind ipAddr //WHATTOTRACE// | |
| Session explorer (persistent sessions) | _session_kind _session_uid | | | Session explorer (persistent sessions) | _session_kind _session_uid | | ||
| Session restrictions | _session_kind ipAddr //WHATTOTRACE// | | | Session restrictions | _session_kind ipAddr //WHATTOTRACE// | | ||
Line 52: | Line 52: | ||
CREATE UNLOGGED TABLE sessions ( | CREATE UNLOGGED TABLE sessions ( | ||
- | id varchar(64) not null primary key, | + | id varchar(64) not null primary key, |
- | a_session text, | + | a_session text, |
- | _whatToTrace text, | + | _whatToTrace text, |
- | _session_kind text, | + | _session_kind text, |
- | _utime bigint, | + | _utime bigint, |
- | _httpSessionType text, | + | _httpSessionType text, |
- | user text, | + | ipAddr text |
- | ipAddr text | + | |
); | ); | ||
- | CREATE INDEX uid1 ON sessions USING BTREE (_whatToTrace); | + | CREATE INDEX uid1 ON sessions USING BTREE (_whatToTrace text_pattern_ops); |
CREATE INDEX s1 ON sessions (_session_kind); | CREATE INDEX s1 ON sessions (_session_kind); | ||
CREATE INDEX u1 ON sessions (_utime); | CREATE INDEX u1 ON sessions (_utime); | ||
CREATE INDEX ip1 ON sessions USING BTREE (ipAddr); | CREATE INDEX ip1 ON sessions USING BTREE (ipAddr); | ||
CREATE INDEX h1 ON sessions (_httpSessionType); | CREATE INDEX h1 ON sessions (_httpSessionType); | ||
- | |||
<note important>For Session Explorer and one-off sessions, it is recommended to use BTREE or any index method that indexes partial content.</note> | <note important>For Session Explorer and one-off sessions, it is recommended to use BTREE or any index method that indexes partial content.</note> | ||
Line 80: | Line 78: | ||
^ Required parameters ^^^ | ^ Required parameters ^^^ | ||
^ Name ^ Comment ^ Example ^ | ^ Name ^ Comment ^ Example ^ | ||
- | | **DataSource** | The [[https://metacpan.org/pod/DBI|DBI]] string | dbi:Pg:database=sessions | | + | | **DataSource** | The [[https://metacpan.org/pod/DBI|DBI]] string | dbi:Pg:database=lemonldap-ng | |
| **UserName** | The database username | lemonldapng | | | **UserName** | The database username | lemonldapng | | ||
| **Password** | The database password | mysuperpassword | | | **Password** | The database password | mysuperpassword | | ||
- | | **Index** | Index | _whatToTrace ipAddr _session_kind _utime | | + | | **Index** | Index | _whatToTrace ipAddr _session_kind _utime _httpSessionType | |
+ | | **TableName** | Table name (optional) | sessions | | ||
<note tip>Apache::Session::Browseable::MySQL doesn't use locks so performances are keeped. | <note tip>Apache::Session::Browseable::MySQL doesn't use locks so performances are keeped. | ||
Line 127: | Line 126: | ||
_session_kind text, | _session_kind text, | ||
_utime bigint, | _utime bigint, | ||
- | user text, | + | _httpSessionType text, |
- | ipAddr varchar(64) | + | ipAddr text |
); | ); | ||
CREATE INDEX uid1 ON sessions USING BTREE (_whatToTrace text_pattern_ops); | CREATE INDEX uid1 ON sessions USING BTREE (_whatToTrace text_pattern_ops); | ||
- | CREATE INDEX _s1 ON sessions (_session_kind); | + | CREATE INDEX s1 ON sessions (_session_kind); |
- | CREATE INDEX _u1 ON sessions (_utime); | + | CREATE INDEX u1 ON sessions (_utime); |
- | CREATE INDEX ip1 ON sessions USING BTREE (ipAddr) | + | CREATE INDEX ip1 ON sessions USING BTREE (ipAddr); |
+ | CREATE INDEX h1 ON sessions (_httpSessionType); | ||
**Browseable::MySQL**: | **Browseable::MySQL**: |