Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Yes, this is normal. The CI session class automatically generates a new ID periodically. (Every 5 minutes, by default.) This is part of the security inherent in using CI sessions instead of native PHP sessions. Garbage collection will take care of this, you do not need to do anything.</p> <p>You can read more about the session id behavior in the <a href="http://ellislab.com/codeigniter/user-guide/libraries/sessions.html" rel="nofollow">CI manual</a>. This is an excerpt copied from that page.</p> <blockquote> <p>The user's unique Session ID (this is a statistically random string with very strong entropy, hashed with MD5 for portability, and regenerated (by default) every five minutes)</p> </blockquote> <p>This behavior is by design. There is nothing to fix. The session class has built in garbage collection that deletes old entries as needed. I have many projects using code igniter for several years. This is what it does. </p> <p>If it really bothers you, you can alter the timeout in the main CI config file. Change the line </p> <blockquote> <p>$config['sess_time_to_update'] = 300 (the 5 minute refresh period)</p> </blockquote> <p>to a number greater than </p> <blockquote> <p>$config['sess_expiration'] (default 7200)</p> </blockquote> <p>This will cause the session to timeout before it is regenerated. This is inherently less secure in theory, but unless you are transacting sensitive data, it is probably irrelevant in practice.</p> <p>But again, this is by design as part of the many layers of CI sessions. These and other features are what make it better than PHP native sessions. You can turn on profiling and see that the overhead for these queries is negligible, especially in light of all the other optimizations the framework provides. </p>
    singulars
    1. This table or related slice is empty.
    1. POPyroCMS / Codeigniter : too many session entries in db
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UScolonelclick
    1. UScolonelclick
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPyroCMS / Codeigniter : too many session entries in db
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThe manual doesn't mention anything about the 5 minute update nor the id behavior. But, looking at the [source](https://github.com/EllisLab/CodeIgniter/blob/develop/system/libraries/Session/drivers/Session_cookie.php#L520) it looks like it does regenerate every 5 minutes, but also looks like it tries to update the existing session if match ip and/or match user agent is set. Think this would fix the dupe entries?
      singulars
      1. PO
      1. USstormdrain
    2. COlengthened my answer to take into account your comments
      singulars
      1. PO
      1. UScolonelclick
    3. COI have one little blind spot in my left eye...that must have been where that line was ;) Thanks for expanding your answer.
      singulars
      1. PO
      1. USstormdrain
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload