ITPub博客

<br />Centos6.5<br />mysql 5.1.73<br /><br />yum mysql 5.1.73升级到5.6.26<br /><br /><br />http://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/<br /><br /><br /><br /><br />MySQL yum库包括最新的软件包有：<br />MySQL 5.6 (GA)<br />MySQL 5.7 (Development Release)<br />MySQL 5.5 (GA -...

gtid不支持myisam，可能导致多个gtid分配给同一个事物不支持：create table .. selectcreate /drop temporary table必须使用enforce-gtid-consistencysql-slave-skip-counter不支持5.6.9之后，mysqldump制作的备份己包含gtid...

线程池技术：当线程数过多时，如果其中大部分线程都处于活动状态，将会导致频繁的上下文切换，从而造成巨大的系统开销。上下文切换：什么是线程上下文切换上下文切换的精确定义可以参考: http://www.linfo.org/c...

-POSTGRESQL1.登录  sudo su - postgres  #需要使用postgres用户  psql -h localhost -p 5432  #-h指定主机名，-p指定监听端口号  \c wala  --c,connect,连接到指定的库wala  show search_path; --查看当前的查找路径...

分区表<br /><br /><br />create table maintb(id int,name char(10));<br /><br /><br />&nbsp;create table childtb_1 (CHECK ( id BETWEEN 1 AND 200)) inherits(maintb);<br />&nbsp;create table childtb_2 (CHECK ( id BETWEEN 201 AND 400)) inherits(maintb);<br />&nbsp;create table childtb_3 (CHECK ( ...

-----------------<br />做hot standby&nbsp;<br />主库通过日志复制到从库进行Recover.缺点：会落后一个日志<br />主库：<br />vi pg_hba.conf<br />host &nbsp; &nbsp;replication &nbsp; &nbsp; replica &nbsp; &nbsp; &nbsp; &nbsp;192.168.0.0/16 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;md5<br /><br /><br...

mongo 开启慢查询1.使用profiler use mongewa db.auth('gewaradb','gewara2008') db.getProfilingStatus() db.setProfilingLevel(1,50);可以取0，1，2 三个值，他们表示的意义如下：　　0 – 不开启

<div class="article_title" style="margin:5px 0px;font-stretch:normal;font-size:20px;line-height:30px;font-family:'Microsoft YaHei';white-space:normal;background-color:#FFFFFF;"><h1 style="margin:0px;padding:0px;display:inline;font-weight:normal;font-stretch:normal;font-size:20px;vertical-align:mid...

第一章：表基本操作1.1建表create table tb_emp1 (id int,name varchar(25),deptid int,salary float);主键约束create table tb_emp2 (id int primary key,name varchar(25),deptid int,salary float);

<header class="entry-header" style="color:#373737;font-family:Arial, sans-serif;font-size:15px;line-height:23.625px;white-space:normal;"><h1 class="entry-title" style="border:0px;font-family:inherit;font-size:26px;font-style:inherit;margin:0px;outline:0px;padding:1px 10px 0.1em 0px;vertical-align:b...

<header class="entry-header"><h1 class="entry-title" style="border:0px;font-family:inherit;font-size:26px;font-style:inherit;margin:0px;outline:0px;padding:1px 10px 0.1em 0px;vertical-align:baseline;clear:right;color:#222222;line-height:1.1em;">优化MySQL的21个建议</h1><div class="entry-meta" st...

<em><header class="entry-header" style="color:#373737;font-family:Arial, sans-serif;font-size:15px;line-height:23.625px;white-space:normal;"><h1 class="entry-title" style="border:0px;font-family:inherit;font-size:26px;font-style:inherit;margin:0px;outline:0px;padding:1px 10px 0.1em 0px;vertical-ali...

<h2 style="margin:10px 0px 0px;padding:0px 5px 3px;letter-spacing:-0.05em;font-family:Verdana, 'BitStream vera Sans';font-size:16px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:#CCCCCC;color:#555555;line-height:normal;white-space:normal;background-color:#FFFFFF;">open/clos...

<table border="0" cellpadding="0" cellspacing="0" style="color:#000000;font-family:Arial, Helvetica, sans-serif;font-size:12px;width:722px;text-align:center;background-color:#FFFFFF;" class="ke-zeroborder"><tbody><tr><td><br /></td></tr><tr><td><table class="wenzhang...

flush_option 可以是下列任何东西：FLUSH HOSTS     &n...

<div class="Blog_tit4 Blog_tit5" style="border-bottom-width:0px;padding:0px 0px 11px;color:#565656;font-family:宋体, Arial;line-height:12px;white-space:normal;background-color:#FFFFFF;">&nbsp;<a href="http://blog.itpub.net/29254281/viewspace-1398273/" style="text-decoration:none;color:#9C2423;font...

<div class="Blog_tit4 Blog_tit5" style="border-bottom-width:0px;padding:0px 0px 11px;color:#565656;font-family:宋体, Arial;line-height:12px;white-space:normal;background-color:#FFFFFF;">&nbsp;<a href="http://blog.itpub.net/29254281/viewspace-1734271/" style="text-decoration:none;color:#9C2423;font...

<div class="Blog_tit4 Blog_tit5" style="border-bottom-width:0px;padding:0px 0px 11px;color:#565656;font-family:宋体, Arial;line-height:12px;white-space:normal;background-color:#FFFFFF;"><a href="http://blog.itpub.net/15480802/viewspace-757562/" style="text-decoration:none;color:#9C2423;font-family...

<div class="Blog_tit4 Blog_tit5" style="border-bottom-width:0px;padding:0px 0px 11px;color:#565656;font-family:宋体, Arial;line-height:12px;white-space:normal;background-color:#FFFFFF;"><a href="http://blog.itpub.net/15480802/viewspace-764968/" style="color:#9C2423;font-family:微软雅黑, 黑体, Verd...

<p style="margin-top:0px;margin-bottom:21px;border:0px;font-family:'Microsoft Yahei', Tahoma, Arial, Helvetica, STHeiti;font-size:14px;font-stretch:inherit;line-height:21px;vertical-align:baseline;color:#413C36;white-space:normal;background-color:#FFFFFF;">#创建表DEPT</p><p style="margin-top:0px...