- 博客(53)
- 收藏
- 关注
转载 innodb_flush_log_at_trx_commit参数性能测试
mysql> create table test_load(a int,b char(80)) engine=innodb;Query OK, 0 rows affected (0.19 sec)mysql...
2017-03-28 15:50:46 150
转载 基于时间点的恢复
1、拷贝老库的binlog到恢复库(注意不要把新库的日志给覆盖掉) 2、 解析binlog找出at时间点: mysqlbinlog -vv mysql-bin.0000...
2016-05-24 11:07:35 154
转载 zabbix环境搭建
zabbix配置文件[root@dba ~]# cat /usr/local/zabbix/etc/zabbix_agentd.conf | grep -v "#"LogFile=/tmp/zabbix_agent...
2016-04-13 11:25:02 113
转载 zabbix环境搭建
zabbix配置文件[root@dba ~]# cat /usr/local/zabbix/etc/zabbix_agentd.conf | grep -v "#"LogFile=/tmp/zabbix_agent...
2016-04-12 17:01:40 69
转载 MySQL5.6安装参数文件
# MySQL_version 5.6.26# Version 1.1# Date 2016-03-31# The MySQL server[mysqld]port ...
2016-03-31 17:07:05 96
转载 MYSQL锁
情况1:session 1:localhost.test>create table g(a int,b int ,primary key(a,b)) engine = innodb;Query OK, 0 ro...
2015-12-29 17:51:50 72
转载 做Mysql主从时,注意使用replicate_wild_do_table和replicate-wild-ignore-table
使用replicate_do_db和replicate_ignore_db时有一个隐患,跨库更新时会出错。 如在Master(主)服务器上设置 replicate_do_db=test(my.conf中设置)...
2015-11-19 14:46:25 378
转载 pt-online-schema-change工具的使用
测试运行: [root@newxywy ~]# pt-online-schema-change -usuperdba --ask-pass --port=3311 --alter "ADD COLUMN con...
2015-09-06 10:15:36 327
转载 LINUX网关维护命令
[root@dba ~]# route add default gw 192.168.0.10 dev eth0[root@dba ~]# [root@dba ~]# route -nKernel IP routin...
2015-08-02 18:41:07 119
转载 mysql主从复制的常见问题
mysql主从同步失败Last_IO_Error: Got fatal error 1236 from master解决方法 mysql教程主从同步失败Last_IO_Error: Got fatal erro...
2015-07-31 13:44:57 143
转载 MYSQL主从复制
主库: [root@dba ~]# cat /etc/my.cnf[mysqld]server_id=77 datadir=/var/lib/mysql socket=/var/lib/mysq...
2015-07-31 10:31:33 71
转载 Mysql热备份
至此MYISAM: mysqlhotcopy -u root -p 123456 --flushlog test /root/ [root@dba ~]# cd test/[root@dba ...
2015-07-31 09:31:54 60
转载 MYSQL表的导入导出
mysql> select * from test into outfile '/tmp/test.txt' fields terminated by "," enclosed by '"';Query OK, ...
2015-07-31 09:23:18 88
转载 XTRABACKUP增量备份与恢复
xtrabackup增量备份的原理是: 1)、首先完成一个完全备份,并记录下此时检查点LSN; 2)、然后增量备份时,比较表空间中每个页的LSN是否大于上次备份的LSN,若是则备...
2015-07-30 15:58:13 183
转载 mysql日志
2015-07-23 15:59:37 3013 [Note] Binlog end2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'partition'2...
2015-07-23 17:23:38 78
转载 mysql锁问题的研究
MYISAM表锁: mysql> show status like 'table%';+----------------------------+-------+| Variable_name...
2015-07-21 14:16:55 139
转载 MYSQL SERVER优化
mysql> show engine innodb status \G;*************************** 1. row *************************** Ty...
2015-07-20 17:26:50 125
转载 MYSQL SQL优化
mysql> show session status like 'com%';+---------------------------+-------+| Variable_name ...
2015-07-20 15:49:42 61
转载 mysql随机产生行记录
select * from (select scott.emp.*, row_number() over(order by dbms_random.value) rn from scott.emp) ...
2015-07-20 15:20:16 84
转载 mysql触发器
t1前面不能保护into子句: CREATE TRIGGER t_up BEFORE INSERT ON t FOR EACH ROWBEGIN INSERT t1(nam...
2015-07-20 10:23:05 68
转载 mysql定时任务
mysql> show variables like '%schedu%';+-----------------+-------+| Variable_name | Value |+------------...
2015-07-20 09:53:00 48
转载 mysql分区表
mysql> show variables like '%partition%';Empty set (0.00 sec) 查看安装的插件,最后一行: mysql> show plu...
2015-07-17 15:58:47 53
转载 mysql的常用工具
[root@dba ~]# myisampackmyisampack Ver 1.23 for Linux on x86_64Copyright 2002-2008 MySQL AB, 2008 Sun Micro...
2015-07-17 15:58:16 73
转载 mysql sql mode及相关问题
mysql> select @@sql_mode;+--------------------------------------------+| @@sql_mode...
2015-07-17 15:03:39 65
转载 mysql分布式事务控制
sesson 1: mysql> select * from t;+------+--------------------------+--------------------------------...
2015-07-17 14:48:04 58
转载 mysql存储过程
select * from information_schema.routines mysql> desc information_schema.routines;+----------...
2015-07-17 13:39:45 57
转载 Mysql的视图
select * from information_schema.VIEWS mysql> desc information_schema.VIEWS;+---------------...
2015-07-17 13:09:14 52
转载 mysql的字符集设置
字符集:mysql> show character set;+----------+-----------------------------+---------------------+--------+...
2015-07-17 11:19:40 61
转载 选择合适的数据类型
mysql> drop table vc;Query OK, 0 rows affected (0.03 sec) mysql> create table vc(v varchar(4),c ...
2015-07-16 16:44:07 72
转载 mysql的存储引擎
mysql> show variables like '%storage_engine%';+----------------------------+--------+| Variable_name...
2015-07-16 15:18:47 55
转载 mysql的文件
rpm包安装: [root@dba mysql]# pwd/usr/share/mysql[root@dba mysql]# ls -l *.cnf-rwxr-xr-x 1 root root 11...
2015-07-16 13:27:50 55
转载 mysql常用的函数
mysql> select curdate(),curtime(),now();+------------+-----------+---------------------+| curdate() | c...
2015-07-16 13:09:13 79
转载 mysql中的运算符
mysql> select ~1;+----------------------+| ~1 |+----------------------+| 184467440...
2015-07-16 10:46:05 80
转载 mysql帮助的使用
mysql> ? contents;You asked for help about help category: "Contents"For more information, type 'help ', ...
2015-07-16 09:07:05 58
转载 mysql的数据类型
mysql> use testReading table information for completion of table and column namesYou can turn off this f...
2015-07-14 16:53:31 54
转载 mysql修改root用户密码的方法
遇到以下错误: [root@dba ~]# mysql -uroot -pEnter password: ERROR 1045 (28000): Access denied for user 'root...
2015-07-14 12:09:05 94
转载 mysql的rpm包安装
1、准备好安装包: [root@dba ~]# ll总用量 75916-rw-------. 1 root root 1647 6月 24 11:29 anaconda-ks.cfg-rw...
2015-07-14 11:23:35 82
转载 shell循环
例子10-1 一个简单的例子: #!/bin/bash# 列出所有的行星名称. for planet in Mercury Venus Earth Mars Jupiter Saturn Ura...
2015-07-08 13:57:17 109
转载 linux shell学习笔记1
例子 2-1. cleanup: 一个清空/var/log目录下的日志文件的脚本 #Cleanup# 必须以root用户运行.cd /var/logcat /dev/null > mes...
2015-07-06 11:01:28 85
转载 ORACLE LINUX VNC配置
[root@dba ~]# yum -y install gtk-vnc*Loaded plugins: refresh-packagekit, securitySetting up Install Process...
2015-07-02 21:31:34 309
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人