Tag Archives: mysql
多台slave的mysql replication的配置
5.1.24版本的配置请看：http://www.masalife.com/archives/173 一、先修改服务器的配置文件 1、Master服务器配置简单，修改my.cnf为: server-id = 1 log-bin set-variable=binlog-ignore-db=mysql 2、slave1的配置加入 server-id = 2 master-host = 172.16.20.135 master-user = rep master-password = cnrep master-port = 3306 log-bin set-variable=replicate-ignore-db=mysql set-variable=replicate-do-db=AliSMS set-variable=replicate-do-db=lcd set-variable=replicate-do-db=loginmanager set-variable=replicate-do-db=samis set-variable=replicate-do-db=sareport set-variable=replicate-do-db=syslog set-variable=replicate-do-db=web_speed log-slave-updates 3、slave2服务器的配置 server-id = 3 …
MySQL的性能调优工具：比mysqlreport更方便的tuning-primer.sh
Sundry MySQL提供的脚本相比mysqlreport更进一步：除了报表还进一步提供了修改建议。安装和使用非常简单： wget http://www.day32.com/MySQL/tuning-primer.sh chmod +x tuning-primer.sh ./tuning-primer.sh 和mysqlreport一样，tuning-primer.sh也支持.my.cnf [client] user = USERNAME password = PASSWORD socket = /tmp/mysql.sock 样例输出：在终端上按照问题重要程度分别用黄色/红色字符标记问题 -- MYSQL PERFORMANCE TUNING PRIMER -- - By: Matthew Montgomery - MySQL Version 5.0.45 i686 Uptime = 19 days …
MySQL中各种字段的取值范围
TINYINT -128 - 127 TINYINT UNSIGNED 0 - 255 SMALLINT -32768 - 32767 SMALLINT UNSIGNED 0 - 65535 MEDIUMINT -8388608 - 8388607 MEDIUMINT UNSIGNED 0 - 16777215 INT 或 INTEGER -2147483648 - 2147483647 INT UNSIGNED 或 INTEGER UNSIGNED 0 …
MySql操作要点整理
列类型 需要的存储量 TINYINT 1 字节 SMALLINT 2 个字节 MEDIUMINT 3 个字节 INT 4 个字节 INTEGER 4 个字节 BIGINT 8 个字节 FLOAT(X) 4 如果 X < = 24 或 8 如果 25 < = X < = 53 FLOAT 4 个字节 …
SEARCH
Update
- 54chen Twitter memo 2012-05-20
- rose手册第三章四节：controller层：自定义http参数支持
- rose手册第三章三节：controller层：ErrorHandler支持
- 54chen Twitter memo 2012-05-13
- 54chen Twitter memo 2012-05-06
- rose手册第三章二节：controller层：拦截器支持
- 54chen Twitter memo 2012-04-29
- rose手册第三章一节：controller层：url对照规则与返回结果规则
- 54chen Twitter memo 2012-04-22
- 54chen Twitter memo 2012-04-15
- rose手册第二章：配置与使用
- 54chen Twitter memo 2012-04-08
- 54chen Twitter memo 2012-04-01
- rose手册第一章：入门指引
- 54chen Twitter memo 2012-03-25