随笔分类 -  mysql

mysql
摘要:set global net_buffer_length=1000000; set global max_allowed_packet=1000000000; 阅读全文
posted @ 2016-03-15 00:06 zero530 阅读(170) 评论(0) 推荐(0)
摘要:DELIMITER $$CREATE DEFINER=`root`@`%` PROCEDURE `pro_cre_childlist`(IN rootId varchar(50),IN nDepth int, IN vdesc varchar(45))BEGIN DECLARE done INT ... 阅读全文
posted @ 2016-01-10 18:57 zero530 阅读(155) 评论(0) 推荐(0)
摘要:千万级记录的Discuz论坛导致MySQL CPU 100%的优化笔记 2007年3月,我写过一篇文章《解决一个 MySQL 服务器进程 CPU 占用 100%的技术笔记》( http://www.xiaohui.com/weekly/20070307.htm ),谈到自己在解决一个拥有 60 万... 阅读全文
posted @ 2015-12-10 14:15 zero530 阅读(946) 评论(0) 推荐(0)
摘要:Date_addSELECT OrderId,DATE_ADD(OrderDate,INTERVAL 2 DAY) AS OrderPayDateFROM OrdersMyISAM to InnoDBALTER TABLEboblog_blogs ENGINE=InnoDB;ALTER TABLEb... 阅读全文
posted @ 2015-12-10 12:09 zero530 阅读(241) 评论(0) 推荐(0)
摘要:第1步、yum安装mysql[root@stonex ~]# yum -y install mysql-server安装结果:Installed: mysql-server.x86_64 0:5.1.73-3.el6_5 ... 阅读全文
posted @ 2015-12-05 23:27 zero530 阅读(301) 评论(1) 推荐(0)
摘要:例如,你想myuser使用mypassword从任何主机连接到mysql服务器的话。mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;此时检查下防火墙是否开启... 阅读全文
posted @ 2015-12-05 23:24 zero530 阅读(255) 评论(0) 推荐(0)