FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour optimize MySQL Server Configuration
Posts: 1772
Joined: Thu Sep 05, 2019 05:32 AM
optimize MySQL Server Configuration
Posted: Wed Mar 22, 2023 09: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
Posts: 3358
Joined: Fri Oct 07, 2005 08:20 PM
Re: optimize MySQL Server Configuration
Posted: 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
Posts: 1772
Joined: Thu Sep 05, 2019 05:32 AM
Re: optimize MySQL Server Configuration
Posted: Fri Mar 24, 2023 08: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

Continue the discussion