V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
V2EX  ›  coolwind  ›  全部回复第 3 页 / 共 4 页
回复总数  74
1  2  3  4  
另外,一些只有声音的儿歌应用
ios8 可以打开应用后关闭保护套并继续播放
ios9 关闭保护套一下子就停止播放了,只能开着
2015-09-09 09:18:53 +08:00
回复了 coolwind 创建的主题 分享发现 office 365 订阅的 onedrive 包含无限空间,难道要实现了?
2015-09-01 16:47:49 +08:00
回复了 coolwind 创建的主题 分享发现 office 365 订阅的 onedrive 包含无限空间,难道要实现了?
2015-09-01 16:04:26 +08:00
回复了 coolwind 创建的主题 分享发现 office 365 订阅的 onedrive 包含无限空间,难道要实现了?
@fetich
taobao 上,自行搜索,选便宜的就好!
Master 执行看看 mysql-bin.000060 的 4951916 是什么内容,想想这条命令对应的 data 在 slave 上为何不见了
SHOW BINLOG EVENTS IN 'mysql-bin.000060' FROM 4951916 LIMIT 10;
2015-08-17 15:54:33 +08:00
回复了 coolwind 创建的主题 分享发现 office 365 订阅的 onedrive 包含无限空间,难道要实现了?
@a3697782 英文一样不好,给微软两封邮件,回复比较慢
HI

My Office 365 account had access to unlimited OneDrive storage (added 10 TB )

My OneDrive storage just has 143GB free space (I stoped sync files ), I still have 2TB files to upload



Could you please give me more additional storage for onedrive?

Thanks very much!

Regards



HI

My Office 365 account had access to unlimited OneDrive storage (added 10 TB )

I have used 9.3TB of OneDrive storage, but I still have 2TB files to upload.
The total space of approximately 12TB

Could you please give me more additional storage for onedrive?

Thanks very much!

Regards
2015-07-17 16:13:17 +08:00
回复了 lezhou 创建的主题 微软 office 365 家庭版用户,升级到 one drive 无限空间的进来
@c742435 视频
2015-07-17 11:35:56 +08:00
回复了 lezhou 创建的主题 微软 office 365 家庭版用户,升级到 one drive 无限空间的进来
申请后要几天,或许最长数周才会开通10TB

我的用到9TB后,也没有自动增加空间;后来写信给微软,大概两周,给增加到50TB
2015-06-24 16:48:52 +08:00
回复了 coolwind 创建的主题 分享发现 office 365 订阅的 onedrive 包含无限空间,难道要实现了?
@happyface 默认只有1TB 要到 https://preview.onedrive.com/ 申请注册成功后才有 10TB


@KexyBiscuit 中华电信企业网100Mbps 慢慢传 1天 100GB 传了3个月,呵呵
2015-06-24 13:23:30 +08:00
回复了 coolwind 创建的主题 分享发现 office 365 订阅的 onedrive 包含无限空间,难道要实现了?
@squid157 视频
2015-05-19 09:00:37 +08:00
回复了 lawdoge 创建的主题 macOS 深夜求大神 Yosemite 开机出现禁止符号
https://www.cindori.org/trim-enabler-and-yosemite/

最后一个换一下试一试, Your Disk name要用您的硬盘名,通常是 Macintosh HD
cd "/Volumes/Your Disk Name"
touch System/Library/Extensions
kextcache -u "/Volumes/Your Disk name"
2015-05-18 08:36:09 +08:00
回复了 twitchgg 创建的主题 问与答 OneDrive 同步速度奇慢无比
台湾100Mbps的上下对称的带宽,一个线程上传,一天也就上传100G左右;目前传了7TB左右,剩余3TB空间, 耗时很长,没有空间了找微软问一下,看看能不能无限空间(目前10TB)
2015-04-27 18:13:08 +08:00
回复了 fyooo 创建的主题 4G 联通的 4G 真的最小只需要 8 块可以包月么?
我有一张成都联通全国自由组合套餐, 8元100MB, 没有选来电显示,但来电一直都有号码显示的!
2015-03-19 10:40:02 +08:00
回复了 coolwind 创建的主题 MacBook Pro macbook pro early 2011 还有升级 ssd 和内存的必要吗?
macbook pro 13‘’ early 2011已升级intel ssd 730 240G + 16G内存(Crucial英睿达 镁光低电压 DDR3 1600 8G 笔记本内存条) 效果提升明显,感恩各位!
2015-03-19 10:30:58 +08:00
回复了 tab 创建的主题 macOS 升级到 Yosemite,程序开多了导致系统很卡怎么破?
接着升16G内存
2015-03-15 09:43:00 +08:00
回复了 ccc1924 创建的主题 NGINX NGINX 编译安装出错,如何解决
2015-03-01 13:54:20 +08:00
回复了 liuhaotian 创建的主题 问与答 php+mysql 如何优雅的分页
没有用到索引,确实是全表扫描,然后用文件排序(这种速度很慢)
mysql> explain select * from piwigo_history order by id limit 100000,10;
+----+-------------+----------------+------+---------------+------+---------+------+---------+----------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------------+------+---------------+------+---------+------+---------+----------------+
| 1 | SIMPLE | piwigo_history | ALL | NULL | NULL | NULL | NULL | 6784937 | Using filesort |
+----+-------------+----------------+------+---------------+------+---------+------+---------+----------------+
1 row in set (0.00 sec)

mysql> select @@version;
+------------+
| @@version |
+------------+
| 5.1.73-log |
+------------+
1 row in set (0.00 sec)

当然,如果您不需要排序的话,直接limit速度还是不错
mysql> select * from piwigo_history limit 5000000,10;
10 rows in set (1.50 sec)

mysql> select * from piwigo_history limit 6000000,10;

10 rows in set (1.84 sec)
2015-03-01 11:57:15 +08:00
回复了 liuhaotian 创建的主题 问与答 php+mysql 如何优雅的分页
您这种方式,速度也不错
mysql> select * from piwigo_history where id>=(select id from piwigo_history order by id limit 6783400,1) order by id limit 10;
10 rows in set (1.25 sec)

mysql> select * from piwigo_history where id>=(select id from piwigo_history order by id limit 6783410,1) order by id limit 10;
10 rows in set (1.33 sec)

mysql> select * from piwigo_history where id>=(select id from piwigo_history order by id limit 6783420,1) order by id limit 10;
10 rows in set (1.37 sec)
2015-03-01 11:51:40 +08:00
回复了 liuhaotian 创建的主题 问与答 php+mysql 如何优雅的分页
数据越大,取越后面的记录,差异越大(mysql 5.1不支持上面的带limit的子查询,可以改为innder join)

select count(*) from piwigo_history;
+----------+
| count(*) |
+----------+
| 6783731 |
+----------+
1 row in set (0.00 sec)

mysql> select a.* from piwigo_history as a inner join (select id from piwigo_history order by id limit 6783400,10) as b on a.id=b.id order by a.id;
10 rows in set (1.24 sec)

mysql> select a.* from piwigo_history as a inner join (select id from piwigo_history order by id limit 6783410,10) as b on a.id=b.id order by a.id;
10 rows in set (1.32 sec)

mysql> select a.* from piwigo_history as a inner join (select id from piwigo_history order by id limit 6783420,10) as b on a.id=b.id order by a.id;
10 rows in set (1.34 sec)


直接读取
mysql> select * from piwigo_history order by id limit 6783400,10;
10 rows in set (12.76 sec)

mysql> select * from piwigo_history order by id limit 6783410,10;
10 rows in set (14.33 sec)

mysql> select * from piwigo_history order by id limit 6783420,10;
10 rows in set (13.13 sec)
2015-03-01 11:36:06 +08:00
回复了 liuhaotian 创建的主题 问与答 php+mysql 如何优雅的分页
数据量大的话 select * from ? where id in (select id from ? order by id limit (x-1)*y,y) 效率高

小的话,直接limit要高点
1  2  3  4  
关于   ·   帮助文档   ·   博客   ·   API   ·   FAQ   ·   实用小工具   ·   1175 人在线   最高记录 6679   ·     Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 28ms · UTC 18:19 · PVG 02:19 · LAX 11:19 · JFK 14:19
Developed with CodeLauncher
♥ Do have faith in what you're doing.