随笔分类 -  Mysql 监控与运维

mysql 5.7修改密码
摘要：关闭正在运行的 MySQL ： [root@www.woai.it ~]# service mysql stop 运行 [root@www.woai.it ~]# mysqld_safe --skip-grant-tables & 为了安全可以这样禁止远程连接： [root@www.woai.it 阅读全文

posted @ 2016-05-04 15:56 Still water run deep 阅读(10686) 评论(0) 推荐(0)

orzdba的安装与使用
摘要：参考：http://code.taobao.org/p/orzdba/src/ http://code.taobao.org/p/myrelay/wiki/index/ http://www.taobaodba.com/html/937_orzdba.html下载源代码：[root@yz-db pa... 阅读全文

posted @ 2014-08-24 17:02 Still water run deep 阅读(1416) 评论(0) 推荐(0)

Don’t Assume – Per Session Buffers
摘要：MySQL has a number of global buffers, i.e. your SGA. There are also a number of per session/thread buffers that combined with other memory usage const... 阅读全文

posted @ 2014-05-15 02:29 Still water run deep 阅读(355) 评论(0) 推荐(0)

Comparison of B-Tree and Hash Indexes
摘要：Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data structures in their indexes, particularly for theMEMORYstorage engine that lets you choose B-tree or hash indexes.B-Tree Index CharacteristicsA B-tree ind 阅读全文

posted @ 2014-04-04 01:24 Still water run deep 阅读(253) 评论(0) 推荐(0)

Bash script: report largest InnoDB files
摘要：The following script will report the largest InnoDB tables under the data directory: schema, table & length in bytes. The tables could be non-partitioned, in which case this is simply the size of the corresponding.ibdfile, or they can be partitioned, in which case the reported size is the sum of 阅读全文

posted @ 2014-02-27 23:45 Still water run deep 阅读(269) 评论(0) 推荐(0)

导航