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