Hi
@Michael 🇺🇦Thanks for your help and clarifications , I appreciate it very much .
I have had friedica installed on my server for over a year and a half (single user) the database has increased a lot , 3 days ago it was much much more , I disabled some things in the admin panel and now it's
+--------------------+-----------+
| Database | Size (MB) |
+--------------------+-----------+
| friendica | 27020.36 |
I have already done some database tuning in the past,but I'll take a look at it , I think there is something wrong with some tuning
>> MySQLTuner 2.6.0
* Jean-Marie Renouard <
[email protected]>
* Major Hayden <
[email protected]>
>> Bug reports, feature requests, and downloads at
http://mysqltuner.pl/ >> Run with '--help' for additional options and output filtering
[--] Skipped version check for MySQLTuner script
[OK] Logged in using credentials from Debian maintenance account.
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE
[--] Data in InnoDB tables: 26.4G (Tables: 90)
[--] Data in MEMORY tables: 2.6M (Tables: 3)
[--] Data in Aria tables: 32.0K (Tables: 1)
[OK] Total fragmented tables: 0
[OK] Currently running supported MySQL version 10.11.13-MariaDB-0ubuntu0.24.04.1
-------- Log file Recommendations ------------------------------------------------------------------
[!!] Log file doesn't exist
-------- Analysis Performance Metrics --------------------------------------------------------------
[--] innodb_stats_on_metadata: OFF
[OK] No stat updates during querying INFORMATION_SCHEMA.
-------- Views Metrics -----------------------------------------------------------------------------
-------- Triggers Metrics --------------------------------------------------------------------------
-------- Routines Metrics --------------------------------------------------------------------------
-------- Security Recommendations ------------------------------------------------------------------
[OK] There are no anonymous accounts for any database users
[OK] All database users have passwords assigned
[!!] There is no basic password file list!
-------- CVE Security Recommendations --------------------------------------------------------------
[--] Skipped due to --cvefile option undefined
-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 17m 42s (157K q [147.952 qps], 1K conn, TX: 331M, RX: 19M)
[--] Reads / Writes: 93% / 7%
[--] Binary logging is disabled
[--] Physical Memory : 11.7G
[--] Max MySQL memory : 11.1G
[--] Other process memory: 0B
[--] Total buffers: 8.3G global + 2.7M per thread (1000 max threads)
[--] Performance_schema Max memory usage: 147M
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 8.5G (72.48% of installed RAM)
[!!] Maximum possible memory usage: 11.1G (94.65% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (0/157K)
[OK] Highest usage of available connections: 1% (15/1000)
[OK] Aborted connections: 0.00% (0/1090)
[OK] Query cache is disabled by default due to mutex contention on multiprocessor machines.
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 8K sorts)
[!!] Joins performed without indexes: 228
[OK] Temporary tables created on disk: 6% (478 on disk / 7K total)
[OK] Thread cache hit rate: 98% (15 created / 1K connections)
[OK] Table cache hit rate: 93% (461K hits / 492K requests)
[OK] table_definition_cache (500) is greater than number of tables (413)
[OK] Open file limit used: 0% (62/32K)
[OK] Table locks acquired immediately: 100% (11K immediate / 11K locks)
-------- Performance schema ------------------------------------------------------------------------
[--] Performance_schema is activated.
[--] Memory used by Performance_schema: 147.5M
[--] Sys schema is installed.
-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.
-------- MyISAM Metrics ----------------------------------------------------------------------------
[--] General MyIsam metrics:
[--] +-- Total MyISAM Tables : 0
[--] +-- Total MyISAM indexes : 0B
[--] +-- KB Size :128.0M
[--] +-- KB Used Size :23.3M
[--] +-- KB used :18.2%
[--] +-- Read KB hit rate: 0% (0 cached / 0 reads)
[--] +-- Write KB hit rate: 0% (0 cached / 0 writes)
[--] No MyISAM table(s) detected ....
-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[OK] InnoDB File per table is activated
[OK] InnoDB Buffer Pool size ( 8.0G ) under limit for 64 bits architecture: (17179869184.0G )
[!!] InnoDB buffer pool / data size: 8.0G / 26.4G
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 2.0G * 1/8.0G should be equal to 25%
Illegal division by zero at ./mysqltuner.pl line 6550 (
#1)
(F) You tried to divide a number by 0. Either something was wrong in
your logic, or you need to put a conditional in to guard against
meaningless input.
Uncaught exception from user code:
Illegal division by zero at ./mysqltuner.pl line 6550.
main::mysql_innodb() called at ./mysqltuner.pl line 7417
Is it possible for you to switch to the release candidate?
Sure ,please can you post the link of the release candidate? I tried to search for it but I didn't find it
