How to clean up all data chats, full_chats which stored at session.madeline.safe.php

[sergeibochkarev]

My MadelineProto has been get a lot of RAMs
And file session.madeline.safe.php is 1.2GiB
How I can clean any data, save only my authorization data?

Thank you.

[sergeibochkarev]

I toggle DB settings to MySQL, but any way memory used too much

[danog]

To fix the mysql error, run SET GLOBAL max_connections = 10000000;

[sergeibochkarev]

One of my workes is now freezing more than 1 hour

In MadelineProto.log

Can you tell me what's wrong?

[sergeibochkarev]

        $settings = (new Settings())
            ->setDb($this->getDbSettings())
            ->setSerialization((new Serialization())->setInterval(300))
            ->setLogger(
                (new LoggerSettings())
                    ->setLevel(MadelineProtoLogger::LEVEL_ERROR)
                    ->setExtra(null)
            );

        $this->toLog("new API");
// still here
        $this->madelineProto = new API('session.madeline', $settings);
// do not reach this line
        $this->madelineProto->updateSettings($settings);
        $this->madelineProto->start();

         $this->toLog("set MySQL DB");
         
         private function getDbSettings()
         {
            return (new Mysql())
                ->setUri($this->configParams['mysql']['uri'])
                ->setUsername($this->configParams['mysql']['username'])
                ->setPassword($this->configParams['mysql']['password'])
                ->setDatabase($this->configParams['mysql']['database']);

[sergeibochkarev]

Now in log

[danog]

OK this is normal, MadelineProto will not reply to requests until the session is fully loaded into the database (this will only happen once when the worker starts, another reason to avoid killing it).