@cryptotaxi247 / netdata-1
Code Commits Issues Pulls Sessions CI/CD
master
master
sql 57 lines 1.65 KB
Raw
1 CREATE TABLE IF NOT EXISTS sample (
2 id INT AUTO_INCREMENT PRIMARY KEY,
3 name VARCHAR(64) NOT NULL,
4 value INT NOT NULL
5 );
6
7 -- Tables for deadlock induction tests.
8 CREATE TABLE IF NOT EXISTS deadlock_a (
9 id INT PRIMARY KEY,
10 value INT NOT NULL
11 ) ENGINE=InnoDB;
12
13 CREATE TABLE IF NOT EXISTS deadlock_b (
14 id INT PRIMARY KEY,
15 value INT NOT NULL
16 ) ENGINE=InnoDB;
17
18 INSERT INTO deadlock_a (id, value) VALUES (1, 10);
19 INSERT INTO deadlock_b (id, value) VALUES (1, 20);
20
21 -- Table for error category testing (constraint violations, data type errors).
22 CREATE TABLE IF NOT EXISTS error_test (
23 id INT PRIMARY KEY,
24 unique_col VARCHAR(64) UNIQUE NOT NULL,
25 int_col INT NOT NULL
26 ) ENGINE=InnoDB;
27
28 INSERT INTO error_test (id, unique_col, int_col) VALUES (1, 'existing_value', 100);
29
30 -- Ensure statement digest collection is enabled.
31 UPDATE performance_schema.setup_consumers
32 SET ENABLED = 'YES'
33 WHERE NAME IN (
34 'events_statements_summary_by_digest',
35 'events_statements_summary_by_program',
36 'events_statements_summary_by_user_by_event_name',
37 'events_statements_summary_by_host_by_event_name',
38 'events_statements_summary_by_thread_by_event_name'
39 );
40 UPDATE performance_schema.setup_instruments
41 SET ENABLED = 'YES', TIMED = 'YES'
42 WHERE NAME LIKE 'statement/%';
43
44 GRANT USAGE, REPLICATION CLIENT, PROCESS ON *.* TO 'netdata'@'%';
45 GRANT SELECT ON performance_schema.* TO 'netdata'@'%';
46 FLUSH PRIVILEGES;
47
48 INSERT INTO sample (name, value)
49 VALUES
50 ('alpha', 10),
51 ('beta', 20),
52 ('gamma', 30);
53
54 SELECT COUNT(*) FROM sample;
55 SELECT * FROM sample WHERE value > 15;
56 UPDATE sample SET value = value + 1 WHERE name = 'alpha';
57 SELECT * FROM sample WHERE name = 'beta';