Jimmi08
commented
1 month ago Hi, it was discussed on gitter some time ago. A session record is created for boots too. I reported it. Not sure if an issue was created. it is around Thu, May 11, 2023 , you can look for word sessions. I am copying solution by @Deltik :
Although there currently isn't a way to clean up guest sessions sooner, you could create a cron job script like this:
<?php
require_once('e107_config.php');
$gc_maxlifetime = (int)ini_get('session.gc_maxlifetime');
if (!$gc_maxlifetime) {
$gc_maxlifetime = 3600;
}
$expiration_time = time() - $gc_maxlifetime + 3600; // One hour
$dsn = "mysql:host=$mySQLserver;dbname=$mySQLdefaultdb;charset=$mySQLcharset";
$pdo = new PDO($dsn, $mySQLuser, $mySQLpassword);
$table_name = $mySQLprefix . "session";
$query = "DELETE FROM `$table_name` WHERE (session_user = 0 OR session_user IS NULL) AND session_expires < $expiration_time LIMIT 1000";
$total_deleted = 0;
do {
$stmt = $pdo->prepare($query);
$stmt->execute();
$deleted_rows = $stmt->rowCount();
$total_deleted += $deleted_rows;
} while ($deleted_rows > 0);
echo "Deleted " . $total_deleted . " rows from the $table_name table.\n";(I haven't tested it myself, but it should delete guest sessions older than 1 hour.)
ericc-dream
rica-carv
Moc
Alex-e107nl
CaMer0n
Deltik
Question
Hi
I have a question. I'm moving my site to some different hosting and I noted something "annoying" When I exported my database from the server of my old hosting, it had a size of around 8Mb give or take I restored everything less than 1 week ago, and today I tried to export it again , and the size is now 25Mb !!! more than 3 times ... more specifically the table e107_session is now more than 17Mb alone ! I had 6 rows inside, I have now 17334 ... and 17333 have "session_user = 0"
I wonder, do you store the session ID for every visitor of the site in this table ? it's a little bit too much ... taking into account that I have only 2 users on my site, including myself How can I limit, reduce that ?
I see a lot of bots hitting my site and crawling in the forum, mainly from "semrush" I guess that they are the reason of the explosion of my database Do I have a simple way to block this bot(s) ?
In a more general question : When I export my database , is there some tables that I can exclude ? If a table doesn't exist, is the code able to recreate it ? (I can export the "CREATE" but not the content eventually)
Expected Source
I checked the content of the current DB with the previous export
Additional Context
No response