博客首页

最新的博客文章:


mysql innodb_file_io_threads, innodb_read_io_threads, innodb_write_io_threads posted on 20 Feb 2015 05:44
mysql中,innodb_file_io_threads, innodb_read_io_threads, innodb_write_io_threads这三个参数是控制innodb的读写线程。
[mysql-innodb]2-1-instance-threads-memory-files.png
http://7vzpyg.com1.z0.glb.clouddn.com/[mysql-innodb]2-1-instance-threads-memory-files.png
还可以从Debug状态下看到线程列表
[mysql-innodb]2-2-threads-under-debug.png
http://7vzpyg.com1.z0.glb.clouddn.com/[mysql-innodb]2-2-threads-under-debug.png (read more…) 评论: 0, 评价: 0

mysql innodb engine status posted on 20 Feb 2015 05:37
mysql> show engine innodb status; (read more…) 评论: 0, 评价: 0


mysql 追踪SQL执行 posted on 20 Feb 2015 04:43
大致执行
http://labs.chinamobile.com/mblog/393521_180022
SQL执行
sql/sql_select.cc handle_select.cc (read more…) 评论: 0, 评价: 0


mysql 用VS.Net的IDE打开MySQL的源码 posted on 20 Feb 2015 04:31

  • 安装 cmake-3.1.3-win32-x86.exe

http://www.cmake.org/download/

  • 展开 mysql-5.1.73.zip

http://dev.mysql.com/downloads/mysql/5.1.html

  • 执行

win/configure.js
win/build-vs…bat

  • 用Visual Studio打开

MySql.sln (read more…) 评论: 0, 评价: 0


mysql 体系结构 posted on 20 Feb 2015 03:48
[mysql-innodb]1-1-architecture.png
http://7vzpyg.com1.z0.glb.clouddn.com/[mysql-innodb]1-1-architecture.png
Connectors
Connection Pool
Management Service and Utilities
SQL
Parser
Optimizer
Caches and Buffers
Storage Engine
File System
Files and Logs (read more…) 评论: 0, 评价: 0

Win 金山界面库KUI posted on 14 Feb 2015 03:39
金山界面库KUI是伴随金山卫士开源项目而被开发者所了解的一套Windows界面库。 (read more…) 评论: 0, 评价: 0


Oracle ASM优化 posted on 11 Feb 2015 12:30
http://www.orafaq.com/papers/tuning_asm.pdf#search='oracle+asm+raw+filesystem+performance+improvement' (read more…) 评论: 0, 评价: 0


Oracle 评测NFS、OCFS与ASM posted on 11 Feb 2015 12:28
这是一个CERN的文章,评测了NFS、OCFS与ASM的效率。 (read more…) 评论: 0, 评价: 0


Java EventQueue与SwingUtilities的invokeLater posted on 11 Feb 2015 06:34
EventQueue与SwingUtilities都有invokeLater的方法。目的是在AWT描画占用的时候把处理放到后面去做。 (read more…) 评论: 0, 评价: 0

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License