Re: server on development machine
Posted by: Kimber Barton
Date: June 30, 2021 11:30AM

Thanks again. When I try to edit the options file from workbench, I got the following error:
Location of MySQL configuration file (ie: my.cnf) not specified
All options such as "Locate option" are grayed out

So I used trusty google and found out how to tell workbench where it is and did that.

(On my machine, the my.ini file is located at:
C:/ProgramData/MySQL/MySQL Server 8.0)

Restarted the server and now I get the following error when trying to open the options file in workbench:

Error opening configuration file
UnicodeDecodeError: ‘charmap’ codec can’t decode byte 0x9d in position 4329: character maps to <undefined>

From looking online the 0x9d character is the "smart" single quote in windows. But there are no single quotes in my.ini.

Once I "ok" this error, it does open the my.ini file.

But, I do not see innodb_buffer_pool_size there at all. I do see innodb_buffer_pool_chunk_size. I also do not see innodb_buffer_pool_instances.

Thanks again for all your help.

Options: ReplyQuote

Written By
Re: server on development machine
June 30, 2021 11:30AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.