Posted by admin on May 6th, 2013
noodba同学写的基于mysql的 WORKLOAD REPOSITORY工具,目前还没有开源 非常的给力！！
主要思想为一台管理机器,集中了所有client端的数据,client 为mysql database 使用host_id来区分 如 host_id=1代表mysql databas[......]
Tags: mysqlawr
Posted in MYSQL | No Comments »
Posted by admin on March 25th, 2013
Tags: architecture
Posted in MYSQL | No Comments »
Posted by admin on March 19th, 2013
TPCC对mysql 5.5.27做一次性能测试时遭遇 Segmentation fault,gdb调试记录之:
[root@db-81 ~]# uname -a Linux db-81 2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010[......]
Tags: trouble shooting
Posted in MYSQL | No Comments »
Posted by admin on January 29th, 2013
mysql 数据库 poor IO performance.从DELL 815(6disk raid 5,oel5.5) 迁移至 HP DL380 (14disk raid 1+0,rhl5.8)
当时的IO 表现
avg-cpu: %user %nice %system %[......]
Tags: mysql
Posted in MYSQL | No Comments »
Posted by admin on May 28th, 2012
linux mysql
一、修改内核参数
1.1、编辑/etc/sysctl.conf
vi /etc/sysctl.conf
net.ipv4.tcp_max_syn_backlog = 65536
net.core.netdev_max_backlog = 65536
ne[......]
Posted in MYSQL | No Comments »
Posted by admin on May 11th, 2012
来自pythian mysql project
With this plug-in, a DBA can add a new MySQL target just as they can an Oracle database. Oracle Enterprise Manager Agent[......]
Posted in MYSQL | No Comments »
Posted by admin on April 10th, 2012
最近跟同事测试了下MHA 作为mysql 高可用方案的一种 MHA具有很多优点 DeNA目前采用这种架构 支撑2亿+PV的访问
MHA
一．MHA介绍
MHA自动化主服务器故障转移，快速将从服务器晋级为主服务器(通常在10-30s)，而不影响复制的一致性，不需要花钱买更多的新服务器，[......]
Posted in MYSQL | 1 Comment »
Posted by admin on March 29th, 2012
drbd+heartbeat+mysql slave 方案
测试机器IP：public
10.2.0.181 — drbd+heartbeat
10.2.0.182 — drbd+heartbeat
10.2.0.183 — mysql slave
10.2.0.184[......]
Tags: High performance
Posted in MYSQL | No Comments »
Posted by admin on January 18th, 2012
由于此前的mysql salve服务器没有进行规划,一些参数都是使用的默认参数,导致innodb datafile 无限制增长,所以需要重新规划一下datafile空间的分配,以及其他参数的优化
version:
mysql>
mysql>
mysql> select version([......]
Tags: mysql
Posted in MYSQL | No Comments »
