optimize MySQL Server Configuration

optimize MySQL Server Configuration

Postby Jimmy » Wed Mar 22, 2023 9:16 am

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/
greeting,
Jimmy
User avatar
Jimmy
 
Posts: 1725
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany

Re: optimize MySQL Server Configuration

Postby Armando » Wed Mar 22, 2023 11:15 pm

Jimmy

Try with MySql administrator, it has that posinility.

Best regards
SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero
User avatar
Armando
 
Posts: 3201
Joined: Fri Oct 07, 2005 8:20 pm
Location: Toluca, México

Re: optimize MySQL Server Configuration

Postby Jimmy » Fri Mar 24, 2023 8:35 am

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
greeting,
Jimmy
User avatar
Jimmy
 
Posts: 1725
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 23 guests