发表于
2017-01-16 22:00:03
[原]MySQL 占据60g磁盘容量的大表分析
在进行mysql数据库巡检的时候，发送一个数据文件特别大，有快60g了，如下：[root@db_m1_slave_1 business_db]# ll -h MOVIE_INTERFACE_LOG.ibd
-rw-rw----. 1 mysql mysql 59G Jan 16 16:40 MOVIE_INTERFACE_LOG.ibd
[root@db_m1_slave_1 business_db]#查看数据量，才不到200W记录，那是怎么会占据60g的容量呢？mysql> select count(1) from MOVIE_INTERFACE_LOG;
+----------+
| count(1) |
+----------+
| 1769717 |
+----------+
1 row in set (7.20 sec)
mysql>进去查看这个表，可以看到有varchar(1000),text字段以及longtext字段mysql> show create table MOVIE_INTERFACE_LOG;
+---------------------+------------------------------------------------------------------------------------------------
...继续阅读
(43)
发表于
2017-01-13 22:57:58
Vue2.0实现简易豆瓣电影webApp
运行项目项目地址：https://github.com/superman66...clone项目到本地，进入项目文件夹，安装依赖git clone https://github.com/superman66/vue2.x-douban.git
cd vue2.x-douban
npm install然后运行npm run dev最后打开浏览器，输入localhost:8880即可访问。效果图如下：路由应用包括下面4个路由/movies首页，包含正在上映榜单和即将上映榜单的电影信息，首页只显示各个榜单的前8条数据；/movie-list榜单列表页面，显示榜单列表信息;/movie/subject/:id电影详情页面；/movie/search电影搜索列表页面。项目结构.
├── README.md
├── build // vue-cli 自带的配置文件
│ ├── build.js
│ ├── check-versions.js
│ ├── dev-client.js
│ ├── dev-server.js
│ ├── utils.js
│ ├── webpack.base.conf.js
│ ├── webpack.dev.conf.js
│ └── webpack.prod.conf.js
├── config // vue-cli 自带的配置
...继续阅读
(9)
发表于
2016-11-08 01:38:25
奇异博士：大型长篇显示器测试片[老 Wright 电影周刊]
发表于
2016-10-03 02:55:54
犯我中华者，虽远必诛[老 Wright 电影周刊]
发表于
2016-09-28 03:34:18
[译] 使用angularjs创建一个CRUD应用
原文地址：https://www.sitepoint.com/creating-crud-app-minutes-angulars-resource大量的单页应用都有CRUD操作。如果你使用angularjs创建一个CRUD操作，那么你可以利用$resource服务的优势。建立在$http服务之上，angularjs的$resource是一个 factory ,这样使前后端使用RESTful标准进行交互变得简单。所以，我们一起探索一下$resource,并且在angular中实现CRUD的操作。前提$resource服务没有打包到angularjs中。你需要下载一个独立的文件叫angular-resource.js并且把它引入到HTML页面中。这个文件可以从这里下载：http://cdnjs.cloudflare.com/ajax/libs/angular.js/1.2.16/angular-resource.min.js。另外，为了使用$resource你需要在主模块中注入ngResource模块。示例：angular.module('mainApp',['ngResource']); //mainApp is our main module入门$resource和 RESTful API工作。这意味着你的 URLs 应该类似于下面的模式：你可以创建接口使用你选择的服务器端语言。
...继续阅读
(19)
发表于
2016-09-28 02:16:44
送子鸟：传递永不息[老 Wright 电影周刊]
发表于
2016-09-27 12:58:03
AngularJs中的provide
AngularJS用$provide去定义一个供应商,这个$provide有5个用来创建供应商的方法：constantvalueservicefactoryproviderdecoratorConstant定义常量用的，它定义的值当然就不能被改变，它可以被注入到任何地方，但是不能被装饰器(decorator)装饰var app = angular.module('app', []);
app.config(function ($provide) {
$provide.constant('movieTitle', 'The Matrix');
});
app.controller('ctrl', function (movieTitle) {
expect(movieTitle).toEqual('The Matrix');
});语法糖：app.constant('movieTitle', 'The Matrix');Value它可以是string,number甚至function,它和constant的不同之处在于，它可以被修改，不能被注入到config中，但是它可以被decorator装饰var app = angular.module('app', []);
app.config(function ($provide) {
$provide.value
...继续阅读
(32)
发表于
2016-09-12 15:45:46
MongoDB优化之倒排索引
摘要:为MongoDB中的数据构建倒排索引(Inverted Index)，然后缓存到内存中，可以大幅提升搜索性能。本文将通过为电影数据构建演员索引，介绍两种构建倒排索引的方法：MapReduce和Aggregation Pipeline。GitHub地址:作者:KiwenLau日期:2016-09-11一. 倒排索引倒排索引(Inverted Index)，也称为反向索引，维基百科的定义是这样的:是一种索引方法，被用来存储在全文搜索下某个单词在一个文档或者一组文档中的存储位置的映射。这个定义比较学术，也就是比较反人类，忽略...倒排索引是搜索引擎中的核心数据结构。搜索引擎的爬虫获取的网页数据可以视为键值对，其中，Key是网页地址(url)，而Value是网页内容。网页的内容是由很多关键词(word)组成的，可以视为关键词数组。因此，爬虫获取的网页数据可以这样表示:<url1, [word2, word3]>
<url2, [word2]>
<url3, [word1, word2]>但是，用户是通过关键词进行搜索的，直接使用原始数据进行查询的话则需要遍历所有键值对中的关键词数组，效率是非常低的。因此，用于搜索的数据结构应该以关键词(word)为Key，以网页地址(url)为Value:<word1, [url3]>
<word
...继续阅读
(18)
发表于
2016-08-04 03:39:51
使用mongoose模块，为什么model的名称得到的数据库名会转换
//模型var Movie = mongoose.mongoose.model(‘Movie’, schema.movieSchema);
如上的代码操作，数据库中的collection名会变成movies，要想还用Movie要怎么实现？
...继续阅读
(26)
发表于
2016-07-04 01:33:54
关于从Activity A跳转到Activity B ，其中Activity A中有一个VideoView，Activity B中有一个MediaPlayer。
两个不同的视频的跳转，前面我是在onStop()方法中销毁VideoView（因为MediaPlayer是全局共用的，而VideoView内包含MediaPlayer），但是每次进入Activity B视频播放了一点就会弹出了，导致视频B播放失败publicclassMovieSynopsis extends BaseActivity implements OnClickListener{@OverrideprotectedvoidonCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setContentView(R.layout.movie_synopsis);}@OverridepublicvoidonClick(View v) {if(v.equals(mPlayButton)){Intent intent=newIntent(MovieSynopsis.this, MoviePlayer.class);startActivity(intent);}}@OverrideprotectedvoidonStop() {if(movie_video!=null){movie_video.pause();movie_video.stopPlayback();}super.onStop();}@O
...继续阅读
(23)
发表于
2016-07-03 10:12:39
TypeError: Cannot read property ‘_id’ of undefined 怎么解决
{ [CastError: Cast to ObjectId failed for value “” at path “_id”]
message: ‘Cast to ObjectId failed for value “” at path “_id”’,
name: ‘CastError’,
kind: ‘ObjectId’,
value: ‘’,
path: ‘_id’,
reason: undefined }
{ [ValidationError: Movie validation failed]
message: ‘Movie validation failed’,
name: ‘ValidationError’,
errors:
{ _id:
{ [CastError: Cast to ObjectID failed for value “” at path “_id”]
message: ‘Cast to ObjectID failed for value “” at path “_id”’,
name: ‘CastError’,
kind: ‘ObjectID’,
value: ‘’,
path: ‘_id’,
reason: [Object] } } }
d:\NodeWork\Study1\routes\index.js:105
res.redirect(’/mo
...继续阅读
(64)
发表于
2016-07-03 08:58:35
求各位帮我看下是什么问题，求求求求求求
{ [CastError: Cast to ObjectId failed for value “” at path “_id”]
message: ‘Cast to ObjectId failed for value “” at path “_id”’,
name: ‘CastError’,
kind: ‘ObjectId’,
value: ‘’,
path: ‘_id’,
reason: undefined }
{ [ValidationError: Movie validation failed]
message: ‘Movie validation failed’,
name: ‘ValidationError’,
errors:
{ _id:
{ [CastError: Cast to ObjectID failed for value “” at path “_id”]
message: ‘Cast to ObjectID failed for value “” at path “_id”’,
name: ‘CastError’,
kind: ‘ObjectID’,
value: ‘’,
path: ‘_id’,
reason: [Object] } } }
d:\NodeWork\Study1\routes\index.js:105
res.redirect(’/mo
...继续阅读
(23)
发表于
2016-06-24 16:58:59
ArtClip – 为视频添加多种效果[OS X][￥30→0]
发表于
2016-06-06 21:34:26
模式匹配第四弹：if case，guard case，for case
作者：Olivier Halligon，原文链接，原文日期：2016-05-16译者：walkingway；校对：Cee；定稿：numbbbbb现在我们来重新回顾下前三弹模式匹配的各种语法第一弹，第二弹，第三弹，第四弹是本系列的最后一篇文章，本章会教大家使用if case let，for case where等一些高级语法，让我们拭目以待吧！本篇文章会结合本系列前三篇文章提到的语法，然后将它们应用在一些更先进表达式中。这篇文章是模式匹配系列文章的最后一部分，你可以在这里阅读所有内容：第一弹，第二弹，第三弹，第四弹if case let语句case let x = y模式允许你检查y是否能匹配x。而if case let x = y { … }严格等同于switch y { case let x: … }：当你只想与一条 case 匹配时，这种更紧凑的语法尤其有用。有多个 case 时更适合使用switch。例如，我们有一个与之前文章类似的枚举数组：enum Media {
case Book(title: String, author: String, year: Int)
case Movie(title: String, director: String, year: Int)
case WebSite(urlString: String)
}然后我们可以这样写：l
...继续阅读
(18)
发表于
2016-06-01 02:36:22
求关联外键的思路，ref能否关联多个模型？
例如我现在做一个回复功能，这个回复功能想整合到 movie模型和document模型（而不是两个回复功能重复开发），那么该怎么做呢？var CommentSchema = new Schema({
movie: {type: ObjectId, ref: ‘Movie’},//被评论的电影id，这里的ref能指定两个吗？
from: {type: ObjectId, ref: ‘User’},
content: String
})
...继续阅读
(17)
发表于
2016-05-08 19:08:23
→ Apple Stole My Music. No, Seriously.
This Apple Music horror story is making the rounds today. It sounds like either a severe user error or a severe bug, and there’s no way to know which it is, but regardless, this aside is good advice:For about ten years, I’ve been warning people, “Hang onto your media. One day, you won’t buy a movie. You’ll buy the right to watch a movie, and that movie will be served to you. If the companies serving the movie don’t want you to see it, or they want to change something, they will have the power to do so. They can alter history, and they can make you keep paying for things that you formerly could
...继续阅读
(26)
发表于
2016-03-15 16:37:23
Watch Movie Online Tammy (2014) subtitle english
Tammy (2014)HDDirector:Ben Falcone.Writer:Ben Falcone, Melissa McCarthy.Producer:Adam McKay, Melissa McCarthy, Will Ferrell.Release:July 2, 2014Country:United States of America.Production Company:New Line Cinema, Gary Sanchez Productions.Language:English.Runtime:97 min.Genre:Comedy.‘Tammy’ is a movie genre Comedy, was released in July 2, 2014. Ben Falcone was directed this movie and starring by Melissa McCarthy. This movie tell story about After losing her job and learning that her husband has been unfaithful, a woman hits the road with her profane, hard-drinking grandmother.Do not
...继续阅读
(22)
发表于
2016-03-07 09:50:19
Machine Learning With Spark Note 1:数据基本处理
发表于
2015-12-25 07:30:40
Movie Effects – 为视频添加电影效果[OS X][￥12→0]
发表于
2015-12-21 23:47:14
ffmpeg截取视频指定帧为图片，获取rotation信息并旋转
截取视频指定帧为图片，php ffmpeg扩展已经完美实现：$movie = new ffmpeg_movie($video_filePath);
$ff_frame = $movie->getFrame(1);
$gd_image = $ff_frame->toGDImage();
$img="./test.jpg";
imagejpeg($gd_image, $img);
imagedestroy($gd_image);然而问题来了，智能手机拍摄的视频，由于拍摄方向不同，视频会被旋转，并带上meta信息rotate，当你相对视频截取frame图片的时候，如果有rotate信息的视频，frame也是旋转的，因此你需要将截取的图片相应的旋转。然后php ffmpeg扩展并无法获知rotation信息(php ffmpeg扩展文档),但可以通过ffmpeg命令行获取：/usr/local/ffmpeg/bin/ffprobe test.mp4 -show_streams | grep rotate用php简单封装下如下：function get_video_orientation($video_path) {
$cmd = "/usr/local/ffmpeg/bin/ffprobe " . $video_path . " -show_streams 2>
...继续阅读
(44)
发表于
2015-12-21 10:00:20
在nodejs编写的服务端下，html页面找不到图片地址的问题
首先我完成了nodejs服务器代码的编写，然后通过localhost+端口号，访问页面，但页面中的图片没有加载出来。
先说下目录结构，页面：page/cloud/client/index.html。而图片是：page/public/download/…/images/1.jpg.
然后我在index.html中是这样引用的…/…/public/download/movie.douban.com/2353023/images/1.jpg
结果报错:"NetworkError: 404 Not Found -http://localhost:3001/public/download/movie.douban.com/2353023/images/1.jpg".
我自己在本地试着建了个相似的目录结果是图片能找到，所以请教下各种这个问题怎么解决？
...继续阅读
(25)
发表于
2015-12-21 07:59:21
Movie Mistakes：2015年穿帮最多电影排行：《速度与激情7》居首
发表于
2015-12-19 02:22:13
‘Star Wars’ cast members really weren’t great at keeping movie secrets – ‘星球大战’剧组成员真的不太好，在保持电影秘密
发表于
2015-12-18 13:45:30
You can view Star Wars Episode IV in ASCII on Windows 10. ‘Cuz Nerds – 你可以看星球大战IV对Windows 10的ASCII码。”因为书呆子
It's not easy to see an untouched original ofStar Wars: Episode IVanymore. We should know. Wedid it. It is, however, still pretty easy to see the whole move in ASCII on Windows 10.看到一个未被触及的原始的星球大战：第四集已经不容易了。我们应该知道。我们做到了。它是，但是，仍然很容易看到Windows 10的ASCII的整体搬迁。Why, you want to view a two hour movie as what is essentially a text scroll? If you have to ask, you don’t understand nerd culture.为什么，你想看一二小时的电影，因为基本上是一个文字滚动？如果你要问，你不# 8217；不明白人文化。See also:The search for the 'Star Wars' George Lucas doesn't want you to see又见：搜索“星球大战”乔治卢卡斯不想让你看到又见：搜索“星球大战”乔治卢卡斯不想让你看到ASCII, by the way, stands for "America
...继续阅读
(37)
发表于
2015-12-18 11:11:52
Crowd lets hate flow through them when projector breaks during ‘Force Awakens’ – 人群让恨流通过他们当投影机休息力觉醒”
WeStar Warsfans have a recurring nightmare. It goes like this: We wait a decade for a new film, spend hours in line in order to get a good seat...then only get to watch a portion of the movie because the projector is broken.我们星球大战迷们有一个经常性的噩梦。这是这样的：我们等待了十年的一部新电影，花几个小时排队，为了获得一个好的座位…然后只得到观看电影的一部分，因为投影机被打破。For an opening night audience at Hollywood’s Arclight Cinemas, the nightmare was a reality.在好莱坞和# 8217开幕当晚的观众；弧光电影院，噩梦是一个现实。An attendee at the showing uploaded a video to Facebook of the moment just after the projectors went out. The audience is in an uproar. Several moviegoers are turned
...继续阅读
(21)
发表于
2015-12-18 10:08:33
Confirmed: John Krasinski has arms – 证实：约翰Krasinski有武器
You might remember John Krasinski fromThe Office, where he wore workplace-appropriate button-down shirts and blazers. Perhaps you also saw in in a movie or two. Either way, you probably didn't really notice his arms你可能还记得从办公室里他穿着工作约翰Krasinski，合适的衬衫和夹克。也许你也在一部电影中看到了。不管怎样，你可能没注意到他的手臂Now you will, because they've gotten bigger.现在你会，因为他们已经变得更大。See also:8 celebrities who spoke out against Photoshop in 2015参见：8名人反对Photoshop 2015参见：8名人反对Photoshop 2015Thank you to@MensHealthMagfor putting this dude on the coverpic.twitter.com/S3lmd5g0Qr谢谢你@ menshealthmag把这家伙在coverpic.twitter.com/s3lmd5g0qr— John
...继续阅读
(21)
发表于
2015-12-18 08:06:30
The Peanuts Movie (2015)
Charlie Brown, Snoopy, Lucy, Linus and the rest of the beloved “Peanuts” gang make their big-screen debut, like they’ve never been seen before, in state of the art 3D animation. Charlie Brown, the world’s most beloved underdog, embarks upon an epic and heroic quest, while his best pal, the lovable beagle Snoopy, takes to the […]
...继续阅读
(23)
发表于
2015-12-18 07:25:24
Daniel Craig was in ‘Star Wars: The Force Awakens’ – 丹尼尔克雷格是在“星球大战：原力觉醒”
Warning: this article contains minorStar Wars: TheForceAwakensspoilers.警告：本文包含小星球大战：原力唤醒破坏者。LONDON— James Bond was inStar WarsTheJames Bond. Actual James Bond伦敦和# 8212；杰姆斯在杰姆斯星的战争债券债券。实际杰姆斯债券See also:People are losing it over George Osborne's possible 'Star Wars' credit还有：人们正在失去它在奥斯本的可能的'星球大战'信用还有：人们正在失去它在奥斯本的可能的'星球大战'信用Yep, Hollywood A-lister Daniel Craig reportedly took a step out of the limelight to lend his acting skills to the hugely challenging and potentiallylife-changing role of Stormtrooper in the franchise's new movie.是的，好莱坞的大明星丹尼尔克雷格据说走了一步，出借给他的演技的巨大挑战，在特许经营的新电影冲锋队可能改变生活的作用。Ac
...继续阅读
(53)
发表于
2015-12-18 05:38:30
The Peanuts Movie (2015)
Charlie Brown, Snoopy, Lucy, Linus and the rest of the beloved “Peanuts” gang make their big-screen debut, like they’ve never been seen before, in state of the art 3D animation. Charlie Brown, the world’s most beloved underdog, embarks upon an epic and heroic quest, while his best pal, the lovable beagle Snoopy, takes to the […]
...继续阅读
(23)
发表于
2015-12-18 04:03:25
‘Bajirao Mastani’ review: A visually spectacular, star-crossed romance – “bajirao mastani回顾：一个非常壮观，不幸的爱情
