File: index_stat_kernel.result

package info (click to toggle)
mysql-8.0 8.0.43-3
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 1,273,924 kB
  • sloc: cpp: 4,684,605; ansic: 412,450; pascal: 108,398; java: 83,641; perl: 30,221; cs: 27,067; sql: 26,594; sh: 24,181; python: 21,816; yacc: 17,169; php: 11,522; xml: 7,388; javascript: 7,076; makefile: 2,194; lex: 1,075; awk: 670; asm: 520; objc: 183; ruby: 97; lisp: 86
file content (16 lines) | stat: -rw-r--r-- 433 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
CREATE TABLE table_with_one_index (
a INT NOT NULL,
b INT NOT NULL,
PRIMARY KEY USING HASH (a),
INDEX (b)
) ENGINE NDB;
Check if the stats have been automatically created
stats_created
YES
Insert rows to trigger automatic update of stats
Wait for stats update
Stats automatically updated
Insert more rows to trigger another automatic update of stats
Wait for stats update
Stats automatically updated
DROP TABLE table_with_one_index;