代码改变世界

随笔分类 -  mysql

mysql 大批量insert优化

2012-05-22 10:32 by java ee spring, 365 阅读, 收藏,
摘要： SET SESSION binlog_format = 'mixed';set autocommit=0;在sql语句中分批提交innodb_flush_log_at_trx_commit = 2; 阅读全文

perl支持mysql

2012-05-17 10:51 by java ee spring, 161 阅读, 收藏,
摘要： 默认情况，安装好perl以后不支持mysql，运行perl脚本时提示：Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Proxy, SQLite,Sponge.解决办法：--如果是在windows中安装activer perl则ppm install "DBD::mysql"--下载源码安装http://search.cpan.org/~capttofu/DBD-mysql-4.020/lib/DBD/mysql.pm 阅读全文

mysql null排序

2012-05-08 09:07 by java ee spring, 239 阅读, 收藏,
摘要： 对null值排序select * from t1 order by sname desc;+-----+-----+--------+| sid | sno | sname |+-----+-----+--------+| 103 | 203 | 徐文宇 || 104 | 204 | kk || 101 | 201 | NULL || 103 | 203 | NULL |+-----+-----+--------+select * from t1 order by if(sname is null,0,1),sname desc;+-----+-----+--------+| sid | sn 阅读全文

mysql dump备份和恢复

2012-04-26 15:38 by java ee spring, 421 阅读, 收藏,
摘要： ---------------------------------------------1.准备工作-----------------------------------------------查看当前mysql服务器使用的存储引擎# mysqladmin variables | grep storage_engine| storage_engine | MyISAM --查看mysql数据库存放目录# mysqladmin variables | grep datadir| datadir | /usr/local/mysql/var/ |------------------------- 阅读全文

mysql和sqlserver循环插入数据

2012-04-23 10:07 by java ee spring, 802 阅读, 收藏,
摘要： create table t1(sid int not null primary key,sname varchar(1000) not null)engine=innodb default charset=gbk;DELIMITER //create PROCEDURE proc1()BEGIN DECLARE i int DEFAULT 0; set i=1 ; WHILE i<=100000 DO INSERT INTO t1 values(i,'我感到自己的变化，现在我用快乐与自信代替了自怜与恐惧。人因为磨难而接受教训，有所长进。我不再重复过去的失败和错误，因为我有了羊皮 阅读全文

mysql cluster 7.1搭建

2012-04-18 10:36 by java ee spring, 342 阅读, 收藏,
摘要： 简单步骤，分享下：hostnameIP应用db1192.168.50.10MGMdb2192.168.50.20NDBDdb3192.168.50.30NDBD2db4192.168.50.40MYSQLDdb5192.168.50.50MYSQLD*****************************1.安装配置管理节点(DB1)MGM*****************************# groupadd mysql# useradd -g mysql -d /usr/local/mysql/var -M mysql# tar zxvf mysql-cluster-gpl-7.1 阅读全文