About SRGTechnical ArticlesRecruitment Information
About SRGTechnical ArticlesRecruitment Information
HOME/Technical Articles/Will chatGPT put MySQL guys out of work?

Will chatGPT put MySQL guys out of work?

This is Oniumi (@fat47) from the Service Reliability Group (SRG) of the Technology Headquarters.
#SRG(Service Reliability Group) is a group that mainly provides cross-sectional support for the infrastructure of our media services, improving existing services, launching new ones, and contributing to OSS.
This article is located in SRGDBWGWe will publish materials regarding the database provided by the DB Working Group for the entire company.
I hope this helps in some way.
 

Introduction

I'm sorry for the big title that seems to be following the trend.
In this article, we will provide the contents of my.cnf to ChatGPT and BingAI to get advice on tuning the settings, and consider how practical it is at this point.
💡
With chatGPT and other programs, your input may be used for training purposes. Please do not enter personal or confidential information.
 

Question

"Below is the my.cnf configuration file I'm using with MySQL 5.7. Please let me know any issues you might have. Please ask any questions you need additional information to help me achieve the best results with this task."
 

Traps scattered in the configuration file

The following are parameters that I would be happy if the AI could point out to me if there are any configuration errors.
Setting item nameexplanation
If the buffer_pool is large, it is advisable to split it.
It's on by default, but I've disabled it.
It is always ON from MySQL5.7.10 onwards.
Barracuda is the default from MySQL 5.7. Deprecated parameter in MySQL 5.7.
A setting that reduces the frequency of writing to the InnoDB log.
utf8mb4 is preferred over utf8 (utf8mb3).
 

answer

chatGPT free version (GPT-3.5)

Seven points pointed out
query_cache_size=0
innodb_buffer_pool_instances

Bing AI(GPT-4)

Seven points pointed out
query_cache_size=0
It seems good that it also provides recommended setting values for other items as a reference.

ChatGPT Plus(GPT-4)

10 points pointed out.
query_cache_size=0
There is a lot of information about other topics as well.
In fact, I was advised to use something newer than MySQL 5.7 (lol)
 

Comparison table after trying three

×= No comments were made about the item
△= There was a comment about the item, but I'm not sure if the content is correct.
○= There are some points to be pointed out and the content seems to be generally correct.
Setting item namechatGPT(GPT-3.5)BingAI(GPT-4)ChatGPT Plus(GPT-4)
innodb_buffer_pool_instances = 1×○○
innodb_doublewrite=0○○○
innodb_support_xa = OFF△△△
innodb_file_format×××
innodb_flush_log_at_trx_commit = 0○○○
character-set-server = utf8×××
innodb_support_xa
innodb_file_format
character-set-server = utf8

Conclusion

After trying it out this time, I found that the points it pointed out were lacking in some areas, but I thought that there could be situations where it could be useful as a starting point for tuning.
At the moment, it seems like the knowledge of MySQL Uncle will still be necessary, so that's a relief (?), but I'm looking forward to the future evolution of AI.
 
SRG is looking for people to work with us. If you're interested, please contact us here.