Internal hard drive bay and hot-plug backplane:
Up to 18 x 1.8” SSD: SATA
Up to 24 x 2.5” + 2 x 2.5” HDD: SAS, SATA, Near-line SAS SSD: SAS, SATA, up to 4 NVMe Express Flash PCIe
Up to 16 x 3.5” + 2 x 2.5” HDD: SAS, SATA, Near-line SAS SSD: SAS, SATA
[查看图片]
前面板的右侧是一个USB接口(iDRAC Direct ports)一个VGA接口 [查看图片]
左侧一个电源按钮,一个Non-maskable Interrupt(NMI),下面是一个系统ID按钮,中间有六个指示灯,后面的图片的话应该能看得更清楚。 [查看图片]
前面板的上方有一个EST标签,内含Service Tag和Express Service Code [查看图片]
上面有个配置图。。。。大家可以了解一下。。。可以看到后面有24和25盘位。 [查看图片]
Average number of seconds to run all queries: 495.781 seconds.
Minimum number of seconds to run all queries: 495.781 seconds.
Maximum number of seconds to run all queries: 495.781 seconds.
Number of clients running queries: 100
Average number of queries per client: 0
Average number of seconds to run all queries: 139.984 seconds.
Minimum number of seconds to run all queries: 139.984 seconds.
Maximum number of seconds to run all queries: 139.984 seconds.
Number of clients running queries: 100
Average number of queries per client: 0
Average number of seconds to run all queries: 1.515 seconds.
Minimum number of seconds to run all queries: 1.515 seconds.
Maximum number of seconds to run all queries: 1.515 seconds.
Number of clients running queries: 100
Average number of queries per client: 0
Average number of seconds to run all queries: 0.531 seconds.
Minimum number of seconds to run all queries: 0.531 seconds.
Maximum number of seconds to run all queries: 0.531 seconds.
Number of clients running queries: 100
Average number of queries per client: 0
============================
只跑了query和write因为execute昨天下午跑了俩点都没跑完。。。
mysqlslap.exe --auto-generate-sql-execute-number=100 --create-schema=test -c 50 -p
===
话说昨天想生成随机数据跑测试的时候把MySQL玩炸了 [查看图片]
MySQL Server has gone away哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈
===
上面的故事告诉我们:
0.做数据库不管你用机械还是固态请使用RAID5做阵列并且选好阵列卡不然不如不组阵列
1.做好buffer你会爽死,因为query的话会直接从内存里读取。这又引出第二条。
2.选好内存,如果服务器专门用来做数据库的话估算好自己需要多少内存才能把整个数据库全buffer到内存里,当然像我这样预算不够就没办法了(
我好菜啊.jpg
============================