-
编辑 删除
linux下python守护进程编写和原理理解
<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退出或者关闭终...
-
编辑 删除
LINUX网关维护命令
[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 Gateway Genmask Flags Met...
-
编辑 删除
mysql主从复制的常见问题
<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...
-
编辑 删除
MYSQL主从复制
主库：[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...
-
编辑 删除
Mysql热备份
<p>至此MYISAM：</p><p> 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 8586 7月 30 15:42 test.frm<br />-rw-r--r-- 1 mysql mysql 98304 7月 30 15:42 test.ibd<b...
-
编辑 删除
MYSQL表的导入导出
<p>mysql> 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...
-
编辑 删除
XTRABACKUP增量备份与恢复
[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...
-
编辑 删除
CentOS6.4+MySQL-5.6.12 安装详解
原始出处：
-
编辑 删除
mysql日志
<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...
-
编辑 删除
mysql锁问题的研究
MYISAM表锁：mysql> show status like 'table%';+----------------------------+-------+| Variable_name | Value |+----------------------------+-------+| Table_locks_immediat...
-
编辑 删除
MYSQL SERVER优化
mysql> show engine innodb status \G;*************************** 1. row *************************** Type: InnoDB Name: Status: =====================================2015-07-20 16:35:06 7ff4efbd1700 INNODB MONITOR OUTPUT==============...
-
编辑 删除
MYSQL SQL优化
<p>mysql> show session status like 'com%';<br />+---------------------------+-------+<br />| Variable_name | Value |<br />+---------------------------+-------+<br />| Com_admin_commands &nbs...
-
编辑 删除
mysql随机产生行记录
select * from (select scott.emp.*, row_number() over(order by dbms_random.value) rn from scott.emp) t where t.rn < 13;
-
编辑 删除
mysql触发器
<p>t1前面不能保护into子句：</p><p>CREATE TRIGGER t_up<br /> BEFORE INSERT<br /> ON t<br /> FOR EACH ROW<br />BEGIN<br /> INSERT t1(name) values ('insert'); <br /> end;</p><p><br /></p><p>mysql> show TRIGGERs;<br...
-
编辑 删除
mysql定时任务
mysql> show variables like '%schedu%';<br />+-----------------+-------+<br />| Variable_name | Value |<br />+-----------------+-------+<br />| event_scheduler | OFF |<br />+-----------------+-------+<br />1 row in set (0.00 sec)<br />...
-
编辑 删除
mysql分区表
<p>mysql> show variables like '%partition%';<br />Empty set (0.00 sec)</p><p>查看安装的插件，最后一行：</p><p>mysql> show plugins;<br />+----------------------------+----------+--------------------+---------+---------+<br />| Name &nb...
-
编辑 删除
mysql的常用工具
[root@dba ~]# myisampackmyisampack Ver 1.23 for Linux on x86_64Copyright 2002-2008 MySQL AB, 2008 Sun Microsystems, Inc.This software comes with ABSOLUTELY NO WARRANTY. This is free software,and you are welcome to modify and redistribute it under the GPL license
-
编辑 删除
mysql sql mode及相关问题
<p>mysql> select @@sql_mode;<br />+--------------------------------------------+<br />| @@sql_mode |...
-
编辑 删除
mysql分布式事务控制
<p>sesson 1:</p><p>mysql> select * from t;<br />+------+--------------------------+----------------------------------+<br />| id | context | hash_value ...
-
编辑 删除
mysql存储过程
<p>select * from information_schema.routines</p><p><br /></p><p>mysql> desc information_schema.routines;<br />+--------------------------+---------------------+------+-----+---------------------+-------+<br />| Field &nb...
