FiveTech Support Forums

hi,

is there a Tool or Website which can help me to optimize MySQL Server Settings :?:

for PostgreSQL you can use this Website
https://pgtune.leopard.in.ua/

Jimmy

Try with MySql administrator, it has that posinility.

Best regards

hi,

thx for Answer

when install MySQL with "default" Setting they are not "optimize"

Try with MySql administrator, it has that posinility.

i do NOT want to "optimize" Query & Co
i talk about System Variable in "c:\ProgramData\MySQL\MySQL Server 8.0\my.ini"

i have read about "MySQL Performance Tuning" and found e.g. these System Variable

innodb_buffer_pool_size
max_connection
query_cache_size
innodb_io_capacity
innodb_log_file_size

but which Value, depend of Hardware e.g. RAM :?:

the Website https://pgtune.leopard.in.ua/ give you Answer for PostgreSQL
i´m search for similar using MySQL