3 * @copyright Copyright (C) 2020, Friendica
5 * @license GNU AGPL version 3 or any later version
7 * This program is free software: you can redistribute it and/or modify
8 * it under the terms of the GNU Affero General Public License as
9 * published by the Free Software Foundation, either version 3 of the
10 * License, or (at your option) any later version.
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU Affero General Public License for more details.
17 * You should have received a copy of the GNU Affero General Public License
18 * along with this program. If not, see <https://www.gnu.org/licenses/>.
22 namespace Friendica\Worker;
24 use Friendica\Core\Logger;
25 use Friendica\Database\DBA;
27 use Friendica\Model\Photo;
28 use Friendica\Util\Proxy as ProxyUtils;
35 public static function execute()
38 $last = DI::config()->get('system', 'cache_last_cleared');
41 $next = $last + (3600); // Once per hour
42 $clear_cache = ($next <= time());
54 // clear old item cache files
57 // clear cache for photos
58 clear_cache($a->getBasePath(), $a->getBasePath() . "/photo");
61 clear_cache($a->getBasePath() . "/view/smarty3/compiled", $a->getBasePath() . "/view/smarty3/compiled");
63 // clear cache for image proxy
64 if (!DI::config()->get("system", "proxy_disabled")) {
65 clear_cache($a->getBasePath(), $a->getBasePath() . "/proxy");
67 $cachetime = DI::config()->get('system', 'proxy_cache_time');
70 $cachetime = ProxyUtils::DEFAULT_TIME;
73 $condition = ['`uid` = 0 AND `resource-id` LIKE "pic:%" AND `created` < NOW() - INTERVAL ? SECOND', $cachetime];
74 Photo::delete($condition);
77 // Delete the cached OEmbed entries that are older than three month
78 DBA::delete('oembed', ["`created` < NOW() - INTERVAL 3 MONTH"]);
80 // Delete the cached "parse_url" entries that are older than three month
81 DBA::delete('parsed_url', ["`created` < NOW() - INTERVAL 3 MONTH"]);
83 if (DI::config()->get('system', 'optimize_tables')) {
84 Logger::info('Optimize start');
85 DBA::e("OPTIMIZE TABLE `auth_codes`");
86 DBA::e("OPTIMIZE TABLE `cache`");
87 DBA::e("OPTIMIZE TABLE `challenge`");
88 DBA::e("OPTIMIZE TABLE `locks`");
89 DBA::e("OPTIMIZE TABLE `oembed`");
90 DBA::e("OPTIMIZE TABLE `parsed_url`");
91 DBA::e("OPTIMIZE TABLE `profile_check`");
92 DBA::e("OPTIMIZE TABLE `session`");
93 DBA::e("OPTIMIZE TABLE `tokens`");
94 Logger::info('Optimize finished');
97 DI::config()->set('system', 'cache_last_cleared', time());