Database optimize

database laravel English

Draft Disclaimer: Please note that this article is currently in draft form and may undergo revisions before final publication. The content, including information, opinions, and recommendations, is subject to change and may not represent the final version. We appreciate your understanding and patience as we work to refine and improve the quality of this article. Your feedback is valuable in shaping the final release.

Language Mismatch Disclaimer: Please be aware that the language of this article may not match the language settings of your browser or device.
Do you want to read articles in English instead ?

DB Optimize kill the php process - queue job show full processlist; kill the mysql query process kill <process> exclude table that was optimized

  • woke up to application being down on a friday morning
  • I guess better than deploy on friday evening
  • What is DB optimize
  • as the name suggest, optimize your DB
  • optimized DB means better performance
  • how does it work
  • which tables to optimize vs exclude
  • exclude anything above close to 10M rows
  • optimize query table how
  • wrap up
    • bigger DB, slower queries
    • archive yearly data to different cluster, separate DB or offline backup of archive in case the need
Babacar Cissé DIA
By on

A Solutions Architect and Developer who thrives on crafting digital solutions. Passionate about learning and innovation, he sees challenges as opportunities to build secure, responsive, high-quality applications that drive business growth through cutting-edge technology. His blog serves as a tech memoir, documenting his coding journey and sharing insights into software architecture. It’s a blend of lessons, musings, and tech expertise, providing a glimpse into the art of crafting solutions in an ever-evolving digital landscape.