
数据库
清水小河虾
2014年6月毕业后从事软件开发方面的工作,大数据
展开
-
Sql优化精简版
1.select语句中避免使用*,尽量应该根据业务需求按字段进行查询 2.删除重复记录 delete from tble tb where tb.id>(select min(id) from tble ble where tb.name=ble.name) 3.用>=替换> 4.尽量多使用commit 如对大数据量的分段批量提交 5.用not exists 替换not in原创 2016-03-13 17:25:09 · 525 阅读 · 0 评论 -
#Redis Error #MISCONF Redis is configured to save RDB snapshots, but is currently not able to persis
今天运行Redis时发生错误,错误信息如下: (error) MISCONF Redis is configured to save RDB snapshots, but is currently not able to persist on disk. Commands that may modify the data set are disabled. Please check Redi转载 2017-08-07 07:37:09 · 237 阅读 · 0 评论