X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FDatabase%2FDBA.php;h=0c0fd0f80d30839cf94261d08dfee5a0f9a63334;hb=3f2b0b9422915529a0ea585aa4325b6d2f2f65cd;hp=d609f108ebf0626506b28d251b99dabfb2de7706;hpb=c4c80ed3cce6d11a4350b62ee055da9160a2fdfd;p=friendica.git diff --git a/src/Database/DBA.php b/src/Database/DBA.php index d609f108eb..0c0fd0f80d 100644 --- a/src/Database/DBA.php +++ b/src/Database/DBA.php @@ -42,6 +42,11 @@ class DBA */ const NULL_DATETIME = '0001-01-01 00:00:00'; + /** + * Lowest possible datetime(6) value + */ + const NULL_DATETIME6 = '0001-01-01 00:00:00.000000'; + public static function connect(): bool { return DI::dba()->connect(); @@ -821,6 +826,27 @@ class DBA return DI::dba()->processlist(); } + /** + * Optimizes tables + * + * @param string $table a given table + * + * @return bool True, if successfully optimized, otherwise false + * @throws \Exception + */ + public static function optimizeTable(string $table): bool + { + return DI::dba()->optimizeTable($table); + } + + /** + * Kill sleeping database processes + */ + public static function deleteSleepingProcesses() + { + DI::dba()->deleteSleepingProcesses(); + } + /** * Fetch a database variable *