mysql · php開發筆記

[mysql聯合索引(復合索引)詳解](mysql%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E5%A4%8D%E5%90%88%E7%B4%A2%E5%BC%95%E8%AF%A6%E8%A7%A3.md) [MYSQL 清空表和截斷表](MYSQL%E6%B8%85%E7%A9%BA%E8%A1%A8%E5%92%8C%E6%88%AA%E6%96%AD%E8%A1%A8.md) [MySQL快速生成大量測試數據（100萬、1000萬、1億）](MySQL%E5%BF%AB%E9%80%9F%E7%94%9F%E6%88%90%E5%A4%A7%E9%87%8F%E6%B5%8B%E8%AF%95%E6%95%B0%E6%8D%AE%EF%BC%88100%E4%B8%87%E3%80%811000%E4%B8%87%E3%80%811%E4%BA%BF%EF%BC%89.md) [提高mysql千萬級大數據SQL查詢優化30條經驗（Mysql索引優化注意）](%E6%8F%90%E9%AB%98mysql%E5%8D%83%E4%B8%87%E7%BA%A7%E5%A4%A7%E6%95%B0%E6%8D%AESQL%E6%9F%A5%E8%AF%A2%E4%BC%98%E5%8C%9630%E6%9D%A1%E7%BB%8F%E9%AA%8C%EF%BC%88Mysql%E7%B4%A2%E5%BC%95%E4%BC%98%E5%8C%96%E6%B3%A8%E6%84%8F%EF%BC%89.md) [MySQL常用命令](MySQL%E5%B8%B8%E7%94%A8%E5%91%BD%E4%BB%A4.md) [MySQL（三）｜《千萬級大數據查詢優化》第一篇：創建高性能的索引](MySQL%EF%BC%88%E4%B8%89%EF%BC%89%EF%BD%9C%E3%80%8A%E5%8D%83%E4%B8%87%E7%BA%A7%E5%A4%A7%E6%95%B0%E6%8D%AE%E6%9F%A5%E8%AF%A2%E4%BC%98%E5%8C%96%E3%80%8B%E7%AC%AC%E4%B8%80%E7%AF%87%EF%BC%9A%E5%88%9B%E5%BB%BA%E9%AB%98%E6%80%A7%E8%83%BD%E7%9A%84%E7%B4%A2%E5%BC%95.md) [MySQL（一）｜性能分析方法、SQL性能優化和MySQL內部配置優化](MySQL%EF%BC%88%E4%B8%80%EF%BC%89%EF%BD%9C%E6%80%A7%E8%83%BD%E5%88%86%E6%9E%90%E6%96%B9%E6%B3%95%E3%80%81SQL%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96%E5%92%8CMySQL%E5%86%85%E9%83%A8%E9%85%8D%E7%BD%AE%E4%BC%98%E5%8C%96.md) [MySQL（二）｜深入理解MySQL的四種隔離級別及加鎖實現原理](MySQL%EF%BC%88%E4%BA%8C%EF%BC%89%EF%BD%9C%E6%B7%B1%E5%85%A5%E7%90%86%E8%A7%A3MySQL%E7%9A%84%E5%9B%9B%E7%A7%8D%E9%9A%94%E7%A6%BB%E7%BA%A7%E5%88%AB%E5%8F%8A%E5%8A%A0%E9%94%81%E5%AE%9E%E7%8E%B0%E5%8E%9F%E7%90%86.md) [MySQL（四）｜《千萬級大數據查詢優化》第一篇：創建高性能的索引（補充）](MySQL%EF%BC%88%E5%9B%9B%EF%BC%89%EF%BD%9C%E3%80%8A%E5%8D%83%E4%B8%87%E7%BA%A7%E5%A4%A7%E6%95%B0%E6%8D%AE%E6%9F%A5%E8%AF%A2%E4%BC%98%E5%8C%96%E3%80%8B%E7%AC%AC%E4%B8%80%E7%AF%87%EF%BC%9A%E5%88%9B%E5%BB%BA%E9%AB%98%E6%80%A7%E8%83%BD%E7%9A%84%E7%B4%A2%E5%BC%95%EF%BC%88%E8%A1%A5%E5%85%85%EF%BC%89.md) [MySQL（五）｜《千萬級大數據查詢優化》第二篇：查詢性能優化（1）](MySQL%EF%BC%88%E4%BA%94%EF%BC%89%EF%BD%9C%E3%80%8A%E5%8D%83%E4%B8%87%E7%BA%A7%E5%A4%A7%E6%95%B0%E6%8D%AE%E6%9F%A5%E8%AF%A2%E4%BC%98%E5%8C%96%E3%80%8B%E7%AC%AC%E4%BA%8C%E7%AF%87%EF%BC%9A%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96%EF%BC%881%EF%BC%89.md) [MySQL（六）｜《千萬級大數據查詢優化》第二篇：查詢性能優化（2）](MySQL%EF%BC%88%E5%85%AD%EF%BC%89%EF%BD%9C%E3%80%8A%E5%8D%83%E4%B8%87%E7%BA%A7%E5%A4%A7%E6%95%B0%E6%8D%AE%E6%9F%A5%E8%AF%A2%E4%BC%98%E5%8C%96%E3%80%8B%E7%AC%AC%E4%BA%8C%E7%AF%87%EF%BC%9A%E6%9F%A5%E8%AF%A2%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96%EF%BC%882%EF%BC%89.md) [MySQL（七）｜MySQL分庫分表的那點事](MySQL%EF%BC%88%E4%B8%83%EF%BC%89%EF%BD%9CMySQL%E5%88%86%E5%BA%93%E5%88%86%E8%A1%A8%E7%9A%84%E9%82%A3%E7%82%B9%E4%BA%8B.md) [Mysql索引優化 Mysql通過索引提升查詢效率（第二棒）](Mysql%E7%B4%A2%E5%BC%95%E4%BC%98%E5%8C%96Mysql%E9%80%9A%E8%BF%87%E7%B4%A2%E5%BC%95%E6%8F%90%E5%8D%87%E6%9F%A5%E8%AF%A2%E6%95%88%E7%8E%87%EF%BC%88%E7%AC%AC%E4%BA%8C%E6%A3%92%EF%BC%89.md) [MySQL查詢的性能優化(查詢緩存、排序跟索引)](MySQL%E6%9F%A5%E8%AF%A2%E7%9A%84%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96%E6%9F%A5%E8%AF%A2%E7%BC%93%E5%AD%98%E3%80%81%E6%8E%92%E5%BA%8F%E8%B7%9F%E7%B4%A2%E5%BC%95.md) [【總結】MySQL數據庫](%E3%80%90%E6%80%BB%E7%BB%93%E3%80%91MySQL%E6%95%B0%E6%8D%AE%E5%BA%93.md) [MySQL存儲引擎、事務日志并發訪問以及隔離級別](MySQL%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E3%80%81%E4%BA%8B%E5%8A%A1%E6%97%A5%E5%BF%97%E5%B9%B6%E5%8F%91%E8%AE%BF%E9%97%AE%E4%BB%A5%E5%8F%8A%E9%9A%94%E7%A6%BB%E7%BA%A7%E5%88%AB.md) [技巧](%E6%8A%80%E5%B7%A7.md) [分表分區](%E5%88%86%E8%A1%A8%E5%88%86%E5%8C%BA.md) [MYSQL百萬級數據，如何優化](MYSQL%E7%99%BE%E4%B8%87%E7%BA%A7%E6%95%B0%E6%8D%AE%EF%BC%8C%E5%A6%82%E4%BD%95%E4%BC%98%E5%8C%96.md) [MySQL備份和恢復](MySQL%E5%A4%87%E4%BB%BD%E5%92%8C%E6%81%A2%E5%A4%8D.md) [MySQL間隙鎖死鎖問題](MySQL%E9%97%B4%E9%9A%99%E9%94%81%E6%AD%BB%E9%94%81%E9%97%AE%E9%A2%98.md) [小技巧](%E5%B0%8F%E6%8A%80%E5%B7%A7.md) [基礎](%E5%9F%BA%E6%9C%AC.md) [mysql數據庫異常](mysql%E6%95%B0%E6%8D%AE%E5%BA%93%E5%BC%82%E5%B8%B8.md) [mysql安全](mysql%E5%AE%89%E5%85%A8.md) [mysql忘記密碼后重置（以windows系統mysql 8.4為例）](mysql%E5%BF%98%E8%AE%B0%E5%AF%86%E7%A0%81%E5%90%8E%E9%87%8D%E7%BD%AE%EF%BC%88%E4%BB%A5windows%E7%B3%BB%E7%BB%9Fmysql8.4%E4%B8%BA%E4%BE%8B%EF%BC%89.md)