![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
文章平均质量分 81
ZhongWeicheng
这个作者很懒,什么都没留下…
展开
-
MySQL Workbench Performance Tools
MySQL Workbench 是专为数据库架构师、开发人员和 DBA 打造的一个统一的可视化工具。MySQL Workbench 提供了数据建模工具、SQL 开发工具和全面的管理工具(包括服务器配置、用户管理、备份等)。原创 2014-08-27 22:34:20 · 1211 阅读 · 0 评论 -
MySQL master-master replication configuration
MySQL 5.1 installationMySQL 5.5 installationOne may say that there are a lot of MySQL replication manuals, but latest versions of MySQL server have changed the way how configuration should b原创 2013-01-10 17:22:17 · 1023 阅读 · 0 评论 -
使用mysqldump ftp将备份集上传到远端服务器
以下是我以前的一个mysqldump备份脚本,将备份集打包ftp传到异地服务器上,脚本修改路径即可。将其放在crontab下。#!/bin/sh logfile=/backup/backup.logLOCALHOST_IP=$(/sbin/ifconfig |grep 'inet addr' |cut -d':' -f2 |cu原创 2013-11-24 23:26:24 · 1115 阅读 · 0 评论 -
从MySQL全备中恢复Innodb单表
First, you must meet certain prerequisites to be able to restore a ibd tablespace:1.The ibd file must be from a consistent backup with all insert buffer entries merged and have no uncommitted trans原创 2013-11-25 19:58:16 · 1659 阅读 · 0 评论 -
MySQL连接MyISAM文件
Recently, I found myself involved in the migration of a large read-only InnoDB database to MyISAM (eventually packed). The only issue was that for one of the table, we were talking of 5 TB of data, 23原创 2013-11-25 15:32:17 · 745 阅读 · 0 评论 -
Shell Script For MySQL Enterprise Backup Crontab Schedule
#!/bin/ksh#prints usageusage(){ echo "$VERSION" echo "Usage: `basename $0` [command] [MEB options]Commands: full make full backup incremental原创 2013-08-29 13:11:49 · 2498 阅读 · 0 评论 -
MySQL Compressed Backup
[root@test zwc]# ls -lhtotal 953M-rw-rw---- 1 mysql mysql 61 Nov 3 22:03 db.opt-rw-rw---- 1 mysql mysql 8.5K Nov 3 22:10 t1.frm-rw-rw---- 1 mysql mysql 191M Nov 3 22:25 t1.MYD-rw-rw----原创 2013-11-04 00:29:33 · 1565 阅读 · 1 评论 -
恢复使用MEB备份的MySQL数据库
执行一个普通备份[root@test bin]# ./mysqlbackup --defaults-file=/service/mysql5.5/my.cnf --socket=/data/mysql5.5/mysql.sock --user=root --backup-dir=/backup/5.5/normal --password backupMySQL Enterprise Back原创 2013-11-23 00:04:23 · 2779 阅读 · 0 评论 -
MySQL Cluster配置参数详细介绍
在MySQL Cluster环境的配置文件config.ini里面,每一类节点都有两个(或以上)的相应配置项组,每一类节点的配置项都主要由两部分组成,一部分是 同类所有节点相同的配置项组,在[NDB_MGM DEFAULT]、[NDBD DEFAULT]和[MySQLD DEFAULT]这三个配置组里面,而且每一个配置组只出现一次;而另外一部分则是针对每一个节点独有配置内容的配置项组 [NDB_M转载 2013-11-21 15:17:51 · 2734 阅读 · 0 评论 -
MySQL Utilities Example
You obviously need Python on your server (python-2.6.6-37.el6_4.x86_64 in mycase) and the Python MySQL library (mysql-connector-python-1.0.8-1.el6.noarch)[root@db01 software]# rpm -ivh mysql-conne原创 2013-11-06 16:39:46 · 2247 阅读 · 0 评论 -
MySQL配置Master-Slave
master库打开log-bin参数,保证master和slave的server-id参数不同在master上创建允许slave访问的rep用户MASTER@root@(none) 12:34:34>grant replication slave on *.* to 'rep'@'192.168.1.12' identified by 'rep';Query OK, 0 rows aff原创 2014-01-30 00:54:52 · 1048 阅读 · 0 评论 -
OEM12c 安装配置MySQL Plug-in用来监控MySQL
emcli安装参考--注册信息[root@test agent]# /oem/emcli setup -url=https://omsdb.localdomain:7301/em -username=sysmanOracle Enterprise Manager 12c 3.Copyright (c) 1996, 2013 Oracle Corporation and/or原创 2014-02-20 15:23:56 · 2645 阅读 · 0 评论 -
Percona Server 安装
安装配置参数[root@monser Percona-Server-5.5.34-rel32.0]# cmake . -DCMAKE_INSTALL_PREFIX=/service/mysql -DMYSQL_DATADIR=/data/mysql -DSYSCONFDIR=/service/mysql -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock -DWI原创 2014-02-09 00:16:23 · 5213 阅读 · 0 评论 -
MySQL使用profile分析SQL执行状态
打开profilemysql> select @@have_profiling;+------------------+| @@have_profiling |+------------------+| YES |+------------------+1 row in set (0.00 sec)mysql> select @@profiling;原创 2014-02-05 23:26:26 · 4758 阅读 · 0 评论 -
MySQL5.5配置安装半同步复制
确认master和slave上是否开启have_dynamic_loadingmasterMASTER@root@(none) 10:54:58>show variables like 'have_dynamic_loading';+----------------------+-------+| Variable_name | Value |+------------原创 2014-02-03 23:10:47 · 2332 阅读 · 0 评论 -
MySQL复制环境中使用slave_exec_mod参数
先看下slave_exec_mod官方描述Command-Line Format--slave-exec-mode=modeOption-File Formatslave_exec_modeSystem Variable Nameslave_exec_modeVariable S原创 2014-01-31 19:23:40 · 2893 阅读 · 0 评论 -
Configuration PHP5.4 oci8 MySQL5.5 on CentOS6 x86_64
Software Packageapr-1.4.6.tar.gzapr-util-1.5.1.tar.gzhttpd-2.4.6.tar.gzlibiconv-1.13.1.tar.gzlibmcrypt-2.5.8.tar.gzmcrypt-2.6.8.tar.gzmhash-0.9.9.9.tar.gzmysql-5.5.25.tar.gzoracle-原创 2013-11-13 21:25:19 · 3054 阅读 · 0 评论 -
统计MySQL binlog中的DML语句
MASTER@root@test 07:44:52>create table tab02(id int(10) primary key,name varchar(20));Query OK, 0 rows affected (0.10 sec)MASTER@root@test 08:34:54>MASTER@root@test 08:34:54>MASTER@root@test 08:3原创 2014-01-31 20:38:15 · 1455 阅读 · 0 评论 -
MySQL禁用binlog中的语句
MySQL复制是异步的,也就是说是非同步的过程,它不会校验数据库中数据的一致性,只要SQL语法正确并且没有错误就能成功执行MASTER@root@test 12:20:40>create table tab01 -> (id int(10) primary key , -> name varchar(20));Query OK, 0 rows affected (0.03 s原创 2014-01-30 12:29:29 · 3376 阅读 · 0 评论 -
MySQL Cluster Error msg
config.ini[tcp default]SendBufferMemory=16M在向操作系统发出调用请求之前,TCP传输器采用缓冲来保存所有的消息。当该缓冲达到64KB时,将发送其内容,执行完一组消息循环后,也将发送这些内容。发送缓冲的默认值是256KBReceiveBufferMemory=16M指定了从TCP/IP套接字转载 2013-11-21 00:12:12 · 4113 阅读 · 0 评论 -
Linux下编译安装MySQL Cluster 7.1
操作系统使用CentOS 5.6 64-bit,MySQL Cluster版本是mysql-cluster-gpl-7.1.19使用4服务器分别如下:db1 192.168.105.24 mgm nodedb2 192.168.105.21 ndbd,mysqld nodedb3 192.168.105.22 ndbd,mysqld nodedb4 192.168.105.23原创 2012-12-17 09:25:25 · 1194 阅读 · 0 评论 -
Installation and Configuration MySQL Cluster 7.2 on CentOS 5 (include MySQL 5.5)
ArchitectureManager Nodemysql-mag1 192.168.1.31mysql-mag2 192.168.1.32SQL Nodemysql-sql1 192.168.1.33mysql-sql2 192.168.1.34NDB Nodemysql-ndb1 192.168.1.35mysql-ndb2原创 2013-11-19 23:55:29 · 2633 阅读 · 0 评论 -
MySQL获取系统性能和状态
#!/bin/kshINTERVAL=5PREFIX=$INTERVAL-sec-statustouch /tmp/runningRUNFILE=/tmp/runningmy -e 'show global variables' >> mysql-variableswhile test -e $RUNFILE; do file=$(date +%F_%I) sleep=$(d原创 2013-07-30 14:21:39 · 1199 阅读 · 0 评论 -
MySQL Partitioning
range partitioning:used for data that can be separated into ranges based on some criterion i.e. date, part number, ID's.list partitioning:used for data that can be separated into lists based on some原创 2013-02-18 09:20:48 · 1251 阅读 · 0 评论 -
MySQL Partitioning
range partitioning:used for data that can be separated into ranges based on some criterion i.e. date, part number, ID's.list partitioning:used for data that can be separated into lists based on some原创 2013-02-18 09:00:42 · 60 阅读 · 0 评论 -
MySQL查看索引和表数据大小
以下查看数据大小SELECT CONCAT(ROUND(SUM(data_length)/(1024*1024), 2), ' M') AS 'Total Data Size'FROM information_schema.TABLES WHERE table_schema = 'zwc'; 以下查看索引大小SELECT CONCAT(ROUND(SUM(index_lengt原创 2013-02-04 15:16:26 · 4569 阅读 · 0 评论 -
MySQL配置文件参数解释
basedir = path使用给定目录作为根目录(安装目录)。character-sets-dir = path给出存放着字符集的目录。datadir = path从给定目录读取数据库文件。pid-file = filename为mysqld程序指定一个存放进程ID的文件(仅适用于UNIX/Linux系统); Ini原创 2013-01-10 15:23:51 · 656 阅读 · 0 评论 -
MySQL innodb use exclusive tablespace
Since MySQL version 4.1, InnoDB has provided two alternatives for how tables are stored on disk. You can create a new table and its indexes in the shared system tablespace, physically stored in the ib原创 2013-01-10 15:14:03 · 723 阅读 · 0 评论 -
xtrabackup源码编译安装
RHEL4,5,6 / OL4,5,6 / CentOS4,5,6 / SLES10 / SLES11 / openSuSE is OK! on RHEL / OL / CentOSyum -y install gcc gcc-c++ autoconf perl libjpeg libjpeg-devel libpng libpng-devel freetype freetyp原创 2013-01-10 10:58:14 · 4032 阅读 · 1 评论 -
Linux下编译安装MySQL5.1
RHEL5 / OL5 / CentOS5 is OK![root@dbtest opt]# useradd mysql -s /sbin/nologin [root@dbtest opt]# mkdir -p /data/mysql /service[root@dbtest opt]# tar -zxvf mysql-5.1.65.tar.gz[root@dbtest opt原创 2012-12-15 13:43:22 · 1661 阅读 · 0 评论 -
Use Innotop Monitoring MySQL
install[root@mytest ~]# tar -zxvf innotop-1.9.0.tar.gz innotop-1.9.0/innotop-1.9.0/t/innotop-1.9.0/t/InnoDBParser.tinnotop-1.9.0/t/innodb-status-001innotop-1.9.0/t/innodb-status-002innotop-1.9原创 2013-08-04 23:06:43 · 1525 阅读 · 0 评论 -
MySQL使用information_schema获取锁表信息
information_schemaSELECT r.trx_id waiting_trx_id, r.trx_mysql_thread_id waiting_thread, TIMESTAMPDIFF( SECOND, r.trx_wait_started, CURRENT_TIMESTAMP ) wait_time, r.trx_query waiting_query原创 2013-08-18 23:21:57 · 4883 阅读 · 1 评论 -
Python connect MySQL
yum -y install rpm-build gcc-c++ mysql mysql-devel readline-devel openssl-devel gmp-devel ncurses-devel gdbm-devel expat-devel libGL-devel libX11-devel tcl-devel tk-devel tix-devel sqlite-devel db4-de原创 2013-11-19 14:10:45 · 2117 阅读 · 0 评论 -
Installation MariaDB5.5 on RHEL6
yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurse原创 2013-11-01 23:01:31 · 3046 阅读 · 0 评论 -
Linux下编译安装MySQL5.5
RHEL5 / OL5 / CentOS5 / SLES10 / SLES11 / openSuSE is OK!yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-d原创 2012-12-15 08:09:30 · 1599 阅读 · 0 评论 -
Check MySQL Database Size
root@zwc 11:11:29>SELECT -> ROUND( -> SUM(data_length + index_length) / 1024 / 1024 -> ) TOTAL_MB, -> ROUND(SUM(data_length) / 1024 / 1024) DATA_MB, -> ROUND( -> SUM(index_leng原创 2013-11-03 23:16:46 · 1165 阅读 · 0 评论 -
Installation MEMCACHE_ENGINE for MySQL5.1
installation memcache[root@test software]# tar -zxvf libevent-1.2.tar.gz [root@test software]# cd libevent-1.2[root@test libevent-1.2]# ./configure --prefix=/service/libevent[root@test libevent-1原创 2013-11-17 01:02:02 · 1135 阅读 · 0 评论 -
MySQL Using xtrabackup backup and recovery example
installation xtrabackupinsert datainnodb[root@test ~]# /service/mysql/bin/mysql -uroot -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection i原创 2013-01-10 15:01:45 · 1516 阅读 · 0 评论 -
How to Create Partial Backups Using MySQL Enterprise Backup
Few usage examples.We have following setup for our tests:Tables t1, t2, d1, d2 in all databases use InnoDB storage engine and tables t11, t12, d11, d12 use MyISAM storage engine.mysql> sho原创 2013-08-27 22:05:47 · 855 阅读 · 0 评论 -
How to recover a single InnoDB table from a Full Backup
You must set var innodb_file_per_table = 1[root@zhongwc ~]# /service/mysql/bin/mysql -uroot -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is原创 2013-08-25 12:12:02 · 89 阅读 · 0 评论