V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
V2EX  ›  Tianpu  ›  全部回复第 15 页 / 共 25 页
回复总数  492
1 ... 11  12  13  14  15  16  17  18  19  20 ... 25  
2014-01-06 22:12:46 +08:00
回复了 Tianpu 创建的主题 程序员 探讨 - 缓存存储方案:mysql vs memcached
结论似乎是mysql并发不行 貌似就是一般结论了 好处是mysql相对更加持久和不怕重启 哎 我还是改回memcached吧

多些楼上各位 都送钱了
2014-01-06 22:10:39 +08:00
回复了 Tianpu 创建的主题 程序员 探讨 - 缓存存储方案:mysql vs memcached
@Maslino ab测试不能说明问题 又没有别的测试 我就贴下吧

**********************************************************************

128并发:

方案一:
Write errors: 0
Total transferred: 200530818 bytes
HTML transferred: 198350958 bytes
Requests per second: 822.91 [#/sec] (mean)
Time per request: 155.545 [ms] (mean)
Time per request: 1.215 [ms] (mean, across all concurrent requests)
Transfer rate: 15737.46 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 13 22.8 1 133
Processing: 10 142 53.2 142 676
Waiting: 0 131 57.5 137 676
Total: 11 155 51.1 147 705

Percentage of the requests served within a certain time (ms)
50% 147
66% 161
75% 173
80% 181
90% 209
95% 237
98% 279
99% 318
100% 705 (longest request)


方案二:
Write errors: 0
Total transferred: 200939520 bytes
HTML transferred: 198758400 bytes
Requests per second: 819.24 [#/sec] (mean)
Time per request: 156.241 [ms] (mean)
Time per request: 1.221 [ms] (mean, across all concurrent requests)
Transfer rate: 15699.26 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 21 27.1 6 137
Processing: 9 135 51.5 129 445
Waiting: 1 118 56.1 112 434
Total: 12 156 51.9 149 445

Percentage of the requests served within a certain time (ms)
50% 149
66% 169
75% 187
80% 195
90% 223
95% 248
98% 279
99% 308
100% 445 (longest request)

*********************************************************************


1024并发:

方案一:
Write errors: 0
Total transferred: 200336198 bytes
HTML transferred: 198156938 bytes
Requests per second: 801.65 [#/sec] (mean)
Time per request: 1277.367 [ms] (mean)
Time per request: 1.247 [ms] (mean, across all concurrent requests)
Transfer rate: 15315.95 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 51 98.1 1 623
Processing: 32 1191 540.9 1237 3749
Waiting: 7 1090 471.4 1221 3474
Total: 96 1241 518.5 1251 4039

Percentage of the requests served within a certain time (ms)
50% 1251
66% 1315
75% 1355
80% 1519
90% 1848
95% 2017
98% 2366
99% 3112
100% 4039 (longest request)


方案二:

Total transferred: 200939520 bytes
HTML transferred: 198758400 bytes
Requests per second: 824.39 [#/sec] (mean)
Time per request: 1242.128 [ms] (mean)
Time per request: 1.213 [ms] (mean, across all concurrent requests)
Transfer rate: 15797.89 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 70 113.6 12 597
Processing: 14 1131 484.6 1066 2970
Waiting: 9 1011 461.8 992 2431
Total: 47 1201 452.1 1176 2970

Percentage of the requests served within a certain time (ms)
50% 1176
66% 1279
75% 1426
80% 1532
90% 1800
95% 1959
98% 2328
99% 2657
100% 2970 (longest request)


************************************************************************

高并发mysql的确不如memcached 一般并发 mysql劣势不是很明显

一般情况下,只读是这样子的:

方案一:

73dc7f908ca127684c9cb874dbc3392d
73dc7f908ca127684c9cb874dbc3392d
73dc7f908ca127684c9cb874dbc3392d
73dc7f908ca127684c9cb874dbc3392d
73dc7f908ca127684c9cb874dbc3392d
73dc7f908ca127684c9cb874dbc3392d
73dc7f908ca127684c9cb874dbc3392d
73dc7f908ca127684c9cb874dbc3392d
73dc7f908ca127684c9cb874dbc3392d

load in 0.000408888s

方案二:

23618634799318c968a5a35c8cac0974
23618634799318c968a5a35c8cac0974
23618634799318c968a5a35c8cac0974
23618634799318c968a5a35c8cac0974
23618634799318c968a5a35c8cac0974
23618634799318c968a5a35c8cac0974
23618634799318c968a5a35c8cac0974
23618634799318c968a5a35c8cac0974
23618634799318c968a5a35c8cac0974

load in 0.000947952s
2013-11-11 15:03:34 +08:00
回复了 Tianpu 创建的主题 Linux debian sid作为生产系统可以吗?
@KDr2 我估计需要的部分就是基本系统 然后装上

实在是忍受不了ubuntu和centos 这会开始测试openbsd 如果可以用这个感觉也还好
2013-11-09 09:16:58 +08:00
回复了 Tianpu 创建的主题 问与答 有英语口语好的可以帮我打个电话吗?
@horx
@xiongke

流程我清楚啊 问题是我口语不够好
2013-11-06 21:30:13 +08:00
回复了 Tianpu 创建的主题 BTSync BitTorrent Sync看起来很不错啊
我也崩溃过几次 win7 最近一个小时好多了

下载速度太快的话不稳定?

这会没测试18+了 速度低下来了
@manhere
2013-11-06 20:22:11 +08:00
回复了 Tianpu 创建的主题 BTSync BitTorrent Sync看起来很不错啊
RYP47RLKJJSEZOY3Z3JASB66CSMZD7MZN

这个速度很快 桌面壁纸
2013-10-30 14:51:07 +08:00
回复了 pyKun 创建的主题 SmartOS SmartOS的zone背后是怎么实现的?
opensolaris
2013-10-05 19:40:17 +08:00
回复了 Tianpu 创建的主题 奇思妙想 Writings.io有感
@zorceta
我想的是只展示记事本能展示的
2013-08-31 10:56:31 +08:00
回复了 Tianpu 创建的主题 服务器 hetzner killer
Benchmark Run: Sat Aug 31 2013 01:57:22 - 02:26:05
8 CPUs in system; running 1 parallel copy of tests

Dhrystone 2 using register variables 41817426.0 lps (10.0 s, 7 samples)
Double-Precision Whetstone 4559.7 MWIPS (9.9 s, 7 samples)
Execl Throughput 3473.1 lps (29.9 s, 2 samples)
File Copy 1024 bufsize 2000 maxblocks 1601231.6 KBps (30.0 s, 2 samples)
File Copy 256 bufsize 500 maxblocks 439823.9 KBps (30.0 s, 2 samples)
File Copy 4096 bufsize 8000 maxblocks 3414774.8 KBps (30.0 s, 2 samples)
Pipe Throughput 3024067.8 lps (10.0 s, 7 samples)
Pipe-based Context Switching 131730.9 lps (10.0 s, 7 samples)
Process Creation 10282.5 lps (30.0 s, 2 samples)
Shell Scripts (1 concurrent) 6083.2 lpm (60.0 s, 2 samples)
Shell Scripts (8 concurrent) 2524.9 lpm (60.0 s, 2 samples)
System Call Overhead 5090329.1 lps (10.0 s, 7 samples)

System Benchmarks Index Values BASELINE RESULT INDEX
Dhrystone 2 using register variables 116700.0 41817426.0 3583.3
Double-Precision Whetstone 55.0 4559.7 829.0
Execl Throughput 43.0 3473.1 807.7
File Copy 1024 bufsize 2000 maxblocks 3960.0 1601231.6 4043.5
File Copy 256 bufsize 500 maxblocks 1655.0 439823.9 2657.5
File Copy 4096 bufsize 8000 maxblocks 5800.0 3414774.8 5887.5
Pipe Throughput 12440.0 3024067.8 2430.9
Pipe-based Context Switching 4000.0 131730.9 329.3
Process Creation 126.0 10282.5 816.1
Shell Scripts (1 concurrent) 42.4 6083.2 1434.7
Shell Scripts (8 concurrent) 6.0 2524.9 4208.2
System Call Overhead 15000.0 5090329.1 3393.6
========
System Benchmarks Index Score 1886.5

------------------------------------------------------------------------
Benchmark Run: Sat Aug 31 2013 02:26:05 - 02:54:33
8 CPUs in system; running 8 parallel copies of tests

Dhrystone 2 using register variables 154017417.8 lps (10.0 s, 7 samples)
Double-Precision Whetstone 28406.2 MWIPS (9.9 s, 7 samples)
Execl Throughput 36548.5 lps (29.9 s, 2 samples)
File Copy 1024 bufsize 2000 maxblocks 994619.0 KBps (30.0 s, 2 samples)
File Copy 256 bufsize 500 maxblocks 268745.4 KBps (30.0 s, 2 samples)
File Copy 4096 bufsize 8000 maxblocks 2826491.7 KBps (30.0 s, 2 samples)
Pipe Throughput 13418427.5 lps (10.0 s, 7 samples)
Pipe-based Context Switching 3078853.9 lps (10.0 s, 7 samples)
Process Creation 116954.7 lps (30.0 s, 2 samples)
Shell Scripts (1 concurrent) 52541.5 lpm (60.0 s, 2 samples)
Shell Scripts (8 concurrent) 6860.9 lpm (60.0 s, 2 samples)
System Call Overhead 10108912.2 lps (10.0 s, 7 samples)

System Benchmarks Index Values BASELINE RESULT INDEX
Dhrystone 2 using register variables 116700.0 154017417.8 13197.7
Double-Precision Whetstone 55.0 28406.2 5164.8
Execl Throughput 43.0 36548.5 8499.7
File Copy 1024 bufsize 2000 maxblocks 3960.0 994619.0 2511.7
File Copy 256 bufsize 500 maxblocks 1655.0 268745.4 1623.8
File Copy 4096 bufsize 8000 maxblocks 5800.0 2826491.7 4873.3
Pipe Throughput 12440.0 13418427.5 10786.5
Pipe-based Context Switching 4000.0 3078853.9 7697.1
Process Creation 126.0 116954.7 9282.1
Shell Scripts (1 concurrent) 42.4 52541.5 12391.9
Shell Scripts (8 concurrent) 6.0 6860.9 11434.9
System Call Overhead 15000.0 10108912.2 6739.3
========
System Benchmarks Index Score 6719.6
2013-08-31 10:24:12 +08:00
回复了 Tianpu 创建的主题 服务器 hetzner killer
HW RAID1
在运行unixbench了
2013-08-31 10:20:16 +08:00
回复了 Tianpu 创建的主题 服务器 hetzner killer
无缓存写140MB/s
2013-08-31 10:11:55 +08:00
回复了 Tianpu 创建的主题 服务器 hetzner killer
2013-08-30 18:17:07 +08:00
回复了 Tianpu 创建的主题 服务器 hetzner killer
@qiuai

还是peding状态 波兰人的生意

第一印象比较久 应该有几年了

德国Equinix机房,觉得应该不至于不能用吧

好了后我发下硬盘速度和整体测分 比较关注这个


可能是旧硬件,因为这价格比hetzner还惊人 还不带setup fee
2013-07-05 13:54:48 +08:00
回复了 Tianpu 创建的主题 程序员 豆瓣用js console招聘啊
@akalanala
@qiqiboy
@BOYPT
@cxshun
@DaniloSam
@clippit

看来只好自己写了 就是想偷懒下 我想输出的html比较简单些 然后能不让jquery污染代码

先不感谢了 等我造好自己的轮子 所有参与者全部送钱吧
2013-07-04 19:30:41 +08:00
回复了 Tianpu 创建的主题 程序员 豆瓣用js console招聘啊
@saggit 谢谢 这个库也好大啊
2013-07-04 18:57:26 +08:00
回复了 Tianpu 创建的主题 程序员 豆瓣用js console招聘啊
@zythum 那可能是我本地的问题 有印象哪里有吗? 我实在是不想写了 哎
2013-07-04 18:50:17 +08:00
回复了 Tianpu 创建的主题 程序员 豆瓣用js console招聘啊
@zythum 好看的<select><option>美化方案吧 豆瓣这个就算 http://sh.ganji.com/weixiu/ 搜索框右侧的分类选择也是 英文关键字是js drop-down select without jquery 反正我是找不到不带jquery的

还有,你的图床挂了 每次我上传图片都去你的图床 然后今天不行了 登录也卡死在上传的进度条 于是我自己登录微博上传了
雨量一定 承受雨水的面积一定 占据所有雨水的比例一定 难道还有什么不确定?

就比如100个人分1000块钱,怎么都是一个人10块钱
2013-04-27 22:40:13 +08:00
回复了 kopp123 创建的主题 问与答 戒了4次烟都已失败告终,有谁戒烟成功过吗
我觉得这和个人意志力关联而已
达尔的移动城堡
1 ... 11  12  13  14  15  16  17  18  19  20 ... 25  
关于   ·   帮助文档   ·   博客   ·   API   ·   FAQ   ·   实用小工具   ·   6034 人在线   最高记录 6679   ·     Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 39ms · UTC 02:10 · PVG 10:10 · LAX 18:10 · JFK 21:10
Developed with CodeLauncher
♥ Do have faith in what you're doing.