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
1627
January 02, 2019 02:16PM
611
January 02, 2019 02:35PM


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.