mysql - ghdrako/doc_snipets GitHub Wiki

• https://proxysql.com/

• https://github.com/github/gh-ost

• https://scalegrid.io/blog/mysql-point-in-time-recovery/

Trade-off

• Dropping a table takes a global lock that prevents the execution of ANY QUERY until the underlying files for the table are removed from the filesystem. Under many circumstances
• There's no way to enforce that clients will only use SQL strict mode. You have to trust your clients. According to the manual, if client A does stuff with strict mode on and client B does stuff with strict mode off, data corruption will occur.