About SRGArticlesRecruitment Information
About SRGArticlesRecruitment Information
HOME/Articles/Will the emergence of chatGPT take away the jobs of MySQL dudes?

Will the emergence of chatGPT take away the jobs of MySQL dudes?

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

Introduction

I'm sorry for the big, trendy title.
In this article, I would like to provide the contents of my.cnf to ChatGPT, BingAI, etc., and ask them for advice on tuning the settings, and consider how practical it is at this point.
💡
For chatGPT and other apps, the information you enter may be used for training purposes. Please avoid entering personal or confidential information.
 

Question

"Below is the my.cnf configuration file I'm using for MySQL 5.7. Please let me know any areas that might be problematic. Please ask questions if you need any additional information to best accomplish this task."
 

Traps scattered in configuration files

The parameters that I would be happy if the AI could point out to me if there were any configuration errors are listed below.
Setting item nameexplanation
If the buffer_pool is large, it is advisable to split it.
It's ON by default, but I have it disabled.
It is always ON from MySQL 5.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 well.

ChatGPT Plus(GPT-4)

10 items pointed out.
query_cache_size=0
There is a lot of information on other topics too.
In fact, I was advised to use something newer than MySQL 5.7 (laughs).
 

Comparison table after trying three

×= No comments were made about the item
△= There was a comment on the item, but I'm not sure if the content is correct.
○= There are some points to note 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 left something to be desired, but I also thought that there could be situations where it could be useful as a starting point for tuning.
At this point, it seems that 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 are interested, please contact us here.