每天都在百度,百度,百度。很多查过的资料,看过就忘了,很可惜,在这里记录一下。
这里有不少是我还没搞懂的东西。搞清楚的知识点会另开博客
1. SQL waits
LATCH_EX:https://www.sqlskills.com/help/waits/latch_ex/
SQL Server Wait Types Library: https://www.sqlskills.com/help/waits/#l
数据库出现大量LATCH_SH等如何破解: https://social.msdn.microsoft.com/Forums/azure/zh-CN/c550a168-13b2-4bbe-9940-3afede32c8d8/2596825454242112098629616228233732730340latchsh12289latchex12289?forum=sqlserverzhchs
SqlServer性能急剧下降,查看所有会话的状态及等待类型---Latch_Ex: https://www.cnblogs.com/zhaoguan_wang/p/4604270.html
2 Nginx
菜鸟教程: https://www.runoob.com/w3cnote/nginx-setup-intro.html
如何使用Nginx监听两个uwsgi端口,实现同时访问两个django项目: https://ask.csdn.net/questions/749632
多个项目如何使用同一个外网端口: https://blog.csdn.net/sunt2018/article/details/83017316
3 Substring in SQL
sql server中的left, right, substring在oracle中都用substr实现: https://www.cnblogs.com/watermarks/p/3540744.html
SQL中字符串截取函数(SUBSTRING):https://blog.csdn.net/album_gyd/article/details/81365573