carterslam的专栏

1.下载安装包下载地址：https://dev.mysql.com/downloads/mysql/5.6.html#downloads2.解压tar -zxvf mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz -C /usr/local/3.创建软连接进入安装目录 cd /usr/local/创建软连接 ln -s mysql-5.7.9-linux-glibc2.5-x86_64 mysql4.添加用户组为centos添加mysql用户组和m

INSERT INTO ads_point_premises_snt (sum_type, sum_id, sum_name, point_num_in,point_num_out,property_type,is_core,is_xinchao,cooperation_model,uu_id,etl_time,data_date )select sum_type,sum_id,sum_name,point_num_in,point_num_out,property_type,is_core,is_xin

select cityCode, shareExpense, year, month from (SELECT s.city_code cityCode, s.year, s.month, s.point_avg_cost shareExpense FROM bulletin_data_city_point_avg_cost ...

问题：多线程并发事务导致mysql报 Lock wait timeout exceeded; try restarting transaction原因：DDL语句条件错误导致锁等待超时解决办法：1.正确使用索引，如果在条件列加索引，mysql将只对该索引加锁，只有在相同参数重复请求的时候才会触发行锁举例：delete from table_users where name=xxx and age=xxx 需要建一个联合索引CREATE INDEX index_name_age ON t...

【背景】136是主  135是从，136意外宕机无法启动【解决办法】把135改为主【方法】添加master.cnf文件，内容如下：dbpath=/data/mongodb/datalogpath=/data/mongodb/log/master.logpidfilepath=/data/mongodb/master.pidmaster=truedirectoryperdb=tr

遇到一个有点诡异的问题，想给mysql增加列，语句如下：#板块 - 新增全屏广告位(点击)字段ALTER TABLE `lanrch_panel` ADD COLUMN `monitorClick` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '广告海报点击时信息URL列表...