2013年09月_10000cat

转载 Linux里如何查找文件内容

Linux查找文件内容的常用命令方法。从文件内容查找匹配指定字符串的行： $ grep "被查找的字符串" 文件名例子：在当前目录里第一级文件夹中寻找包含指定字符串的.in文件 grep "thermcontact" */*.in 从文件内容查找与正则表达式匹配的行： $ grep –e “正则表达式” 文件名查找时不区分大小写： $ grep –i "被查找

2013-09-26 15:00:50 341

原创 mysql优化摘要

1. Replication If you have a read-heavy environment, reads can go faster in MyISAM if you do the following: Setup Master/Slave ReplicationCreate one or more Read Slaves under the MasterAdd --skip

2013-09-09 13:16:53 410

转载重置 InnoDB 表的日志文件

Don't forget to resize the InnoDB Log Files (ib_logfile0 and ib_logfile1). MySQL Source Code places a cap of the combined sizes of all InnoDB Log Files must be Step 1) Add innodb_log_file_size=NNN

2013-09-09 10:47:56 567

原创 mysql innodb myisam引擎的区别

1. innodb支持行锁，mysiam支持表锁； 2.innodb支持更好的崩溃恢复机制； 3. mysiam支持fullindex，innodb没有； 4.innodb支持事务处理，外键约束，关系约束；myisam没有

2013-09-09 09:54:48 554

转载 mysql Waiting for table level lock

1.We recently had a similar problem. Initially our key_buffer_size was set to 1GB. Increasing that to 10GB reduced the problem. 2. @Rick James, thank you. You saved me a lot of trouble today.

2013-09-09 09:50:46 6810

原创 php输出excel格式的文件

<?php $filename = date('YmdHis').".csv";//文件名 header("Content-type:text/csv;charset=utf-8"); header("Content-Disposition:attachment;filename=".$filename); header('Cache-Control:must-revalidate,post-

2013-09-05 09:48:38 385

原创 mysql 跨表更新数据的几种操作

1. UPDATE product p, productPrice pp SET pp.price = pp.price * 0.8 WHERE p.productId = pp.productId AND p.dateCreated 2. UPDATE product p INNER JOIN productPrice pp ON p.productId = pp.productId S

2013-09-04 23:00:35 537

原创 vim find and replace

2013-09-03 23:04:40 501

caiyiii的专栏