Interested in .NET&Java platform,CLR and JVM internal,C# ,JIT compiler,software architecture design,windows kernel/CLR debugging skills,SQL Server 、MySQL,Database architecture、Query Optimization、troubleshooting and high availability, parallel/multi-threaing programming,distributed computing,cloud computing ,Apache Storm, Spark, Flink,Machine Learning, Deep Learning ,TensorFlow and all AI related things.

随笔分类 - MySQL

mysql-table_open_cache_file_limits/

摘要：http://seanlook.com/2017/10/13/mysql-table_open_cache_file_limits/ 阅读全文

posted @ 2019-07-31 15:41 暖风的风阅读(175) 评论(0) 推荐(0) 编辑

introducing-backup-locks-percona-server-2/

摘要：https://www.percona.com/blog/2014/03/11/introducing-backup-locks-percona-server-2/ 阅读全文

posted @ 2019-07-31 15:24 暖风的风阅读(105) 评论(0) 推荐(0) 编辑

MySQL 一致性读深入研究

摘要：https://www.cnblogs.com/digdeep/p/4947694.html 阅读全文

posted @ 2019-07-31 14:22 暖风的风阅读(162) 评论(0) 推荐(0) 编辑

how-to-configure-mysql-masterslave-replication-with-mha-automatic-failover/

摘要：https://www.arborisoft.com/how-to-configure-mysql-masterslave-replication-with-mha-automatic-failover/ 阅读全文

posted @ 2019-07-28 12:43 暖风的风阅读(151) 评论(0) 推荐(0) 编辑

mysqlOOM

摘要：https://cloud.tencent.com/developer/article/1005397 阅读全文

posted @ 2019-07-21 22:17 暖风的风阅读(133) 评论(0) 推荐(0) 编辑

mysql 线程池

摘要：https://www.cnblogs.com/cchust/p/4510039.html https://www.jianshu.com/p/88e606eca2a5 https://www.percona.com/doc/percona-server/LATEST/performance/thr 阅读全文

posted @ 2019-07-21 18:40 暖风的风阅读(127) 评论(0) 推荐(0) 编辑

MySQL 8 复制

摘要：https://blog.csdn.net/wzy0623?t=1 阅读全文

posted @ 2019-07-20 20:59 暖风的风阅读(193) 评论(0) 推荐(0) 编辑

mysql blocking问题

摘要：https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-examples.html 阅读全文

posted @ 2019-07-20 19:56 暖风的风阅读(195) 评论(0) 推荐(0) 编辑

TCPRT

摘要：https://zhuanlan.zhihu.com/p/37112986 阅读全文

posted @ 2019-07-17 20:49 暖风的风阅读(344) 评论(1) 推荐(0) 编辑

understanding-mysql-isolation-levels-repeatable-read/

摘要：https://blog.pythian.com/understanding-mysql-isolation-levels-repeatable-read/ 阅读全文

posted @ 2019-07-17 01:53 暖风的风阅读(154) 评论(0) 推荐(0) 编辑

understand-show-slave-status-g

摘要：https://dba.stackexchange.com/questions/22623/mysql-exec-master-log-pos-value-greater-than-read-master-log-pos https://dba.stackexchange.com/questions 阅读全文

posted @ 2019-07-13 21:17 暖风的风阅读(123) 评论(0) 推荐(0) 编辑

how-does-mysql-replication-really-work/ what-causes-replication-lag

摘要：https://www.cnblogs.com/kevingrace/p/6274073.html https://www.cnblogs.com/kevingrace/p/6261091.html https://dba.stackexchange.com/questions/22623/mysq 阅读全文

posted @ 2019-07-12 22:48 暖风的风阅读(139) 评论(0) 推荐(0) 编辑

https://mysqlserverteam.com/mysql-connection-handling-and-scaling/

摘要：https://mysqlserverteam.com/mysql-connection-handling-and-scaling/ 阅读全文

posted @ 2019-07-10 23:40 暖风的风阅读(129) 评论(0) 推荐(0) 编辑

MYSQL 常用语句

摘要：1，查看SP的内容： use sys;SHOW CREATE PROCEDURE ps_setup_enable_consumer;SELECT body FROM mysql.proc WHERE db = 'sys' AND name = 'ps_setup_enable_consumer' ; 阅读全文

posted @ 2019-02-20 10:42 暖风的风阅读(171) 评论(0) 推荐(0) 编辑

EXPLAIN Output Format

摘要：https://dev.mysql.com/doc/refman/8.0/en/explain-output.html https://dev.mysql.com/doc/refman/5.7/en/explain-output.html 阅读全文

posted @ 2019-01-17 22:52 暖风的风阅读(175) 评论(0) 推荐(0) 编辑

MYSQL 优化器源码解析

该文被密码保护。

posted @ 2019-01-16 00:51 暖风的风阅读(127) 评论(0) 推荐(0) 编辑

mysql内核月刊

摘要：http://mysql.taobao.org/monthly/ 阅读全文

posted @ 2019-01-08 01:43 暖风的风阅读(169) 评论(0) 推荐(0) 编辑

build MYSQL source code Using visual studio 2017

摘要：https://dev.mysql.com/doc/refman/8.0/en/installing-source-distribution.html xiaai cmake-3.15.6-win64-x64.msi https://cmake.org/download/ XIAZAI https: 阅读全文

posted @ 2019-01-04 00:04 暖风的风阅读(436) 评论(0) 推荐(0) 编辑

using-sys-session-as-an-alternative-to-show-processlist

摘要：https://mysqlserverteam.com/using-sys-session-as-an-alternative-to-show-processlist/ 阅读全文

posted @ 2018-11-20 14:18 暖风的风阅读(154) 评论(0) 推荐(0) 编辑

Performance Schema for MySQL Troubleshooting

摘要：https://www.percona.com/live/europe-amsterdam-2015/sites/default/files/slides/PSSession.pdf 阅读全文

posted @ 2018-11-20 14:08 暖风的风阅读(123) 评论(0) 推荐(0) 编辑

魔都浪子