MySQL Forums
Forum List  »  Performance

my.cnf file config
Posted by: Geovanny Jimenez
Date: January 02, 2019 02:16PM

Hello everyone, please I need help in a project of the U, it turns out that I have a database of 200M,
in a VPS of 4vcore, 24gb of ram, 100Gb of hdd, n mysql 8.0.13, but with all these features the
view that has delay 13s, in executing 87 thousand records, I read that I must tune the file my.cnf, but never done
maybe you can help me with this please ..

the same view query I run on a base of 2vcore and 4gb of ram that believes in AWS, and there the queries to it
view delay 3s.

I thank you in advance for your support and help guiding me, which is what I should do and what should I put in the file my.cnf

Options: ReplyQuote


Subject
Views
Written By
Posted
my.cnf file config
415
January 02, 2019 02:16PM
187
January 02, 2019 02:35PM


Sorry, only registered users may post in this forum.

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.