Re: MySQL 8 development hardware - innoDB, win, complex queries

[Peter Brawley]

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.