~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty : revision 1

1

update performance_schema.setup_consumers

2

set enabled='NO' where name like 'event%';

3

delete from performance_schema.setup_objects

4

where object_name='t2';

5

select * from performance_schema.setup_actors

6

order by USER, HOST, ROLE;

7

HOST USER ROLE

8

localhost user1 %

9

localhost user2 %

10

localhost user3 %

11

localhost user4 %

12

select * from performance_schema.setup_objects

13

order by object_type, object_schema, object_name;

14

OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED

15

TABLE test t1 YES YES

16

TABLE test t3 YES NO

17

select * from performance_schema.setup_consumers;

18

NAME ENABLED

19

events_stages_current NO

20

events_stages_history NO

21

events_stages_history_long NO

22

events_statements_current NO

23

events_statements_history NO

24

events_statements_history_long NO

25

events_waits_current NO

26

events_waits_history NO

27

events_waits_history_long NO

28

global_instrumentation YES

29

thread_instrumentation YES

30

statements_digest YES

31

flush tables;

32

truncate performance_schema.objects_summary_global_by_type;

33

truncate performance_schema.table_io_waits_summary_by_index_usage;

34

truncate performance_schema.table_io_waits_summary_by_table;

35

truncate performance_schema.table_lock_waits_summary_by_table;

36

truncate performance_schema.events_waits_summary_by_thread_by_event_name;

37

truncate performance_schema.events_waits_summary_by_account_by_event_name;

38

truncate performance_schema.events_waits_summary_by_user_by_event_name;

39

truncate performance_schema.events_waits_summary_by_host_by_event_name;

40

truncate performance_schema.events_waits_summary_global_by_event_name;

41

truncate performance_schema.events_waits_history_long;

42

show variables like "performance_schema%";

43

Variable_name Value

44

performance_schema ON

45

performance_schema_accounts_size 100

46

performance_schema_digests_size 200

47

performance_schema_events_stages_history_long_size 1000

48

performance_schema_events_stages_history_size 10

49

performance_schema_events_statements_history_long_size 1000

50

performance_schema_events_statements_history_size 10

51

performance_schema_events_waits_history_long_size 10000

52

performance_schema_events_waits_history_size 10

53

performance_schema_hosts_size 100

54

performance_schema_max_cond_classes 80

55

performance_schema_max_cond_instances 1000

56

performance_schema_max_file_classes 50

57

performance_schema_max_file_handles 32768

58

performance_schema_max_file_instances 10000

59

performance_schema_max_mutex_classes 200

60

performance_schema_max_mutex_instances 5000

61

performance_schema_max_rwlock_classes 40

62

performance_schema_max_rwlock_instances 5000

63

performance_schema_max_socket_classes 10

64

performance_schema_max_socket_instances 1000

65

performance_schema_max_stage_classes 150

66

performance_schema_max_statement_classes 168

67

performance_schema_max_table_handles 1000

68

performance_schema_max_table_instances 500

69

performance_schema_max_thread_classes 50

70

performance_schema_max_thread_instances 200

71

performance_schema_session_connect_attrs_size 2048

72

performance_schema_setup_actors_size 100

73

performance_schema_setup_objects_size 100

74

performance_schema_users_size 100

75

show status like "performance_schema%";

76

Variable_name Value

77

Performance_schema_accounts_lost 0

78

Performance_schema_cond_classes_lost 0

79

Performance_schema_cond_instances_lost 0

80

Performance_schema_digest_lost 0

81

Performance_schema_file_classes_lost 0

82

Performance_schema_file_handles_lost 0

83

Performance_schema_file_instances_lost 0

84

Performance_schema_hosts_lost 0

85

Performance_schema_locker_lost 0

86

Performance_schema_mutex_classes_lost 0

87

Performance_schema_mutex_instances_lost 0

88

Performance_schema_rwlock_classes_lost 0

89

Performance_schema_rwlock_instances_lost 0

90

Performance_schema_session_connect_attrs_lost 0

91

Performance_schema_socket_classes_lost 0

92

Performance_schema_socket_instances_lost 0

93

Performance_schema_stage_classes_lost 0

94

Performance_schema_statement_classes_lost 0

95

Performance_schema_table_handles_lost 0

96

Performance_schema_table_instances_lost 0

97

Performance_schema_thread_classes_lost 0

98

Performance_schema_thread_instances_lost 0

99

Performance_schema_users_lost 0

100

"================== Step 1 =================="

101

call dump_thread();

102

username status

103

user1 not found

104

username status

105

user2 not found

106

username status

107

user3 not found

108

username status

109

user4 not found

110

execute dump_waits_account;

111

user host event_name count_star

112

execute dump_waits_user;

113

user event_name count_star

114

execute dump_waits_host;

115

host event_name count_star

116

localhost wait/io/table/sql/handler 0

117

localhost wait/lock/table/sql/handler 0

118

execute dump_waits_global;

119

event_name count_star

120

wait/io/table/sql/handler 0

121

wait/lock/table/sql/handler 0

122

execute dump_waits_history;

123

event_name count(event_name) object_type object_schema object_name

124

execute dump_waits_index_io;

125

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

126

TABLE test t1 NULL 0 0 0 0 0 0 0

127

TABLE test t1 index_b 0 0 0 0 0 0 0

128

TABLE test t1 index_cb 0 0 0 0 0 0 0

129

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

130

TABLE test t2 NULL 0 0 0 0 0 0 0

131

TABLE test t2 index_b 0 0 0 0 0 0 0

132

TABLE test t2 index_cb 0 0 0 0 0 0 0

133

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

134

TABLE test t3 NULL 0 0 0 0 0 0 0

135

TABLE test t3 index_b 0 0 0 0 0 0 0

136

TABLE test t3 index_cb 0 0 0 0 0 0 0

137

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

138

execute dump_waits_table_io;

139

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

140

TABLE test t1 0 0 0 0 0 0 0

141

TABLE test t2 0 0 0 0 0 0 0

142

TABLE test t3 0 0 0 0 0 0 0

143

execute dump_waits_table_lock;

144

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

145

TABLE test t1 0 0 0 0 0 0 0 0 0 0 0

146

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

147

TABLE test t3 0 0 0 0 0 0 0 0 0 0 0

148

execute dump_objects_summary;

149

object_type object_schema object_name count_star

150

TABLE test t1 0

151

TABLE test t2 0

152

TABLE test t3 0

153

select concat(current_user(), " is connected") as status;

154

status

155

user1@localhost is connected

156

"================== Step 2 =================="

157

call dump_thread();

158

username event_name count_star

159

user1 wait/io/table/sql/handler 0

160

user1 wait/lock/table/sql/handler 0

161

username status

162

user2 not found

163

username status

164

user3 not found

165

username status

166

user4 not found

167

execute dump_waits_account;

168

user host event_name count_star

169

user1 localhost wait/io/table/sql/handler 0

170

user1 localhost wait/lock/table/sql/handler 0

171

execute dump_waits_user;

172

user event_name count_star

173

user1 wait/io/table/sql/handler 0

174

user1 wait/lock/table/sql/handler 0

175

execute dump_waits_host;

176

host event_name count_star

177

localhost wait/io/table/sql/handler 0

178

localhost wait/lock/table/sql/handler 0

179

execute dump_waits_global;

180

event_name count_star

181

wait/io/table/sql/handler 0

182

wait/lock/table/sql/handler 0

183

execute dump_waits_history;

184

event_name count(event_name) object_type object_schema object_name

185

execute dump_waits_index_io;

186

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

187

TABLE test t1 NULL 0 0 0 0 0 0 0

188

TABLE test t1 index_b 0 0 0 0 0 0 0

189

TABLE test t1 index_cb 0 0 0 0 0 0 0

190

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

191

TABLE test t2 NULL 0 0 0 0 0 0 0

192

TABLE test t2 index_b 0 0 0 0 0 0 0

193

TABLE test t2 index_cb 0 0 0 0 0 0 0

194

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

195

TABLE test t3 NULL 0 0 0 0 0 0 0

196

TABLE test t3 index_b 0 0 0 0 0 0 0

197

TABLE test t3 index_cb 0 0 0 0 0 0 0

198

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

199

execute dump_waits_table_io;

200

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

201

TABLE test t1 0 0 0 0 0 0 0

202

TABLE test t2 0 0 0 0 0 0 0

203

TABLE test t3 0 0 0 0 0 0 0

204

execute dump_waits_table_lock;

205

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

206

TABLE test t1 0 0 0 0 0 0 0 0 0 0 0

207

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

208

TABLE test t3 0 0 0 0 0 0 0 0 0 0 0

209

execute dump_objects_summary;

210

object_type object_schema object_name count_star

211

TABLE test t1 0

212

TABLE test t2 0

213

TABLE test t3 0

214

insert into test.t1 set a=101, b=1, c=1;

215

insert into test.t2 set a=102, b=2, c=2;

216

insert into test.t2 set a=103, b=3, c=3;

217

insert into test.t3 set a=104, b=4, c=4;

218

insert into test.t3 set a=105, b=5, c=5;

219

insert into test.t3 set a=106, b=6, c=6;

220

select * from test.t1;

221

a b c d

222

101 1 1 0

223

select * from test.t2;

224

a b c d

225

102 2 2 0

226

103 3 3 0

227

select * from test.t3;

228

a b c d

229

104 4 4 0

230

105 5 5 0

231

106 6 6 0

232

update test.t1 set d=d+1;

233

update test.t2 set d=d+1;

234

update test.t3 set d=d+1;

235

update test.t1 set d=d+1 where a=101;

236

update test.t2 set d=d+1 where a=101;

237

update test.t3 set d=d+1 where a=101;

238

select * from test.t1 where b=5;

239

a b c d

240

select * from test.t2 where b=5;

241

a b c d

242

select * from test.t3 where b=5;

243

a b c d

244

105 5 5 1

245

"================== con1 marker =================="

246

"================== Step 3 =================="

247

call dump_thread();

248

username event_name count_star

249

user1 wait/io/table/sql/handler 23

250

user1 wait/lock/table/sql/handler 24

251

username status

252

user2 not found

253

username status

254

user3 not found

255

username status

256

user4 not found

257

execute dump_waits_account;

258

user host event_name count_star

259

user1 localhost wait/io/table/sql/handler 23

260

user1 localhost wait/lock/table/sql/handler 24

261

execute dump_waits_user;

262

user event_name count_star

263

user1 wait/io/table/sql/handler 23

264

user1 wait/lock/table/sql/handler 24

265

execute dump_waits_host;

266

host event_name count_star

267

localhost wait/io/table/sql/handler 23

268

localhost wait/lock/table/sql/handler 24

269

execute dump_waits_global;

270

event_name count_star

271

wait/io/table/sql/handler 23

272

wait/lock/table/sql/handler 24

273

execute dump_waits_history;

274

event_name count(event_name) object_type object_schema object_name

275

execute dump_waits_index_io;

276

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

277

TABLE test t1 NULL 4 2 2 2 1 1 0

278

TABLE test t1 index_b 0 0 0 0 0 0 0

279

TABLE test t1 index_cb 0 0 0 0 0 0 0

280

TABLE test t1 PRIMARY 2 1 1 1 0 1 0

281

TABLE test t2 NULL 0 0 0 0 0 0 0

282

TABLE test t2 index_b 0 0 0 0 0 0 0

283

TABLE test t2 index_cb 0 0 0 0 0 0 0

284

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

285

TABLE test t3 NULL 14 8 6 8 3 3 0

286

TABLE test t3 index_b 2 2 0 2 0 0 0

287

TABLE test t3 index_cb 0 0 0 0 0 0 0

288

TABLE test t3 PRIMARY 1 1 0 1 0 0 0

289

execute dump_waits_table_io;

290

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

291

TABLE test t1 6 3 3 3 1 2 0

292

TABLE test t2 0 0 0 0 0 0 0

293

TABLE test t3 17 11 6 11 3 3 0

294

execute dump_waits_table_lock;

295

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

296

TABLE test t1 10 4 6 2 0 0 0 2 0 0 3

297

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

298

TABLE test t3 14 4 10 2 0 0 0 2 0 0 5

299

execute dump_objects_summary;

300

object_type object_schema object_name count_star

301

TABLE test t1 16

302

TABLE test t2 0

303

TABLE test t3 31

304

select concat(current_user(), " is connected") as status;

305

status

306

user2@localhost is connected

307

"================== Step 4 =================="

308

call dump_thread();

309

username event_name count_star

310

user1 wait/io/table/sql/handler 23

311

user1 wait/lock/table/sql/handler 24

312

username event_name count_star

313

user2 wait/io/table/sql/handler 0

314

user2 wait/lock/table/sql/handler 0

315

username status

316

user3 not found

317

username status

318

user4 not found

319

execute dump_waits_account;

320

user host event_name count_star

321

user1 localhost wait/io/table/sql/handler 23

322

user1 localhost wait/lock/table/sql/handler 24

323

user2 localhost wait/io/table/sql/handler 0

324

user2 localhost wait/lock/table/sql/handler 0

325

execute dump_waits_user;

326

user event_name count_star

327

user1 wait/io/table/sql/handler 23

328

user1 wait/lock/table/sql/handler 24

329

user2 wait/io/table/sql/handler 0

330

user2 wait/lock/table/sql/handler 0

331

execute dump_waits_host;

332

host event_name count_star

333

localhost wait/io/table/sql/handler 23

334

localhost wait/lock/table/sql/handler 24

335

execute dump_waits_global;

336

event_name count_star

337

wait/io/table/sql/handler 23

338

wait/lock/table/sql/handler 24

339

execute dump_waits_history;

340

event_name count(event_name) object_type object_schema object_name

341

execute dump_waits_index_io;

342

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

343

TABLE test t1 NULL 4 2 2 2 1 1 0

344

TABLE test t1 index_b 0 0 0 0 0 0 0

345

TABLE test t1 index_cb 0 0 0 0 0 0 0

346

TABLE test t1 PRIMARY 2 1 1 1 0 1 0

347

TABLE test t2 NULL 0 0 0 0 0 0 0

348

TABLE test t2 index_b 0 0 0 0 0 0 0

349

TABLE test t2 index_cb 0 0 0 0 0 0 0

350

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

351

TABLE test t3 NULL 14 8 6 8 3 3 0

352

TABLE test t3 index_b 2 2 0 2 0 0 0

353

TABLE test t3 index_cb 0 0 0 0 0 0 0

354

TABLE test t3 PRIMARY 1 1 0 1 0 0 0

355

execute dump_waits_table_io;

356

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

357

TABLE test t1 6 3 3 3 1 2 0

358

TABLE test t2 0 0 0 0 0 0 0

359

TABLE test t3 17 11 6 11 3 3 0

360

execute dump_waits_table_lock;

361

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

362

TABLE test t1 10 4 6 2 0 0 0 2 0 0 3

363

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

364

TABLE test t3 14 4 10 2 0 0 0 2 0 0 5

365

execute dump_objects_summary;

366

object_type object_schema object_name count_star

367

TABLE test t1 16

368

TABLE test t2 0

369

TABLE test t3 31

370

insert into test.t1 set a=201, b=1, c=1;

371

insert into test.t2 set a=202, b=2, c=2;

372

insert into test.t2 set a=203, b=3, c=3;

373

insert into test.t3 set a=204, b=4, c=4;

374

insert into test.t3 set a=205, b=5, c=5;

375

insert into test.t3 set a=206, b=6, c=6;

376

select * from test.t1;

377

a b c d

378

101 1 1 2

379

201 1 1 0

380

select * from test.t2;

381

a b c d

382

102 2 2 1

383

103 3 3 1

384

202 2 2 0

385

203 3 3 0

386

select * from test.t3;

387

a b c d

388

104 4 4 1

389

105 5 5 1

390

106 6 6 1

391

204 4 4 0

392

205 5 5 0

393

206 6 6 0

394

update test.t1 set d=d+1;

395

update test.t2 set d=d+1;

396

update test.t3 set d=d+1;

397

update test.t1 set d=d+1 where a=201;

398

update test.t2 set d=d+1 where a=201;

399

update test.t3 set d=d+1 where a=201;

400

select * from test.t1 where b=5;

401

a b c d

402

select * from test.t2 where b=5;

403

a b c d

404

select * from test.t3 where b=5;

405

a b c d

406

105 5 5 2

407

205 5 5 1

408

"================== con2 marker =================="

409

"================== Step 5 =================="

410

call dump_thread();

411

username event_name count_star

412

user1 wait/io/table/sql/handler 23

413

user1 wait/lock/table/sql/handler 24

414

username event_name count_star

415

user2 wait/io/table/sql/handler 39

416

user2 wait/lock/table/sql/handler 24

417

username status

418

user3 not found

419

username status

420

user4 not found

421

execute dump_waits_account;

422

user host event_name count_star

423

user1 localhost wait/io/table/sql/handler 23

424

user1 localhost wait/lock/table/sql/handler 24

425

user2 localhost wait/io/table/sql/handler 39

426

user2 localhost wait/lock/table/sql/handler 24

427

execute dump_waits_user;

428

user event_name count_star

429

user1 wait/io/table/sql/handler 23

430

user1 wait/lock/table/sql/handler 24

431

user2 wait/io/table/sql/handler 39

432

user2 wait/lock/table/sql/handler 24

433

execute dump_waits_host;

434

host event_name count_star

435

localhost wait/io/table/sql/handler 62

436

localhost wait/lock/table/sql/handler 48

437

execute dump_waits_global;

438

event_name count_star

439

wait/io/table/sql/handler 62

440

wait/lock/table/sql/handler 48

441

execute dump_waits_history;

442

event_name count(event_name) object_type object_schema object_name

443

execute dump_waits_index_io;

444

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

445

TABLE test t1 NULL 13 8 5 8 2 3 0

446

TABLE test t1 index_b 1 1 0 1 0 0 0

447

TABLE test t1 index_cb 0 0 0 0 0 0 0

448

TABLE test t1 PRIMARY 4 2 2 2 0 2 0

449

TABLE test t2 NULL 0 0 0 0 0 0 0

450

TABLE test t2 index_b 0 0 0 0 0 0 0

451

TABLE test t2 index_cb 0 0 0 0 0 0 0

452

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

453

TABLE test t3 NULL 37 22 15 22 6 9 0

454

TABLE test t3 index_b 5 5 0 5 0 0 0

455

TABLE test t3 index_cb 0 0 0 0 0 0 0

456

TABLE test t3 PRIMARY 2 2 0 2 0 0 0

457

execute dump_waits_table_io;

458

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

459

TABLE test t1 18 11 7 11 2 5 0

460

TABLE test t2 0 0 0 0 0 0 0

461

TABLE test t3 44 29 15 29 6 9 0

462

execute dump_waits_table_lock;

463

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

464

TABLE test t1 20 8 12 4 0 0 0 4 0 0 6

465

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

466

TABLE test t3 28 8 20 4 0 0 0 4 0 0 10

467

execute dump_objects_summary;

468

object_type object_schema object_name count_star

469

TABLE test t1 38

470

TABLE test t2 0

471

TABLE test t3 72

472

select concat(current_user(), " is connected") as status;

473

status

474

user3@localhost is connected

475

"================== Step 6 =================="

476

call dump_thread();

477

username event_name count_star

478

user1 wait/io/table/sql/handler 23

479

user1 wait/lock/table/sql/handler 24

480

username event_name count_star

481

user2 wait/io/table/sql/handler 39

482

user2 wait/lock/table/sql/handler 24

483

username event_name count_star

484

user3 wait/io/table/sql/handler 0

485

user3 wait/lock/table/sql/handler 0

486

username status

487

user4 not found

488

execute dump_waits_account;

489

user host event_name count_star

490

user1 localhost wait/io/table/sql/handler 23

491

user1 localhost wait/lock/table/sql/handler 24

492

user2 localhost wait/io/table/sql/handler 39

493

user2 localhost wait/lock/table/sql/handler 24

494

user3 localhost wait/io/table/sql/handler 0

495

user3 localhost wait/lock/table/sql/handler 0

496

execute dump_waits_user;

497

user event_name count_star

498

user1 wait/io/table/sql/handler 23

499

user1 wait/lock/table/sql/handler 24

500

user2 wait/io/table/sql/handler 39

501

user2 wait/lock/table/sql/handler 24

502

user3 wait/io/table/sql/handler 0

503

user3 wait/lock/table/sql/handler 0

504

execute dump_waits_host;

505

host event_name count_star

506

localhost wait/io/table/sql/handler 62

507

localhost wait/lock/table/sql/handler 48

508

execute dump_waits_global;

509

event_name count_star

510

wait/io/table/sql/handler 62

511

wait/lock/table/sql/handler 48

512

execute dump_waits_history;

513

event_name count(event_name) object_type object_schema object_name

514

execute dump_waits_index_io;

515

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

516

TABLE test t1 NULL 13 8 5 8 2 3 0

517

TABLE test t1 index_b 1 1 0 1 0 0 0

518

TABLE test t1 index_cb 0 0 0 0 0 0 0

519

TABLE test t1 PRIMARY 4 2 2 2 0 2 0

520

TABLE test t2 NULL 0 0 0 0 0 0 0

521

TABLE test t2 index_b 0 0 0 0 0 0 0

522

TABLE test t2 index_cb 0 0 0 0 0 0 0

523

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

524

TABLE test t3 NULL 37 22 15 22 6 9 0

525

TABLE test t3 index_b 5 5 0 5 0 0 0

526

TABLE test t3 index_cb 0 0 0 0 0 0 0

527

TABLE test t3 PRIMARY 2 2 0 2 0 0 0

528

execute dump_waits_table_io;

529

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

530

TABLE test t1 18 11 7 11 2 5 0

531

TABLE test t2 0 0 0 0 0 0 0

532

TABLE test t3 44 29 15 29 6 9 0

533

execute dump_waits_table_lock;

534

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

535

TABLE test t1 20 8 12 4 0 0 0 4 0 0 6

536

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

537

TABLE test t3 28 8 20 4 0 0 0 4 0 0 10

538

execute dump_objects_summary;

539

object_type object_schema object_name count_star

540

TABLE test t1 38

541

TABLE test t2 0

542

TABLE test t3 72

543

insert into test.t1 set a=301, b=1, c=1;

544

insert into test.t2 set a=302, b=2, c=2;

545

insert into test.t2 set a=303, b=3, c=3;

546

insert into test.t3 set a=304, b=4, c=4;

547

insert into test.t3 set a=305, b=5, c=5;

548

insert into test.t3 set a=306, b=6, c=6;

549

select * from test.t1;

550

a b c d

551

101 1 1 3

552

201 1 1 2

553

301 1 1 0

554

select * from test.t2;

555

a b c d

556

102 2 2 2

557

103 3 3 2

558

202 2 2 1

559

203 3 3 1

560

302 2 2 0

561

303 3 3 0

562

select * from test.t3;

563

a b c d

564

104 4 4 2

565

105 5 5 2

566

106 6 6 2

567

204 4 4 1

568

205 5 5 1

569

206 6 6 1

570

304 4 4 0

571

305 5 5 0

572

306 6 6 0

573

update test.t1 set d=d+1;

574

update test.t2 set d=d+1;

575

update test.t3 set d=d+1;

576

update test.t1 set d=d+1 where a=301;

577

update test.t2 set d=d+1 where a=301;

578

update test.t3 set d=d+1 where a=301;

579

select * from test.t1 where b=5;

580

a b c d

581

select * from test.t2 where b=5;

582

a b c d

583

select * from test.t3 where b=5;

584

a b c d

585

105 5 5 3

586

205 5 5 2

587

305 5 5 1

588

"================== con3 marker =================="

589

"================== Step 7 =================="

590

call dump_thread();

591

username event_name count_star

592

user1 wait/io/table/sql/handler 23

593

user1 wait/lock/table/sql/handler 24

594

username event_name count_star

595

user2 wait/io/table/sql/handler 39

596

user2 wait/lock/table/sql/handler 24

597

username event_name count_star

598

user3 wait/io/table/sql/handler 52

599

user3 wait/lock/table/sql/handler 24

600

username status

601

user4 not found

602

execute dump_waits_account;

603

user host event_name count_star

604

user1 localhost wait/io/table/sql/handler 23

605

user1 localhost wait/lock/table/sql/handler 24

606

user2 localhost wait/io/table/sql/handler 39

607

user2 localhost wait/lock/table/sql/handler 24

608

user3 localhost wait/io/table/sql/handler 52

609

user3 localhost wait/lock/table/sql/handler 24

610

execute dump_waits_user;

611

user event_name count_star

612

user1 wait/io/table/sql/handler 23

613

user1 wait/lock/table/sql/handler 24

614

user2 wait/io/table/sql/handler 39

615

user2 wait/lock/table/sql/handler 24

616

user3 wait/io/table/sql/handler 52

617

user3 wait/lock/table/sql/handler 24

618

execute dump_waits_host;

619

host event_name count_star

620

localhost wait/io/table/sql/handler 114

621

localhost wait/lock/table/sql/handler 72

622

execute dump_waits_global;

623

event_name count_star

624

wait/io/table/sql/handler 114

625

wait/lock/table/sql/handler 72

626

execute dump_waits_history;

627

event_name count(event_name) object_type object_schema object_name

628

execute dump_waits_index_io;

629

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

630

TABLE test t1 NULL 25 16 9 16 3 6 0

631

TABLE test t1 index_b 2 2 0 2 0 0 0

632

TABLE test t1 index_cb 0 0 0 0 0 0 0

633

TABLE test t1 PRIMARY 6 3 3 3 0 3 0

634

TABLE test t2 NULL 0 0 0 0 0 0 0

635

TABLE test t2 index_b 0 0 0 0 0 0 0

636

TABLE test t2 index_cb 0 0 0 0 0 0 0

637

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

638

TABLE test t3 NULL 69 42 27 42 9 18 0

639

TABLE test t3 index_b 9 9 0 9 0 0 0

640

TABLE test t3 index_cb 0 0 0 0 0 0 0

641

TABLE test t3 PRIMARY 3 3 0 3 0 0 0

642

execute dump_waits_table_io;

643

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

644

TABLE test t1 33 21 12 21 3 9 0

645

TABLE test t2 0 0 0 0 0 0 0

646

TABLE test t3 81 54 27 54 9 18 0

647

execute dump_waits_table_lock;

648

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

649

TABLE test t1 30 12 18 6 0 0 0 6 0 0 9

650

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

651

TABLE test t3 42 12 30 6 0 0 0 6 0 0 15

652

execute dump_objects_summary;

653

object_type object_schema object_name count_star

654

TABLE test t1 63

655

TABLE test t2 0

656

TABLE test t3 123

657

select concat(current_user(), " is connected") as status;

658

status

659

user4@localhost is connected

660

"================== Step 8 =================="

661

call dump_thread();

662

username event_name count_star

663

user1 wait/io/table/sql/handler 23

664

user1 wait/lock/table/sql/handler 24

665

username event_name count_star

666

user2 wait/io/table/sql/handler 39

667

user2 wait/lock/table/sql/handler 24

668

username event_name count_star

669

user3 wait/io/table/sql/handler 52

670

user3 wait/lock/table/sql/handler 24

671

username event_name count_star

672

user4 wait/io/table/sql/handler 0

673

user4 wait/lock/table/sql/handler 0

674

execute dump_waits_account;

675

user host event_name count_star

676

user1 localhost wait/io/table/sql/handler 23

677

user1 localhost wait/lock/table/sql/handler 24

678

user2 localhost wait/io/table/sql/handler 39

679

user2 localhost wait/lock/table/sql/handler 24

680

user3 localhost wait/io/table/sql/handler 52

681

user3 localhost wait/lock/table/sql/handler 24

682

user4 localhost wait/io/table/sql/handler 0

683

user4 localhost wait/lock/table/sql/handler 0

684

execute dump_waits_user;

685

user event_name count_star

686

user1 wait/io/table/sql/handler 23

687

user1 wait/lock/table/sql/handler 24

688

user2 wait/io/table/sql/handler 39

689

user2 wait/lock/table/sql/handler 24

690

user3 wait/io/table/sql/handler 52

691

user3 wait/lock/table/sql/handler 24

692

user4 wait/io/table/sql/handler 0

693

user4 wait/lock/table/sql/handler 0

694

execute dump_waits_host;

695

host event_name count_star

696

localhost wait/io/table/sql/handler 114

697

localhost wait/lock/table/sql/handler 72

698

execute dump_waits_global;

699

event_name count_star

700

wait/io/table/sql/handler 114

701

wait/lock/table/sql/handler 72

702

execute dump_waits_history;

703

event_name count(event_name) object_type object_schema object_name

704

execute dump_waits_index_io;

705

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

706

TABLE test t1 NULL 25 16 9 16 3 6 0

707

TABLE test t1 index_b 2 2 0 2 0 0 0

708

TABLE test t1 index_cb 0 0 0 0 0 0 0

709

TABLE test t1 PRIMARY 6 3 3 3 0 3 0

710

TABLE test t2 NULL 0 0 0 0 0 0 0

711

TABLE test t2 index_b 0 0 0 0 0 0 0

712

TABLE test t2 index_cb 0 0 0 0 0 0 0

713

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

714

TABLE test t3 NULL 69 42 27 42 9 18 0

715

TABLE test t3 index_b 9 9 0 9 0 0 0

716

TABLE test t3 index_cb 0 0 0 0 0 0 0

717

TABLE test t3 PRIMARY 3 3 0 3 0 0 0

718

execute dump_waits_table_io;

719

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

720

TABLE test t1 33 21 12 21 3 9 0

721

TABLE test t2 0 0 0 0 0 0 0

722

TABLE test t3 81 54 27 54 9 18 0

723

execute dump_waits_table_lock;

724

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

725

TABLE test t1 30 12 18 6 0 0 0 6 0 0 9

726

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

727

TABLE test t3 42 12 30 6 0 0 0 6 0 0 15

728

execute dump_objects_summary;

729

object_type object_schema object_name count_star

730

TABLE test t1 63

731

TABLE test t2 0

732

TABLE test t3 123

733

insert into test.t1 set a=401, b=1, c=1;

734

insert into test.t2 set a=402, b=2, c=2;

735

insert into test.t2 set a=403, b=3, c=3;

736

insert into test.t3 set a=404, b=4, c=4;

737

insert into test.t3 set a=405, b=5, c=5;

738

insert into test.t3 set a=406, b=6, c=6;

739

select * from test.t1;

740

a b c d

741

101 1 1 4

742

201 1 1 3

743

301 1 1 2

744

401 1 1 0

745

select * from test.t2;

746

a b c d

747

102 2 2 3

748

103 3 3 3

749

202 2 2 2

750

203 3 3 2

751

302 2 2 1

752

303 3 3 1

753

402 2 2 0

754

403 3 3 0

755

select * from test.t3;

756

a b c d

757

104 4 4 3

758

105 5 5 3

759

106 6 6 3

760

204 4 4 2

761

205 5 5 2

762

206 6 6 2

763

304 4 4 1

764

305 5 5 1

765

306 6 6 1

766

404 4 4 0

767

405 5 5 0

768

406 6 6 0

769

update test.t1 set d=d+1;

770

update test.t2 set d=d+1;

771

update test.t3 set d=d+1;

772

update test.t1 set d=d+1 where a=401;

773

update test.t2 set d=d+1 where a=401;

774

update test.t3 set d=d+1 where a=401;

775

select * from test.t1 where b=5;

776

a b c d

777

select * from test.t2 where b=5;

778

a b c d

779

select * from test.t3 where b=5;

780

a b c d

781

105 5 5 4

782

205 5 5 3

783

305 5 5 2

784

405 5 5 1

785

"================== con4 marker =================="

786

"================== Step 9 =================="

787

call dump_thread();

788

username event_name count_star

789

user1 wait/io/table/sql/handler 23

790

user1 wait/lock/table/sql/handler 24

791

username event_name count_star

792

user2 wait/io/table/sql/handler 39

793

user2 wait/lock/table/sql/handler 24

794

username event_name count_star

795

user3 wait/io/table/sql/handler 52

796

user3 wait/lock/table/sql/handler 24

797

username event_name count_star

798

user4 wait/io/table/sql/handler 65

799

user4 wait/lock/table/sql/handler 24

800

execute dump_waits_account;

801

user host event_name count_star

802

user1 localhost wait/io/table/sql/handler 23

803

user1 localhost wait/lock/table/sql/handler 24

804

user2 localhost wait/io/table/sql/handler 39

805

user2 localhost wait/lock/table/sql/handler 24

806

user3 localhost wait/io/table/sql/handler 52

807

user3 localhost wait/lock/table/sql/handler 24

808

user4 localhost wait/io/table/sql/handler 65

809

user4 localhost wait/lock/table/sql/handler 24

810

execute dump_waits_user;

811

user event_name count_star

812

user1 wait/io/table/sql/handler 23

813

user1 wait/lock/table/sql/handler 24

814

user2 wait/io/table/sql/handler 39

815

user2 wait/lock/table/sql/handler 24

816

user3 wait/io/table/sql/handler 52

817

user3 wait/lock/table/sql/handler 24

818

user4 wait/io/table/sql/handler 65

819

user4 wait/lock/table/sql/handler 24

820

execute dump_waits_host;

821

host event_name count_star

822

localhost wait/io/table/sql/handler 179

823

localhost wait/lock/table/sql/handler 96

824

execute dump_waits_global;

825

event_name count_star

826

wait/io/table/sql/handler 179

827

wait/lock/table/sql/handler 96

828

execute dump_waits_history;

829

event_name count(event_name) object_type object_schema object_name

830

execute dump_waits_index_io;

831

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

832

TABLE test t1 NULL 40 26 14 26 4 10 0

833

TABLE test t1 index_b 3 3 0 3 0 0 0

834

TABLE test t1 index_cb 0 0 0 0 0 0 0

835

TABLE test t1 PRIMARY 8 4 4 4 0 4 0

836

TABLE test t2 NULL 0 0 0 0 0 0 0

837

TABLE test t2 index_b 0 0 0 0 0 0 0

838

TABLE test t2 index_cb 0 0 0 0 0 0 0

839

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

840

TABLE test t3 NULL 110 68 42 68 12 30 0

841

TABLE test t3 index_b 14 14 0 14 0 0 0

842

TABLE test t3 index_cb 0 0 0 0 0 0 0

843

TABLE test t3 PRIMARY 4 4 0 4 0 0 0

844

execute dump_waits_table_io;

845

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

846

TABLE test t1 51 33 18 33 4 14 0

847

TABLE test t2 0 0 0 0 0 0 0

848

TABLE test t3 128 86 42 86 12 30 0

849

execute dump_waits_table_lock;

850

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

851

TABLE test t1 40 16 24 8 0 0 0 8 0 0 12

852

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

853

TABLE test t3 56 16 40 8 0 0 0 8 0 0 20

854

execute dump_objects_summary;

855

object_type object_schema object_name count_star

856

TABLE test t1 91

857

TABLE test t2 0

858

TABLE test t3 184

859

lock tables test.t1 read, test.t2 read, test.t3 read;

860

unlock tables;

861

lock tables test.t1 write, test.t2 write, test.t3 write;

862

unlock tables;

863

"================== con1 marker =================="

864

"================== Step 10 =================="

865

call dump_thread();

866

username event_name count_star

867

user1 wait/io/table/sql/handler 23

868

user1 wait/lock/table/sql/handler 32

869

username event_name count_star

870

user2 wait/io/table/sql/handler 39

871

user2 wait/lock/table/sql/handler 24

872

username event_name count_star

873

user3 wait/io/table/sql/handler 52

874

user3 wait/lock/table/sql/handler 24

875

username event_name count_star

876

user4 wait/io/table/sql/handler 65

877

user4 wait/lock/table/sql/handler 24

878

execute dump_waits_account;

879

user host event_name count_star

880

user1 localhost wait/io/table/sql/handler 23

881

user1 localhost wait/lock/table/sql/handler 32

882

user2 localhost wait/io/table/sql/handler 39

883

user2 localhost wait/lock/table/sql/handler 24

884

user3 localhost wait/io/table/sql/handler 52

885

user3 localhost wait/lock/table/sql/handler 24

886

user4 localhost wait/io/table/sql/handler 65

887

user4 localhost wait/lock/table/sql/handler 24

888

execute dump_waits_user;

889

user event_name count_star

890

user1 wait/io/table/sql/handler 23

891

user1 wait/lock/table/sql/handler 32

892

user2 wait/io/table/sql/handler 39

893

user2 wait/lock/table/sql/handler 24

894

user3 wait/io/table/sql/handler 52

895

user3 wait/lock/table/sql/handler 24

896

user4 wait/io/table/sql/handler 65

897

user4 wait/lock/table/sql/handler 24

898

execute dump_waits_host;

899

host event_name count_star

900

localhost wait/io/table/sql/handler 179

901

localhost wait/lock/table/sql/handler 104

902

execute dump_waits_global;

903

event_name count_star

904

wait/io/table/sql/handler 179

905

wait/lock/table/sql/handler 104

906

execute dump_waits_history;

907

event_name count(event_name) object_type object_schema object_name

908

execute dump_waits_index_io;

909

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

910

TABLE test t1 NULL 40 26 14 26 4 10 0

911

TABLE test t1 index_b 3 3 0 3 0 0 0

912

TABLE test t1 index_cb 0 0 0 0 0 0 0

913

TABLE test t1 PRIMARY 8 4 4 4 0 4 0

914

TABLE test t2 NULL 0 0 0 0 0 0 0

915

TABLE test t2 index_b 0 0 0 0 0 0 0

916

TABLE test t2 index_cb 0 0 0 0 0 0 0

917

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

918

TABLE test t3 NULL 110 68 42 68 12 30 0

919

TABLE test t3 index_b 14 14 0 14 0 0 0

920

TABLE test t3 index_cb 0 0 0 0 0 0 0

921

TABLE test t3 PRIMARY 4 4 0 4 0 0 0

922

execute dump_waits_table_io;

923

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

924

TABLE test t1 51 33 18 33 4 14 0

925

TABLE test t2 0 0 0 0 0 0 0

926

TABLE test t3 128 86 42 86 12 30 0

927

execute dump_waits_table_lock;

928

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

929

TABLE test t1 44 18 26 8 0 0 1 9 0 0 13

930

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

931

TABLE test t3 60 18 42 8 0 0 1 9 0 0 21

932

execute dump_objects_summary;

933

object_type object_schema object_name count_star

934

TABLE test t1 95

935

TABLE test t2 0

936

TABLE test t3 188

937

flush tables;

938

"================== flush marker =================="

939

"================== Step 11 =================="

940

call dump_thread();

941

username event_name count_star

942

user1 wait/io/table/sql/handler 23

943

user1 wait/lock/table/sql/handler 32

944

username event_name count_star

945

user2 wait/io/table/sql/handler 39

946

user2 wait/lock/table/sql/handler 24

947

username event_name count_star

948

user3 wait/io/table/sql/handler 52

949

user3 wait/lock/table/sql/handler 24

950

username event_name count_star

951

user4 wait/io/table/sql/handler 65

952

user4 wait/lock/table/sql/handler 24

953

execute dump_waits_account;

954

user host event_name count_star

955

user1 localhost wait/io/table/sql/handler 23

956

user1 localhost wait/lock/table/sql/handler 32

957

user2 localhost wait/io/table/sql/handler 39

958

user2 localhost wait/lock/table/sql/handler 24

959

user3 localhost wait/io/table/sql/handler 52

960

user3 localhost wait/lock/table/sql/handler 24

961

user4 localhost wait/io/table/sql/handler 65

962

user4 localhost wait/lock/table/sql/handler 24

963

execute dump_waits_user;

964

user event_name count_star

965

user1 wait/io/table/sql/handler 23

966

user1 wait/lock/table/sql/handler 32

967

user2 wait/io/table/sql/handler 39

968

user2 wait/lock/table/sql/handler 24

969

user3 wait/io/table/sql/handler 52

970

user3 wait/lock/table/sql/handler 24

971

user4 wait/io/table/sql/handler 65

972

user4 wait/lock/table/sql/handler 24

973

execute dump_waits_host;

974

host event_name count_star

975

localhost wait/io/table/sql/handler 179

976

localhost wait/lock/table/sql/handler 104

977

execute dump_waits_global;

978

event_name count_star

979

wait/io/table/sql/handler 179

980

wait/lock/table/sql/handler 104

981

execute dump_waits_history;

982

event_name count(event_name) object_type object_schema object_name

983

execute dump_waits_index_io;

984

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

985

TABLE test t1 NULL 40 26 14 26 4 10 0

986

TABLE test t1 index_b 3 3 0 3 0 0 0

987

TABLE test t1 index_cb 0 0 0 0 0 0 0

988

TABLE test t1 PRIMARY 8 4 4 4 0 4 0

989

TABLE test t2 NULL 0 0 0 0 0 0 0

990

TABLE test t2 index_b 0 0 0 0 0 0 0

991

TABLE test t2 index_cb 0 0 0 0 0 0 0

992

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

993

TABLE test t3 NULL 110 68 42 68 12 30 0

994

TABLE test t3 index_b 14 14 0 14 0 0 0

995

TABLE test t3 index_cb 0 0 0 0 0 0 0

996

TABLE test t3 PRIMARY 4 4 0 4 0 0 0

997

execute dump_waits_table_io;

998

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

999

TABLE test t1 51 33 18 33 4 14 0

1000

TABLE test t2 0 0 0 0 0 0 0

1001

TABLE test t3 128 86 42 86 12 30 0

1002

execute dump_waits_table_lock;

1003

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

1004

TABLE test t1 44 18 26 8 0 0 1 9 0 0 13

1005

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

1006

TABLE test t3 60 18 42 8 0 0 1 9 0 0 21

1007

execute dump_objects_summary;

1008

object_type object_schema object_name count_star

1009

TABLE test t1 95

1010

TABLE test t2 0

1011

TABLE test t3 188

1012

set global read_only=1;

1013

set global read_only=0;

1014

"================== global read_only marker =================="

1015

"================== Step 12 =================="

1016

call dump_thread();

1017

username event_name count_star

1018

user1 wait/io/table/sql/handler 23

1019

user1 wait/lock/table/sql/handler 32

1020

username event_name count_star

1021

user2 wait/io/table/sql/handler 39

1022

user2 wait/lock/table/sql/handler 24

1023

username event_name count_star

1024

user3 wait/io/table/sql/handler 52

1025

user3 wait/lock/table/sql/handler 24

1026

username event_name count_star

1027

user4 wait/io/table/sql/handler 65

1028

user4 wait/lock/table/sql/handler 24

1029

execute dump_waits_account;

1030

user host event_name count_star

1031

user1 localhost wait/io/table/sql/handler 23

1032

user1 localhost wait/lock/table/sql/handler 32

1033

user2 localhost wait/io/table/sql/handler 39

1034

user2 localhost wait/lock/table/sql/handler 24

1035

user3 localhost wait/io/table/sql/handler 52

1036

user3 localhost wait/lock/table/sql/handler 24

1037

user4 localhost wait/io/table/sql/handler 65

1038

user4 localhost wait/lock/table/sql/handler 24

1039

execute dump_waits_user;

1040

user event_name count_star

1041

user1 wait/io/table/sql/handler 23

1042

user1 wait/lock/table/sql/handler 32

1043

user2 wait/io/table/sql/handler 39

1044

user2 wait/lock/table/sql/handler 24

1045

user3 wait/io/table/sql/handler 52

1046

user3 wait/lock/table/sql/handler 24

1047

user4 wait/io/table/sql/handler 65

1048

user4 wait/lock/table/sql/handler 24

1049

execute dump_waits_host;

1050

host event_name count_star

1051

localhost wait/io/table/sql/handler 179

1052

localhost wait/lock/table/sql/handler 104

1053

execute dump_waits_global;

1054

event_name count_star

1055

wait/io/table/sql/handler 179

1056

wait/lock/table/sql/handler 104

1057

execute dump_waits_history;

1058

event_name count(event_name) object_type object_schema object_name

1059

execute dump_waits_index_io;

1060

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1061

TABLE test t1 NULL 40 26 14 26 4 10 0

1062

TABLE test t1 index_b 3 3 0 3 0 0 0

1063

TABLE test t1 index_cb 0 0 0 0 0 0 0

1064

TABLE test t1 PRIMARY 8 4 4 4 0 4 0

1065

TABLE test t2 NULL 0 0 0 0 0 0 0

1066

TABLE test t2 index_b 0 0 0 0 0 0 0

1067

TABLE test t2 index_cb 0 0 0 0 0 0 0

1068

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1069

TABLE test t3 NULL 110 68 42 68 12 30 0

1070

TABLE test t3 index_b 14 14 0 14 0 0 0

1071

TABLE test t3 index_cb 0 0 0 0 0 0 0

1072

TABLE test t3 PRIMARY 4 4 0 4 0 0 0

1073

execute dump_waits_table_io;

1074

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1075

TABLE test t1 51 33 18 33 4 14 0

1076

TABLE test t2 0 0 0 0 0 0 0

1077

TABLE test t3 128 86 42 86 12 30 0

1078

execute dump_waits_table_lock;

1079

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

1080

TABLE test t1 44 18 26 8 0 0 1 9 0 0 13

1081

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

1082

TABLE test t3 60 18 42 8 0 0 1 9 0 0 21

1083

execute dump_objects_summary;

1084

object_type object_schema object_name count_star

1085

TABLE test t1 95

1086

TABLE test t2 0

1087

TABLE test t3 188

1088

"================== con1 disconnected =================="

1089

"================== Step 13 =================="

1090

call dump_thread();

1091

username status

1092

user1 not found

1093

username event_name count_star

1094

user2 wait/io/table/sql/handler 39

1095

user2 wait/lock/table/sql/handler 24

1096

username event_name count_star

1097

user3 wait/io/table/sql/handler 52

1098

user3 wait/lock/table/sql/handler 24

1099

username event_name count_star

1100

user4 wait/io/table/sql/handler 65

1101

user4 wait/lock/table/sql/handler 24

1102

execute dump_waits_account;

1103

user host event_name count_star

1104

user1 localhost wait/io/table/sql/handler 23

1105

user1 localhost wait/lock/table/sql/handler 32

1106

user2 localhost wait/io/table/sql/handler 39

1107

user2 localhost wait/lock/table/sql/handler 24

1108

user3 localhost wait/io/table/sql/handler 52

1109

user3 localhost wait/lock/table/sql/handler 24

1110

user4 localhost wait/io/table/sql/handler 65

1111

user4 localhost wait/lock/table/sql/handler 24

1112

execute dump_waits_user;

1113

user event_name count_star

1114

user1 wait/io/table/sql/handler 23

1115

user1 wait/lock/table/sql/handler 32

1116

user2 wait/io/table/sql/handler 39

1117

user2 wait/lock/table/sql/handler 24

1118

user3 wait/io/table/sql/handler 52

1119

user3 wait/lock/table/sql/handler 24

1120

user4 wait/io/table/sql/handler 65

1121

user4 wait/lock/table/sql/handler 24

1122

execute dump_waits_host;

1123

host event_name count_star

1124

localhost wait/io/table/sql/handler 179

1125

localhost wait/lock/table/sql/handler 104

1126

execute dump_waits_global;

1127

event_name count_star

1128

wait/io/table/sql/handler 179

1129

wait/lock/table/sql/handler 104

1130

execute dump_waits_history;

1131

event_name count(event_name) object_type object_schema object_name

1132

execute dump_waits_index_io;

1133

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1134

TABLE test t1 NULL 40 26 14 26 4 10 0

1135

TABLE test t1 index_b 3 3 0 3 0 0 0

1136

TABLE test t1 index_cb 0 0 0 0 0 0 0

1137

TABLE test t1 PRIMARY 8 4 4 4 0 4 0

1138

TABLE test t2 NULL 0 0 0 0 0 0 0

1139

TABLE test t2 index_b 0 0 0 0 0 0 0

1140

TABLE test t2 index_cb 0 0 0 0 0 0 0

1141

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1142

TABLE test t3 NULL 110 68 42 68 12 30 0

1143

TABLE test t3 index_b 14 14 0 14 0 0 0

1144

TABLE test t3 index_cb 0 0 0 0 0 0 0

1145

TABLE test t3 PRIMARY 4 4 0 4 0 0 0

1146

execute dump_waits_table_io;

1147

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1148

TABLE test t1 51 33 18 33 4 14 0

1149

TABLE test t2 0 0 0 0 0 0 0

1150

TABLE test t3 128 86 42 86 12 30 0

1151

execute dump_waits_table_lock;

1152

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

1153

TABLE test t1 44 18 26 8 0 0 1 9 0 0 13

1154

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

1155

TABLE test t3 60 18 42 8 0 0 1 9 0 0 21

1156

execute dump_objects_summary;

1157

object_type object_schema object_name count_star

1158

TABLE test t1 95

1159

TABLE test t2 0

1160

TABLE test t3 188

1161

"================== con2 disconnected =================="

1162

"================== Step 14 =================="

1163

call dump_thread();

1164

username status

1165

user1 not found

1166

username status

1167

user2 not found

1168

username event_name count_star

1169

user3 wait/io/table/sql/handler 52

1170

user3 wait/lock/table/sql/handler 24

1171

username event_name count_star

1172

user4 wait/io/table/sql/handler 65

1173

user4 wait/lock/table/sql/handler 24

1174

execute dump_waits_account;

1175

user host event_name count_star

1176

user1 localhost wait/io/table/sql/handler 23

1177

user1 localhost wait/lock/table/sql/handler 32

1178

user2 localhost wait/io/table/sql/handler 39

1179

user2 localhost wait/lock/table/sql/handler 24

1180

user3 localhost wait/io/table/sql/handler 52

1181

user3 localhost wait/lock/table/sql/handler 24

1182

user4 localhost wait/io/table/sql/handler 65

1183

user4 localhost wait/lock/table/sql/handler 24

1184

execute dump_waits_user;

1185

user event_name count_star

1186

user1 wait/io/table/sql/handler 23

1187

user1 wait/lock/table/sql/handler 32

1188

user2 wait/io/table/sql/handler 39

1189

user2 wait/lock/table/sql/handler 24

1190

user3 wait/io/table/sql/handler 52

1191

user3 wait/lock/table/sql/handler 24

1192

user4 wait/io/table/sql/handler 65

1193

user4 wait/lock/table/sql/handler 24

1194

execute dump_waits_host;

1195

host event_name count_star

1196

localhost wait/io/table/sql/handler 179

1197

localhost wait/lock/table/sql/handler 104

1198

execute dump_waits_global;

1199

event_name count_star

1200

wait/io/table/sql/handler 179

1201

wait/lock/table/sql/handler 104

1202

execute dump_waits_history;

1203

event_name count(event_name) object_type object_schema object_name

1204

execute dump_waits_index_io;

1205

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1206

TABLE test t1 NULL 40 26 14 26 4 10 0

1207

TABLE test t1 index_b 3 3 0 3 0 0 0

1208

TABLE test t1 index_cb 0 0 0 0 0 0 0

1209

TABLE test t1 PRIMARY 8 4 4 4 0 4 0

1210

TABLE test t2 NULL 0 0 0 0 0 0 0

1211

TABLE test t2 index_b 0 0 0 0 0 0 0

1212

TABLE test t2 index_cb 0 0 0 0 0 0 0

1213

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1214

TABLE test t3 NULL 110 68 42 68 12 30 0

1215

TABLE test t3 index_b 14 14 0 14 0 0 0

1216

TABLE test t3 index_cb 0 0 0 0 0 0 0

1217

TABLE test t3 PRIMARY 4 4 0 4 0 0 0

1218

execute dump_waits_table_io;

1219

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1220

TABLE test t1 51 33 18 33 4 14 0

1221

TABLE test t2 0 0 0 0 0 0 0

1222

TABLE test t3 128 86 42 86 12 30 0

1223

execute dump_waits_table_lock;

1224

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

1225

TABLE test t1 44 18 26 8 0 0 1 9 0 0 13

1226

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

1227

TABLE test t3 60 18 42 8 0 0 1 9 0 0 21

1228

execute dump_objects_summary;

1229

object_type object_schema object_name count_star

1230

TABLE test t1 95

1231

TABLE test t2 0

1232

TABLE test t3 188

1233

"================== con3 disconnected =================="

1234

"================== Step 15 =================="

1235

call dump_thread();

1236

username status

1237

user1 not found

1238

username status

1239

user2 not found

1240

username status

1241

user3 not found

1242

username event_name count_star

1243

user4 wait/io/table/sql/handler 65

1244

user4 wait/lock/table/sql/handler 24

1245

execute dump_waits_account;

1246

user host event_name count_star

1247

user1 localhost wait/io/table/sql/handler 23

1248

user1 localhost wait/lock/table/sql/handler 32

1249

user2 localhost wait/io/table/sql/handler 39

1250

user2 localhost wait/lock/table/sql/handler 24

1251

user3 localhost wait/io/table/sql/handler 52

1252

user3 localhost wait/lock/table/sql/handler 24

1253

user4 localhost wait/io/table/sql/handler 65

1254

user4 localhost wait/lock/table/sql/handler 24

1255

execute dump_waits_user;

1256

user event_name count_star

1257

user1 wait/io/table/sql/handler 23

1258

user1 wait/lock/table/sql/handler 32

1259

user2 wait/io/table/sql/handler 39

1260

user2 wait/lock/table/sql/handler 24

1261

user3 wait/io/table/sql/handler 52

1262

user3 wait/lock/table/sql/handler 24

1263

user4 wait/io/table/sql/handler 65

1264

user4 wait/lock/table/sql/handler 24

1265

execute dump_waits_host;

1266

host event_name count_star

1267

localhost wait/io/table/sql/handler 179

1268

localhost wait/lock/table/sql/handler 104

1269

execute dump_waits_global;

1270

event_name count_star

1271

wait/io/table/sql/handler 179

1272

wait/lock/table/sql/handler 104

1273

execute dump_waits_history;

1274

event_name count(event_name) object_type object_schema object_name

1275

execute dump_waits_index_io;

1276

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1277

TABLE test t1 NULL 40 26 14 26 4 10 0

1278

TABLE test t1 index_b 3 3 0 3 0 0 0

1279

TABLE test t1 index_cb 0 0 0 0 0 0 0

1280

TABLE test t1 PRIMARY 8 4 4 4 0 4 0

1281

TABLE test t2 NULL 0 0 0 0 0 0 0

1282

TABLE test t2 index_b 0 0 0 0 0 0 0

1283

TABLE test t2 index_cb 0 0 0 0 0 0 0

1284

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1285

TABLE test t3 NULL 110 68 42 68 12 30 0

1286

TABLE test t3 index_b 14 14 0 14 0 0 0

1287

TABLE test t3 index_cb 0 0 0 0 0 0 0

1288

TABLE test t3 PRIMARY 4 4 0 4 0 0 0

1289

execute dump_waits_table_io;

1290

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1291

TABLE test t1 51 33 18 33 4 14 0

1292

TABLE test t2 0 0 0 0 0 0 0

1293

TABLE test t3 128 86 42 86 12 30 0

1294

execute dump_waits_table_lock;

1295

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

1296

TABLE test t1 44 18 26 8 0 0 1 9 0 0 13

1297

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

1298

TABLE test t3 60 18 42 8 0 0 1 9 0 0 21

1299

execute dump_objects_summary;

1300

object_type object_schema object_name count_star

1301

TABLE test t1 95

1302

TABLE test t2 0

1303

TABLE test t3 188

1304

"================== con4 disconnected =================="

1305

"================== Step 16 =================="

1306

call dump_thread();

1307

username status

1308

user1 not found

1309

username status

1310

user2 not found

1311

username status

1312

user3 not found

1313

username status

1314

user4 not found

1315

execute dump_waits_account;

1316

user host event_name count_star

1317

user1 localhost wait/io/table/sql/handler 23

1318

user1 localhost wait/lock/table/sql/handler 32

1319

user2 localhost wait/io/table/sql/handler 39

1320

user2 localhost wait/lock/table/sql/handler 24

1321

user3 localhost wait/io/table/sql/handler 52

1322

user3 localhost wait/lock/table/sql/handler 24

1323

user4 localhost wait/io/table/sql/handler 65

1324

user4 localhost wait/lock/table/sql/handler 24

1325

execute dump_waits_user;

1326

user event_name count_star

1327

user1 wait/io/table/sql/handler 23

1328

user1 wait/lock/table/sql/handler 32

1329

user2 wait/io/table/sql/handler 39

1330

user2 wait/lock/table/sql/handler 24

1331

user3 wait/io/table/sql/handler 52

1332

user3 wait/lock/table/sql/handler 24

1333

user4 wait/io/table/sql/handler 65

1334

user4 wait/lock/table/sql/handler 24

1335

execute dump_waits_host;

1336

host event_name count_star

1337

localhost wait/io/table/sql/handler 179

1338

localhost wait/lock/table/sql/handler 104

1339

execute dump_waits_global;

1340

event_name count_star

1341

wait/io/table/sql/handler 179

1342

wait/lock/table/sql/handler 104

1343

execute dump_waits_history;

1344

event_name count(event_name) object_type object_schema object_name

1345

execute dump_waits_index_io;

1346

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1347

TABLE test t1 NULL 40 26 14 26 4 10 0

1348

TABLE test t1 index_b 3 3 0 3 0 0 0

1349

TABLE test t1 index_cb 0 0 0 0 0 0 0

1350

TABLE test t1 PRIMARY 8 4 4 4 0 4 0

1351

TABLE test t2 NULL 0 0 0 0 0 0 0

1352

TABLE test t2 index_b 0 0 0 0 0 0 0

1353

TABLE test t2 index_cb 0 0 0 0 0 0 0

1354

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1355

TABLE test t3 NULL 110 68 42 68 12 30 0

1356

TABLE test t3 index_b 14 14 0 14 0 0 0

1357

TABLE test t3 index_cb 0 0 0 0 0 0 0

1358

TABLE test t3 PRIMARY 4 4 0 4 0 0 0

1359

execute dump_waits_table_io;

1360

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1361

TABLE test t1 51 33 18 33 4 14 0

1362

TABLE test t2 0 0 0 0 0 0 0

1363

TABLE test t3 128 86 42 86 12 30 0

1364

execute dump_waits_table_lock;

1365

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

1366

TABLE test t1 44 18 26 8 0 0 1 9 0 0 13

1367

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

1368

TABLE test t3 60 18 42 8 0 0 1 9 0 0 21

1369

execute dump_objects_summary;

1370

object_type object_schema object_name count_star

1371

TABLE test t1 95

1372

TABLE test t2 0

1373

TABLE test t3 188

1374

truncate performance_schema.events_waits_summary_by_thread_by_event_name;

1375

"================== BY_THREAD truncated =================="

1376

"================== Step 17 =================="

1377

call dump_thread();

1378

username status

1379

user1 not found

1380

username status

1381

user2 not found

1382

username status

1383

user3 not found

1384

username status

1385

user4 not found

1386

execute dump_waits_account;

1387

user host event_name count_star

1388

user1 localhost wait/io/table/sql/handler 23

1389

user1 localhost wait/lock/table/sql/handler 32

1390

user2 localhost wait/io/table/sql/handler 39

1391

user2 localhost wait/lock/table/sql/handler 24

1392

user3 localhost wait/io/table/sql/handler 52

1393

user3 localhost wait/lock/table/sql/handler 24

1394

user4 localhost wait/io/table/sql/handler 65

1395

user4 localhost wait/lock/table/sql/handler 24

1396

execute dump_waits_user;

1397

user event_name count_star

1398

user1 wait/io/table/sql/handler 23

1399

user1 wait/lock/table/sql/handler 32

1400

user2 wait/io/table/sql/handler 39

1401

user2 wait/lock/table/sql/handler 24

1402

user3 wait/io/table/sql/handler 52

1403

user3 wait/lock/table/sql/handler 24

1404

user4 wait/io/table/sql/handler 65

1405

user4 wait/lock/table/sql/handler 24

1406

execute dump_waits_host;

1407

host event_name count_star

1408

localhost wait/io/table/sql/handler 179

1409

localhost wait/lock/table/sql/handler 104

1410

execute dump_waits_global;

1411

event_name count_star

1412

wait/io/table/sql/handler 179

1413

wait/lock/table/sql/handler 104

1414

execute dump_waits_history;

1415

event_name count(event_name) object_type object_schema object_name

1416

execute dump_waits_index_io;

1417

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1418

TABLE test t1 NULL 40 26 14 26 4 10 0

1419

TABLE test t1 index_b 3 3 0 3 0 0 0

1420

TABLE test t1 index_cb 0 0 0 0 0 0 0

1421

TABLE test t1 PRIMARY 8 4 4 4 0 4 0

1422

TABLE test t2 NULL 0 0 0 0 0 0 0

1423

TABLE test t2 index_b 0 0 0 0 0 0 0

1424

TABLE test t2 index_cb 0 0 0 0 0 0 0

1425

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1426

TABLE test t3 NULL 110 68 42 68 12 30 0

1427

TABLE test t3 index_b 14 14 0 14 0 0 0

1428

TABLE test t3 index_cb 0 0 0 0 0 0 0

1429

TABLE test t3 PRIMARY 4 4 0 4 0 0 0

1430

execute dump_waits_table_io;

1431

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1432

TABLE test t1 51 33 18 33 4 14 0

1433

TABLE test t2 0 0 0 0 0 0 0

1434

TABLE test t3 128 86 42 86 12 30 0

1435

execute dump_waits_table_lock;

1436

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

1437

TABLE test t1 44 18 26 8 0 0 1 9 0 0 13

1438

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

1439

TABLE test t3 60 18 42 8 0 0 1 9 0 0 21

1440

execute dump_objects_summary;

1441

object_type object_schema object_name count_star

1442

TABLE test t1 95

1443

TABLE test t2 0

1444

TABLE test t3 188

1445

truncate performance_schema.events_waits_summary_by_account_by_event_name;

1446

"================== BY_ACCOUNT truncated =================="

1447

"================== Step 18 =================="

1448

call dump_thread();

1449

username status

1450

user1 not found

1451

username status

1452

user2 not found

1453

username status

1454

user3 not found

1455

username status

1456

user4 not found

1457

execute dump_waits_account;

1458

user host event_name count_star

1459

user1 localhost wait/io/table/sql/handler 0

1460

user1 localhost wait/lock/table/sql/handler 0

1461

user2 localhost wait/io/table/sql/handler 0

1462

user2 localhost wait/lock/table/sql/handler 0

1463

user3 localhost wait/io/table/sql/handler 0

1464

user3 localhost wait/lock/table/sql/handler 0

1465

user4 localhost wait/io/table/sql/handler 0

1466

user4 localhost wait/lock/table/sql/handler 0

1467

execute dump_waits_user;

1468

user event_name count_star

1469

user1 wait/io/table/sql/handler 23

1470

user1 wait/lock/table/sql/handler 32

1471

user2 wait/io/table/sql/handler 39

1472

user2 wait/lock/table/sql/handler 24

1473

user3 wait/io/table/sql/handler 52

1474

user3 wait/lock/table/sql/handler 24

1475

user4 wait/io/table/sql/handler 65

1476

user4 wait/lock/table/sql/handler 24

1477

execute dump_waits_host;

1478

host event_name count_star

1479

localhost wait/io/table/sql/handler 179

1480

localhost wait/lock/table/sql/handler 104

1481

execute dump_waits_global;

1482

event_name count_star

1483

wait/io/table/sql/handler 179

1484

wait/lock/table/sql/handler 104

1485

execute dump_waits_history;

1486

event_name count(event_name) object_type object_schema object_name

1487

execute dump_waits_index_io;

1488

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1489

TABLE test t1 NULL 40 26 14 26 4 10 0

1490

TABLE test t1 index_b 3 3 0 3 0 0 0

1491

TABLE test t1 index_cb 0 0 0 0 0 0 0

1492

TABLE test t1 PRIMARY 8 4 4 4 0 4 0

1493

TABLE test t2 NULL 0 0 0 0 0 0 0

1494

TABLE test t2 index_b 0 0 0 0 0 0 0

1495

TABLE test t2 index_cb 0 0 0 0 0 0 0

1496

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1497

TABLE test t3 NULL 110 68 42 68 12 30 0

1498

TABLE test t3 index_b 14 14 0 14 0 0 0

1499

TABLE test t3 index_cb 0 0 0 0 0 0 0

1500

TABLE test t3 PRIMARY 4 4 0 4 0 0 0

1501

execute dump_waits_table_io;

1502

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1503

TABLE test t1 51 33 18 33 4 14 0

1504

TABLE test t2 0 0 0 0 0 0 0

1505

TABLE test t3 128 86 42 86 12 30 0

1506

execute dump_waits_table_lock;

1507

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

1508

TABLE test t1 44 18 26 8 0 0 1 9 0 0 13

1509

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

1510

TABLE test t3 60 18 42 8 0 0 1 9 0 0 21

1511

execute dump_objects_summary;

1512

object_type object_schema object_name count_star

1513

TABLE test t1 95

1514

TABLE test t2 0

1515

TABLE test t3 188

1516

truncate performance_schema.events_waits_summary_by_user_by_event_name;

1517

"================== BY_USER truncated =================="

1518

"================== Step 19 =================="

1519

call dump_thread();

1520

username status

1521

user1 not found

1522

username status

1523

user2 not found

1524

username status

1525

user3 not found

1526

username status

1527

user4 not found

1528

execute dump_waits_account;

1529

user host event_name count_star

1530

user1 localhost wait/io/table/sql/handler 0

1531

user1 localhost wait/lock/table/sql/handler 0

1532

user2 localhost wait/io/table/sql/handler 0

1533

user2 localhost wait/lock/table/sql/handler 0

1534

user3 localhost wait/io/table/sql/handler 0

1535

user3 localhost wait/lock/table/sql/handler 0

1536

user4 localhost wait/io/table/sql/handler 0

1537

user4 localhost wait/lock/table/sql/handler 0

1538

execute dump_waits_user;

1539

user event_name count_star

1540

user1 wait/io/table/sql/handler 0

1541

user1 wait/lock/table/sql/handler 0

1542

user2 wait/io/table/sql/handler 0

1543

user2 wait/lock/table/sql/handler 0

1544

user3 wait/io/table/sql/handler 0

1545

user3 wait/lock/table/sql/handler 0

1546

user4 wait/io/table/sql/handler 0

1547

user4 wait/lock/table/sql/handler 0

1548

execute dump_waits_host;

1549

host event_name count_star

1550

localhost wait/io/table/sql/handler 179

1551

localhost wait/lock/table/sql/handler 104

1552

execute dump_waits_global;

1553

event_name count_star

1554

wait/io/table/sql/handler 179

1555

wait/lock/table/sql/handler 104

1556

execute dump_waits_history;

1557

event_name count(event_name) object_type object_schema object_name

1558

execute dump_waits_index_io;

1559

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1560

TABLE test t1 NULL 40 26 14 26 4 10 0

1561

TABLE test t1 index_b 3 3 0 3 0 0 0

1562

TABLE test t1 index_cb 0 0 0 0 0 0 0

1563

TABLE test t1 PRIMARY 8 4 4 4 0 4 0

1564

TABLE test t2 NULL 0 0 0 0 0 0 0

1565

TABLE test t2 index_b 0 0 0 0 0 0 0

1566

TABLE test t2 index_cb 0 0 0 0 0 0 0

1567

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1568

TABLE test t3 NULL 110 68 42 68 12 30 0

1569

TABLE test t3 index_b 14 14 0 14 0 0 0

1570

TABLE test t3 index_cb 0 0 0 0 0 0 0

1571

TABLE test t3 PRIMARY 4 4 0 4 0 0 0

1572

execute dump_waits_table_io;

1573

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1574

TABLE test t1 51 33 18 33 4 14 0

1575

TABLE test t2 0 0 0 0 0 0 0

1576

TABLE test t3 128 86 42 86 12 30 0

1577

execute dump_waits_table_lock;

1578

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

1579

TABLE test t1 44 18 26 8 0 0 1 9 0 0 13

1580

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

1581

TABLE test t3 60 18 42 8 0 0 1 9 0 0 21

1582

execute dump_objects_summary;

1583

object_type object_schema object_name count_star

1584

TABLE test t1 95

1585

TABLE test t2 0

1586

TABLE test t3 188

1587

truncate performance_schema.events_waits_summary_by_host_by_event_name;

1588

"================== BY_HOST truncated =================="

1589

"================== Step 21 =================="

1590

call dump_thread();

1591

username status

1592

user1 not found

1593

username status

1594

user2 not found

1595

username status

1596

user3 not found

1597

username status

1598

user4 not found

1599

execute dump_waits_account;

1600

user host event_name count_star

1601

user1 localhost wait/io/table/sql/handler 0

1602

user1 localhost wait/lock/table/sql/handler 0

1603

user2 localhost wait/io/table/sql/handler 0

1604

user2 localhost wait/lock/table/sql/handler 0

1605

user3 localhost wait/io/table/sql/handler 0

1606

user3 localhost wait/lock/table/sql/handler 0

1607

user4 localhost wait/io/table/sql/handler 0

1608

user4 localhost wait/lock/table/sql/handler 0

1609

execute dump_waits_user;

1610

user event_name count_star

1611

user1 wait/io/table/sql/handler 0

1612

user1 wait/lock/table/sql/handler 0

1613

user2 wait/io/table/sql/handler 0

1614

user2 wait/lock/table/sql/handler 0

1615

user3 wait/io/table/sql/handler 0

1616

user3 wait/lock/table/sql/handler 0

1617

user4 wait/io/table/sql/handler 0

1618

user4 wait/lock/table/sql/handler 0

1619

execute dump_waits_host;

1620

host event_name count_star

1621

localhost wait/io/table/sql/handler 0

1622

localhost wait/lock/table/sql/handler 0

1623

execute dump_waits_global;

1624

event_name count_star

1625

wait/io/table/sql/handler 179

1626

wait/lock/table/sql/handler 104

1627

execute dump_waits_history;

1628

event_name count(event_name) object_type object_schema object_name

1629

execute dump_waits_index_io;

1630

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1631

TABLE test t1 NULL 40 26 14 26 4 10 0

1632

TABLE test t1 index_b 3 3 0 3 0 0 0

1633

TABLE test t1 index_cb 0 0 0 0 0 0 0

1634

TABLE test t1 PRIMARY 8 4 4 4 0 4 0

1635

TABLE test t2 NULL 0 0 0 0 0 0 0

1636

TABLE test t2 index_b 0 0 0 0 0 0 0

1637

TABLE test t2 index_cb 0 0 0 0 0 0 0

1638

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1639

TABLE test t3 NULL 110 68 42 68 12 30 0

1640

TABLE test t3 index_b 14 14 0 14 0 0 0

1641

TABLE test t3 index_cb 0 0 0 0 0 0 0

1642

TABLE test t3 PRIMARY 4 4 0 4 0 0 0

1643

execute dump_waits_table_io;

1644

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1645

TABLE test t1 51 33 18 33 4 14 0

1646

TABLE test t2 0 0 0 0 0 0 0

1647

TABLE test t3 128 86 42 86 12 30 0

1648

execute dump_waits_table_lock;

1649

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

1650

TABLE test t1 44 18 26 8 0 0 1 9 0 0 13

1651

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

1652

TABLE test t3 60 18 42 8 0 0 1 9 0 0 21

1653

execute dump_objects_summary;

1654

object_type object_schema object_name count_star

1655

TABLE test t1 95

1656

TABLE test t2 0

1657

TABLE test t3 188

1658

truncate performance_schema.events_waits_summary_global_by_event_name;

1659

"================== GLOBAL truncated =================="

1660

"================== Step 21 =================="

1661

call dump_thread();

1662

username status

1663

user1 not found

1664

username status

1665

user2 not found

1666

username status

1667

user3 not found

1668

username status

1669

user4 not found

1670

execute dump_waits_account;

1671

user host event_name count_star

1672

user1 localhost wait/io/table/sql/handler 0

1673

user1 localhost wait/lock/table/sql/handler 0

1674

user2 localhost wait/io/table/sql/handler 0

1675

user2 localhost wait/lock/table/sql/handler 0

1676

user3 localhost wait/io/table/sql/handler 0

1677

user3 localhost wait/lock/table/sql/handler 0

1678

user4 localhost wait/io/table/sql/handler 0

1679

user4 localhost wait/lock/table/sql/handler 0

1680

execute dump_waits_user;

1681

user event_name count_star

1682

user1 wait/io/table/sql/handler 0

1683

user1 wait/lock/table/sql/handler 0

1684

user2 wait/io/table/sql/handler 0

1685

user2 wait/lock/table/sql/handler 0

1686

user3 wait/io/table/sql/handler 0

1687

user3 wait/lock/table/sql/handler 0

1688

user4 wait/io/table/sql/handler 0

1689

user4 wait/lock/table/sql/handler 0

1690

execute dump_waits_host;

1691

host event_name count_star

1692

localhost wait/io/table/sql/handler 0

1693

localhost wait/lock/table/sql/handler 0

1694

execute dump_waits_global;

1695

event_name count_star

1696

wait/io/table/sql/handler 0

1697

wait/lock/table/sql/handler 0

1698

execute dump_waits_history;

1699

event_name count(event_name) object_type object_schema object_name

1700

execute dump_waits_index_io;

1701

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1702

TABLE test t1 NULL 0 0 0 0 0 0 0

1703

TABLE test t1 index_b 0 0 0 0 0 0 0

1704

TABLE test t1 index_cb 0 0 0 0 0 0 0

1705

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

1706

TABLE test t2 NULL 0 0 0 0 0 0 0

1707

TABLE test t2 index_b 0 0 0 0 0 0 0

1708

TABLE test t2 index_cb 0 0 0 0 0 0 0

1709

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1710

TABLE test t3 NULL 0 0 0 0 0 0 0

1711

TABLE test t3 index_b 0 0 0 0 0 0 0

1712

TABLE test t3 index_cb 0 0 0 0 0 0 0

1713

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

1714

execute dump_waits_table_io;

1715

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1716

TABLE test t1 0 0 0 0 0 0 0

1717

TABLE test t2 0 0 0 0 0 0 0

1718

TABLE test t3 0 0 0 0 0 0 0

1719

execute dump_waits_table_lock;

1720

object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_delayed count_write_low_priority count_write_external

1721

TABLE test t1 0 0 0 0 0 0 0 0 0 0 0

1722

TABLE test t2 0 0 0 0 0 0 0 0 0 0 0

1723

TABLE test t3 0 0 0 0 0 0 0 0 0 0 0

1724

execute dump_objects_summary;

1725

object_type object_schema object_name count_star

1726

TABLE test t1 0

1727

TABLE test t2 0

1728

TABLE test t3 0

1729

show status like "performance_schema%";

1730

Variable_name Value

1731

Performance_schema_accounts_lost 0

1732

Performance_schema_cond_classes_lost 0

1733

Performance_schema_cond_instances_lost 0

1734

Performance_schema_digest_lost 0

1735

Performance_schema_file_classes_lost 0

1736

Performance_schema_file_handles_lost 0

1737

Performance_schema_file_instances_lost 0

1738

Performance_schema_hosts_lost 0

1739

Performance_schema_locker_lost 0

1740

Performance_schema_mutex_classes_lost 0

1741

Performance_schema_mutex_instances_lost 0

1742

Performance_schema_rwlock_classes_lost 0

1743

Performance_schema_rwlock_instances_lost 0

1744

Performance_schema_session_connect_attrs_lost 0

1745

Performance_schema_socket_classes_lost 0

1746

Performance_schema_socket_instances_lost 0

1747

Performance_schema_stage_classes_lost 0

1748

Performance_schema_statement_classes_lost 0

1749

Performance_schema_table_handles_lost 0

1750

Performance_schema_table_instances_lost 0

1751

Performance_schema_thread_classes_lost 0

1752

Performance_schema_thread_instances_lost 0

1753

Performance_schema_users_lost 0