Slide 27
Slide 27 text
負荷分散による性能向上:準備
• テーブル定義 • VSchema定義(json)
27
CREATE TABLE messages (
page BIGINT(20) UNSIGNED,
time_created_ns BIGINT(20) UNSIGNED,
message VARCHAR(10000),
PRIMARY KEY (page, time_created_ns)
) ENGINE=InnoDB
{
"sharded": true,
"vindexes": {
"hash": {
"type": "hash"
}},
"tables": {
"messages": {
"column_vindexes": [
{
"column": "page",
"name": "hash"
}]}}}