摘要:
From http://blog.csdn.net/wujiandao/article/details/6621073 1. Four ways to get execution plan(anytime you want, for specified sql) • Execute the SQL 阅读全文
摘要:
Refer to http://www.tldp.org/HOWTO/SSL-Certificates-HOWTO/x64.html The content 1.2. What is SSL and what are Certificates? The Secure Socket Layer pro 阅读全文
摘要:
Some key concents regarding SQL optimization predicate selectivity (column unique ratio) / cardinality (estimated returned) driving (outer) table acce 阅读全文
摘要:
Articles Forward from Locking in Microsoft SQL Server (Part 12 – Lock Escalation) Today I’d like us to talk about Lock Escalation in Microsoft SQL Ser 阅读全文
摘要:
关于 Solr Cloud Zookeeper 入门,介绍 原理 参考 https://blog.csdn.net/qq_17045385/article/details/74738893 原封不动转自 http://wiki.apache.org/solr/SolrCloud/ ,文章的内存有些过 阅读全文
摘要:
没有废话,步骤如下: 下载安装软件,MySQL Apache PHP sudo aptitude install mysql-server mysql-client ##安装 MySQLsudo aptitude install apache2 apache2-doc libapache2-mod- 阅读全文
摘要:
vmstat 的 pi/po si/so --监控一天 vmstat 5 17280> vmstat.txt sar -W 1.得到数据 (linux 的 /var/log/sar/saX 自带) sar -A -o sar.dat 5 17280 2. 分析 sar -W -f sar.dat > 阅读全文
摘要:
对于某些大型应用来说,SWAP 严重影响性能,尽可能避免使用: The Linux kernel provides a tweakable setting that controls how often the swap file is used, called swappiness A swapp 阅读全文
摘要:
直接引用 http://www.cnblogs.com/xdp-gacl/p/3777987.html 阅读全文
摘要:
http://stackoverflow.com/questions/7359702/how-do-i-obtain-a-query-execution-plan 阅读全文