MySQL Forums
Forum List  »  Performance

Re: MySQL 8 development hardware - innoDB, win, complex queries
Posted by: Peter Brawley
Date: March 02, 2022 10:12AM

Your slow processes are telling you that MySQL needs tuning and/or some queries need optimising.

For a 2G db, that laptop spec looks adequate, but before jumping to a new laptop I'd want to tune MySQL and fix the slow queries. For the formar see "Optimisation cheatsheet" at https://www.artfulsoftware.com/infotree/mysqltips.php, and for the latter turn on the slow query log, run Explain Analyze on the slow queries it identifies, optimise those queries, post here if you get stuck.



Edited 1 time(s). Last edit at 03/02/2022 05:18PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 8 development hardware - innoDB, win, complex queries
106
March 02, 2022 10:12AM


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.