ITPub博客

    1.认真看错误提示，弄不清楚状况的时候打开debugPTDEBUG=1    2.10.10.10.10为主，其它ip为从    3.h=10.10.10.10,u=checksums,p=checksums 中间一定不能有空格，不然会报错，本人排查这个错误花了很长时间    一：sakila库的film_actor表的数据检测...

如何将MYSQL中数据导出到EXCEL表中？在网上找了一些方法，请大家参考：最佳答案 select * into outfile 'd:/test.xls' from  表名其他答案：方法一：进入到mysql的控制台，输入：1. SELECT * INTO OUTFILE ‘./test.xls‘ FROM tb1 WHERE 1 ORDER BY id DESC  LIMIT ...

一.环境主机一中有3个mysql实例，Amaster，Bmaster，Cslave主机二中有1个mysql实例，Dslave主：Amaster从：Bmaster、Cslave、Dslave切换为主：Bmaster从：Cslave、Dslave注：切换之前需要考虑的问题：   1.Amaster出现的故障，能不能修复，有没有切换的必要； &n...

yum install -y gcc gcc-c++http://www.cpan.org/modules/by-module/Net/Net-Ping-2.41.tar.gz安装MMM的数据源wget http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpmrpm -ivh epel-release-6-8.noarch.rpmyum install -y mysql-mmm*安装MHA数据库源/etc/init.d/mysql starte...

问题1：Can’t exec “mysql_config”: No such file or directory at Makefile.PL line 454.解决方法：进入DBD::mysql的代码安装目录$ cd ~/.cpan/build/DBD-mysql-3.0008$ perl Makefile.PL--mysql_config=如:$MYSQL_PREFIX_DIR/bin/mysql_config$ make$ make test$ make install问题2如果 Perl 报告...

CentOS6.5以上安装heartbeat V2yum install perl-TimeDate PyXML  net-snmp-libs -ywget ftp://ftp.pbone.net/mirror/dl.iuscommunity.org/pub/ius/archive/Redhat/6/i386/epel-release-6-5.noarch.rpmrpm -ivh epel-release-6-5.noarch.rpmyum install -y libnetrpm -ivh heartbeat heartbeat-plis heartbeat-st...

NFS的安装配置：centos 5 :yum install nfs-utils portmapcentos 6 :yum install nfs-utils rpcbind本节是使用centos 6的配置过程：设备：两台 centos6 OS 安装的时候选择的是"Basic Server"软件配置包。首先，让两台机器都安装NFS的 软件包，如下显示的是服务器端：[root@roothomes /home]$ yum install nfs-uti...

https://blog.hbis.fr/2013/01/31/zabbix-mysql_partitioning/压测收集统计信息脚本#!/bin/shINTERVAL=5PREFIX=$INTERVAL-sec-statusRUNFILE=/tmp/runningmysql -e 'show global variables' >> mysql-variableswhile test -e $RUNFILE; do   file=$(date +%F_%I)   sleep=$(date +%s.%N | a...

压测收集统计信息脚本#!/bin/shINTERVAL=5PREFIX=$INTERVAL-sec-statusRUNFILE=/tmp/runningmysql -e 'show global variables' >> mysql-variableswhile test -e $RUNFILE; do   file=$(date +%F_%I)   sleep=$(date +%s.%N | awk "{print $INTERVAL - (\$1 % $INTERVAL)}")   sle...

      mysql通过alter procedure语句来修改存储过程，通过alter function语句来修改存储过程，alter {procedure|function} sp_name 【characteristic...]characteristc:{contains sql|no sql|reads sql data|modifies sql data}|sql security{definer|invoker}|comment 'string'contains s...

#!/usr/bin/env python<br />#encoding=utf-8<br />import MySQLdb<br />try:<br />conn=MySQLdb.connect(host="192.168.8.7",user="root",passwd="xx",db="test")<br />cur=conn.cursor()<br />cur=execute("SET autocommit=0")<br />cur=execute("CALL sp_rollback_demo")<br />cur.execute("COMMIT")<br />exce...

1半同步复制<br />判断是否支持动态插件<br />select @@have_dynamic_loading;<br />主库插件<br />$MYSQL_HOME/lib/plugin/semisync_master.so<br />mysql&gt;install plugin rpl_semi_sync_master SONAME 'semisync_master.so'<br />select * from mysql.plugin<br />set global rpl_semi_sync_master_enabled=1;...

<p><span style="font-size:22.0pt;font-family:黑体;">一<span>.</span>安装前配置信息<span></span></span></p><p><span><span>&nbsp;&nbsp; </span></span><span style="font-family:宋体;">远程控制卡</span><span>IP<span>&nbsp; </span></span><span style="font-family:宋体;">：</span><span>192.168.10.138...

mysql维护管理<br />1.删除数据库中test下的所有前缀为tmp的表；<br />mysql -e "select concat('drop table test.',table_name,';') from information_schema.tables where table_schema='test' and table_name like 'tmp%';"|grep -v concat<br />2.将数据库中test下所有存储引擎为myisam的表改为innodb<br />mysql -...

http://blog.itpub.net/27042095/viewspace-748002/LOAD DATA INFILE 'C:\Users\jack\Desktop\test\sqlldr4.txt'   "str X'3B'" INTO TABLE T1 REPLACE FIELDS TERMINATED BY ','TRAILING NULLCOLS (ID,FUND_AC...

SQL优化3<br />优化表结构类型<br />select * from tbl_name procedure analyze()<br />select * from tbl_name procedure analyze(16,256)<br />表的拆分<br /><br />mysql&gt; show global status like 'innodb_row_lock%';<br />+-------------------------------+-------+<br />| Variable_name&nbsp;&nbsp;&nb...

SQL优化2测试样例wget http://downloads.mysql.com/docs/sakila-db.zipICP: 5.6 Index Condition Pushdown(ICP)应用场景：where条件中其中几个字段，在联合索引的范围内；explain select * from rental where rental_date='2006-02-14 15:16:03' and customer_id>=300 and customer_...

1.了解sql的执行频率show global status like 'Com_%';show global status like 'Innodb_%';show global status like 'Connections';show global status like 'Uptime';show global status like 'Slow_queries';2.定位低效的sql语句慢查询show processlist；

#!/bin/bashcurrenttime=$(date "+%Y-%m-%d")/mysql/mysqlsoft/bin/mysql  -uwangya -pwangya -hx.x.x.x  -P3306 -Ne "use caihui1;select * from chdquote where ENTRYDATE='$currenttime 00:00:00';" >/tmp/chdquote.txt#/mysql/mysqlsoft/bin/mysql  -uroot -proot --soc...

null