ITPub博客

情况1：session 1:localhost.test>create table g(a int,b int ,primary key(a,b)) engine = innodb;Query OK, 0 rows affected (0.03 sec)localhost.test>select * from g;+----+---+| a  | b |+----+---+|  1 | 1 ||  3 | 1 ||  5 | 3 ||  7 | 6 || 10 | 8 |+----+---+5 row...

使用replicate_do_db和replicate_ignore_db时有一个隐患，跨库更新时会出错。如在Master（主）服务器上设置 replicate_do_db=test（my.conf中设置）use mysql;update test.table1 set ......那么Slave（从）服务器上第二句将不会被执行 如Master设置 replicate_ignore_db=mysqluse mysql;update te...

<p style="margin-top:0px;margin-bottom:0px;clear:both;height:auto;overflow:hidden;color:#505050;font-family:宋体, 'Arial Narrow', arial, serif;font-size:14px;line-height:28px;white-space:normal;widows:auto;background-color:#FFFFFF;"><span style="padding:0px;margin:0px;">下载地址：</span></p><p s...

测试运行：[root@newxywy ~]# pt-online-schema-change -usuperdba --ask-pass --port=3311 --alter "ADD COLUMN context text" D=test,t=t1 --socket=/tmp/mysql3311.sock  --print --dry-runEnter MySQL password: Starting a dry run.  `test`.`t1` will not be altered. ...

<p style="margin-top:0px;margin-bottom:20px;color:#555555;font-family:'Microsoft Yahei', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:16px;line-height:27px;white-space:normal;widows:auto;">编写了一个服务端程序，打开终端能直接运行程序，但是这样终端就被限制住了。如果ctrl+c退出或者关闭终...

[root@dba ~]# route add default gw 192.168.0.10 dev eth0<br />[root@dba ~]# <br />[root@dba ~]# route -n<br />Kernel IP routing table<br />Destination&nbsp;&nbsp;&nbsp;&nbsp; Gateway&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Genmask&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Flags Met...

<h1 style="font:bold 26px/normal Simsun;list-style:none;margin:5px 0px 10px;padding:0px;text-align:center;color:#000000;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;-webkit-text-stroke-width:0px;">mysql主从同步失败Last_IO_Error: Got fatal error 1236...

主库：[root@dba ~]# cat /etc/my.cnf[mysqld]server_id=77 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock #skip-grant-tables character_set_server=utf8#autocommit=offlog-bin=/var/lib/mysql/feige-bin#binlog_format=STA...

<p>至此MYISAM：</p><p>&nbsp;mysqlhotcopy -u root -p 123456 --flushlog test /root/</p><p>[root@dba ~]# cd test/<br />[root@dba test]# ll<br />总用量 108<br />-rw-r--r-- 1 mysql mysql&nbsp; 8586 7月&nbsp; 30 15:42 test.frm<br />-rw-r--r-- 1 mysql mysql 98304 7月&nbsp; 30 15:42 test.ibd<b...

<p>mysql&gt; select * from test into outfile '/tmp/test.txt' fields terminated by "," enclosed by '"';<br />Query OK, 16 rows affected (0.00 sec)</p><p><br /></p><p>[root@dba ~]# cat /tmp/test.txt <br />"1","test1"<br />"2","test2"<br />"3","test3"<br />"4","test4"<br />"5","test5"<b...

[root@dba ~]#  innobackupex --user=root --password=123456 --defaults-file=/etc/my.cnf  /data/backup/hotbackup/base --no-timestampInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona LLC and/or its affiliates 2009-2013.  All Rights...

原始出处：

<p>2015-07-23 15:59:37 3013 [Note] Binlog end<br />2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'partition'<br />2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'BLACKHOLE'<br />2015-07-23 15:59:37 3013 [Note] Shutting down plugin 'ARCHIVE'<br />2015-07-23 15:59:37 3013 [Note] Shu...

MYISAM表锁：mysql> show status like 'table%';+----------------------------+-------+| Variable_name              | Value |+----------------------------+-------+| Table_locks_immediat...

mysql> show engine innodb status \G;*************************** 1. row ***************************  Type: InnoDB  Name: Status: =====================================2015-07-20 16:35:06 7ff4efbd1700 INNODB MONITOR OUTPUT==============...

<p>mysql&gt; show session status like 'com%';<br />+---------------------------+-------+<br />| Variable_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Value |<br />+---------------------------+-------+<br />| Com_admin_commands&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs...

select *  from (select scott.emp.*, row_number() over(order by dbms_random.value) rn          from scott.emp) t where t.rn < 13;

<p>t1前面不能保护into子句：</p><p>CREATE TRIGGER t_up<br />&nbsp;&nbsp; BEFORE INSERT<br />&nbsp;&nbsp; ON t<br />&nbsp;&nbsp; FOR EACH ROW<br />BEGIN<br />&nbsp;&nbsp; INSERT&nbsp; t1(name) values ('insert'); <br />&nbsp;&nbsp; end;</p><p><br /></p><p>mysql&gt; show TRIGGERs;<br...

mysql&gt; show variables like '%schedu%';<br />+-----------------+-------+<br />| Variable_name&nbsp;&nbsp; | Value |<br />+-----------------+-------+<br />| event_scheduler | OFF&nbsp;&nbsp; |<br />+-----------------+-------+<br />1 row in set (0.00 sec)<br />...

<p>mysql&gt; show variables like '%partition%';<br />Empty set (0.00 sec)</p><p>查看安装的插件，最后一行：</p><p>mysql&gt; show plugins;<br />+----------------------------+----------+--------------------+---------+---------+<br />| Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb...