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

1

update performance_schema.setup_instruments

2

set enabled='NO' where name='wait/io/table/sql/handler';

3

update performance_schema.setup_consumers

4

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

5

delete from performance_schema.setup_actors

6

where user in ('user2', 'user4');

7

select * from performance_schema.setup_actors

8

order by USER, HOST, ROLE;

9

HOST USER ROLE

10

localhost user1 %

11

localhost user3 %

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 t2 YES NO

17

TABLE test t3 YES NO

18

select * from performance_schema.setup_consumers;

19

NAME ENABLED

20

events_stages_current NO

21

events_stages_history NO

22

events_stages_history_long NO

23

events_statements_current NO

24

events_statements_history NO

25

events_statements_history_long NO

26

events_waits_current NO

27

events_waits_history NO

28

events_waits_history_long NO

29

global_instrumentation YES

30

thread_instrumentation YES

31

statements_digest YES

32

flush tables;

33

truncate performance_schema.objects_summary_global_by_type;

34

truncate performance_schema.table_io_waits_summary_by_index_usage;

35

truncate performance_schema.table_io_waits_summary_by_table;

36

truncate performance_schema.table_lock_waits_summary_by_table;

37

truncate performance_schema.events_waits_summary_by_thread_by_event_name;

38

truncate performance_schema.events_waits_summary_by_account_by_event_name;

39

truncate performance_schema.events_waits_summary_by_user_by_event_name;

40

truncate performance_schema.events_waits_summary_by_host_by_event_name;

41

truncate performance_schema.events_waits_summary_global_by_event_name;

42

truncate performance_schema.events_waits_history_long;

43

show variables like "performance_schema%";

44

Variable_name Value

45

performance_schema ON

46

performance_schema_accounts_size 100

47

performance_schema_digests_size 200

48

performance_schema_events_stages_history_long_size 1000

49

performance_schema_events_stages_history_size 10

50

performance_schema_events_statements_history_long_size 1000

51

performance_schema_events_statements_history_size 10

52

performance_schema_events_waits_history_long_size 10000

53

performance_schema_events_waits_history_size 10

54

performance_schema_hosts_size 100

55

performance_schema_max_cond_classes 80

56

performance_schema_max_cond_instances 1000

57

performance_schema_max_file_classes 50

58

performance_schema_max_file_handles 32768

59

performance_schema_max_file_instances 10000

60

performance_schema_max_mutex_classes 200

61

performance_schema_max_mutex_instances 5000

62

performance_schema_max_rwlock_classes 40

63

performance_schema_max_rwlock_instances 5000

64

performance_schema_max_socket_classes 10

65

performance_schema_max_socket_instances 1000

66

performance_schema_max_stage_classes 150

67

performance_schema_max_statement_classes 168

68

performance_schema_max_table_handles 1000

69

performance_schema_max_table_instances 500

70

performance_schema_max_thread_classes 50

71

performance_schema_max_thread_instances 200

72

performance_schema_session_connect_attrs_size 2048

73

performance_schema_setup_actors_size 100

74

performance_schema_setup_objects_size 100

75

performance_schema_users_size 100

76

show status like "performance_schema%";

77

Variable_name Value

78

Performance_schema_accounts_lost 0

79

Performance_schema_cond_classes_lost 0

80

Performance_schema_cond_instances_lost 0

81

Performance_schema_digest_lost 0

82

Performance_schema_file_classes_lost 0

83

Performance_schema_file_handles_lost 0

84

Performance_schema_file_instances_lost 0

85

Performance_schema_hosts_lost 0

86

Performance_schema_locker_lost 0

87

Performance_schema_mutex_classes_lost 0

88

Performance_schema_mutex_instances_lost 0

89

Performance_schema_rwlock_classes_lost 0

90

Performance_schema_rwlock_instances_lost 0

91

Performance_schema_session_connect_attrs_lost 0

92

Performance_schema_socket_classes_lost 0

93

Performance_schema_socket_instances_lost 0

94

Performance_schema_stage_classes_lost 0

95

Performance_schema_statement_classes_lost 0

96

Performance_schema_table_handles_lost 0

97

Performance_schema_table_instances_lost 0

98

Performance_schema_thread_classes_lost 0

99

Performance_schema_thread_instances_lost 0

100

Performance_schema_users_lost 0

101

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

102

call dump_thread();

103

username status

104

user1 not found

105

username status

106

user2 not found

107

username status

108

user3 not found

109

username status

110

user4 not found

111

execute dump_waits_account;

112

user host event_name count_star

113

execute dump_waits_user;

114

user event_name count_star

115

execute dump_waits_host;

116

host event_name count_star

117

localhost wait/io/table/sql/handler 0

118

localhost wait/lock/table/sql/handler 0

119

execute dump_waits_global;

120

event_name count_star

121

wait/io/table/sql/handler 0

122

wait/lock/table/sql/handler 0

123

execute dump_waits_history;

124

event_name count(event_name) object_type object_schema object_name

125

execute dump_waits_index_io;

126

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

127

TABLE test t1 NULL 0 0 0 0 0 0 0

128

TABLE test t1 index_b 0 0 0 0 0 0 0

129

TABLE test t1 index_cb 0 0 0 0 0 0 0

130

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

131

TABLE test t2 NULL 0 0 0 0 0 0 0

132

TABLE test t2 index_b 0 0 0 0 0 0 0

133

TABLE test t2 index_cb 0 0 0 0 0 0 0

134

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

135

TABLE test t3 NULL 0 0 0 0 0 0 0

136

TABLE test t3 index_b 0 0 0 0 0 0 0

137

TABLE test t3 index_cb 0 0 0 0 0 0 0

138

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

139

execute dump_waits_table_io;

140

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

141

TABLE test t1 0 0 0 0 0 0 0

142

TABLE test t2 0 0 0 0 0 0 0

143

TABLE test t3 0 0 0 0 0 0 0

144

execute dump_waits_table_lock;

145

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

146

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

147

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

148

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

149

execute dump_objects_summary;

150

object_type object_schema object_name count_star

151

TABLE test t1 0

152

TABLE test t2 0

153

TABLE test t3 0

154

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

155

status

156

user1@localhost is connected

157

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

158

call dump_thread();

159

username event_name count_star

160

user1 wait/io/table/sql/handler 0

161

user1 wait/lock/table/sql/handler 0

162

username status

163

user2 not found

164

username status

165

user3 not found

166

username status

167

user4 not found

168

execute dump_waits_account;

169

user host event_name count_star

170

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

171

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

172

execute dump_waits_user;

173

user event_name count_star

174

user1 wait/io/table/sql/handler 0

175

user1 wait/lock/table/sql/handler 0

176

execute dump_waits_host;

177

host event_name count_star

178

localhost wait/io/table/sql/handler 0

179

localhost wait/lock/table/sql/handler 0

180

execute dump_waits_global;

181

event_name count_star

182

wait/io/table/sql/handler 0

183

wait/lock/table/sql/handler 0

184

execute dump_waits_history;

185

event_name count(event_name) object_type object_schema object_name

186

execute dump_waits_index_io;

187

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

188

TABLE test t1 NULL 0 0 0 0 0 0 0

189

TABLE test t1 index_b 0 0 0 0 0 0 0

190

TABLE test t1 index_cb 0 0 0 0 0 0 0

191

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

192

TABLE test t2 NULL 0 0 0 0 0 0 0

193

TABLE test t2 index_b 0 0 0 0 0 0 0

194

TABLE test t2 index_cb 0 0 0 0 0 0 0

195

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

196

TABLE test t3 NULL 0 0 0 0 0 0 0

197

TABLE test t3 index_b 0 0 0 0 0 0 0

198

TABLE test t3 index_cb 0 0 0 0 0 0 0

199

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

200

execute dump_waits_table_io;

201

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

202

TABLE test t1 0 0 0 0 0 0 0

203

TABLE test t2 0 0 0 0 0 0 0

204

TABLE test t3 0 0 0 0 0 0 0

205

execute dump_waits_table_lock;

206

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

207

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

208

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

209

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

210

execute dump_objects_summary;

211

object_type object_schema object_name count_star

212

TABLE test t1 0

213

TABLE test t2 0

214

TABLE test t3 0

215

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

216

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

217

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

218

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

219

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

220

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

221

select * from test.t1;

222

a b c d

223

101 1 1 0

224

select * from test.t2;

225

a b c d

226

102 2 2 0

227

103 3 3 0

228

select * from test.t3;

229

a b c d

230

104 4 4 0

231

105 5 5 0

232

106 6 6 0

233

update test.t1 set d=d+1;

234

update test.t2 set d=d+1;

235

update test.t3 set d=d+1;

236

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

237

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

238

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

239

select * from test.t1 where b=5;

240

a b c d

241

select * from test.t2 where b=5;

242

a b c d

243

select * from test.t3 where b=5;

244

a b c d

245

105 5 5 1

246

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

247

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

248

call dump_thread();

249

username event_name count_star

250

user1 wait/io/table/sql/handler 0

251

user1 wait/lock/table/sql/handler 36

252

username status

253

user2 not found

254

username status

255

user3 not found

256

username status

257

user4 not found

258

execute dump_waits_account;

259

user host event_name count_star

260

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

261

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

262

execute dump_waits_user;

263

user event_name count_star

264

user1 wait/io/table/sql/handler 0

265

user1 wait/lock/table/sql/handler 36

266

execute dump_waits_host;

267

host event_name count_star

268

localhost wait/io/table/sql/handler 0

269

localhost wait/lock/table/sql/handler 36

270

execute dump_waits_global;

271

event_name count_star

272

wait/io/table/sql/handler 0

273

wait/lock/table/sql/handler 36

274

execute dump_waits_history;

275

event_name count(event_name) object_type object_schema object_name

276

execute dump_waits_index_io;

277

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

278

TABLE test t1 NULL 0 0 0 0 0 0 0

279

TABLE test t1 index_b 0 0 0 0 0 0 0

280

TABLE test t1 index_cb 0 0 0 0 0 0 0

281

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

282

TABLE test t2 NULL 0 0 0 0 0 0 0

283

TABLE test t2 index_b 0 0 0 0 0 0 0

284

TABLE test t2 index_cb 0 0 0 0 0 0 0

285

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

286

TABLE test t3 NULL 0 0 0 0 0 0 0

287

TABLE test t3 index_b 0 0 0 0 0 0 0

288

TABLE test t3 index_cb 0 0 0 0 0 0 0

289

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

290

execute dump_waits_table_io;

291

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

292

TABLE test t1 0 0 0 0 0 0 0

293

TABLE test t2 0 0 0 0 0 0 0

294

TABLE test t3 0 0 0 0 0 0 0

295

execute dump_waits_table_lock;

296

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

297

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

298

TABLE test t2 12 4 8 2 0 0 0 2 0 0 4

299

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

300

execute dump_objects_summary;

301

object_type object_schema object_name count_star

302

TABLE test t1 10

303

TABLE test t2 12

304

TABLE test t3 14

305

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

306

status

307

user2@localhost is connected

308

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

309

call dump_thread();

310

username event_name count_star

311

user1 wait/io/table/sql/handler 0

312

user1 wait/lock/table/sql/handler 36

313

username event_name count_star

314

user2 wait/io/table/sql/handler 0

315

user2 wait/lock/table/sql/handler 0

316

username status

317

user3 not found

318

username status

319

user4 not found

320

execute dump_waits_account;

321

user host event_name count_star

322

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

323

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

324

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

325

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

326

execute dump_waits_user;

327

user event_name count_star

328

user1 wait/io/table/sql/handler 0

329

user1 wait/lock/table/sql/handler 36

330

user2 wait/io/table/sql/handler 0

331

user2 wait/lock/table/sql/handler 0

332

execute dump_waits_host;

333

host event_name count_star

334

localhost wait/io/table/sql/handler 0

335

localhost wait/lock/table/sql/handler 36

336

execute dump_waits_global;

337

event_name count_star

338

wait/io/table/sql/handler 0

339

wait/lock/table/sql/handler 36

340

execute dump_waits_history;

341

event_name count(event_name) object_type object_schema object_name

342

execute dump_waits_index_io;

343

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

344

TABLE test t1 NULL 0 0 0 0 0 0 0

345

TABLE test t1 index_b 0 0 0 0 0 0 0

346

TABLE test t1 index_cb 0 0 0 0 0 0 0

347

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

348

TABLE test t2 NULL 0 0 0 0 0 0 0

349

TABLE test t2 index_b 0 0 0 0 0 0 0

350

TABLE test t2 index_cb 0 0 0 0 0 0 0

351

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

352

TABLE test t3 NULL 0 0 0 0 0 0 0

353

TABLE test t3 index_b 0 0 0 0 0 0 0

354

TABLE test t3 index_cb 0 0 0 0 0 0 0

355

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

356

execute dump_waits_table_io;

357

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

358

TABLE test t1 0 0 0 0 0 0 0

359

TABLE test t2 0 0 0 0 0 0 0

360

TABLE test t3 0 0 0 0 0 0 0

361

execute dump_waits_table_lock;

362

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

363

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

364

TABLE test t2 12 4 8 2 0 0 0 2 0 0 4

365

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

366

execute dump_objects_summary;

367

object_type object_schema object_name count_star

368

TABLE test t1 10

369

TABLE test t2 12

370

TABLE test t3 14

371

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

372

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

373

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

374

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

375

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

376

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

377

select * from test.t1;

378

a b c d

379

101 1 1 2

380

201 1 1 0

381

select * from test.t2;

382

a b c d

383

102 2 2 1

384

103 3 3 1

385

202 2 2 0

386

203 3 3 0

387

select * from test.t3;

388

a b c d

389

104 4 4 1

390

105 5 5 1

391

106 6 6 1

392

204 4 4 0

393

205 5 5 0

394

206 6 6 0

395

update test.t1 set d=d+1;

396

update test.t2 set d=d+1;

397

update test.t3 set d=d+1;

398

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

399

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

400

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

401

select * from test.t1 where b=5;

402

a b c d

403

select * from test.t2 where b=5;

404

a b c d

405

select * from test.t3 where b=5;

406

a b c d

407

105 5 5 2

408

205 5 5 1

409

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

410

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

411

call dump_thread();

412

username event_name count_star

413

user1 wait/io/table/sql/handler 0

414

user1 wait/lock/table/sql/handler 36

415

username event_name count_star

416

user2 wait/io/table/sql/handler 0

417

user2 wait/lock/table/sql/handler 0

418

username status

419

user3 not found

420

username status

421

user4 not found

422

execute dump_waits_account;

423

user host event_name count_star

424

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

425

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

426

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

427

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

428

execute dump_waits_user;

429

user event_name count_star

430

user1 wait/io/table/sql/handler 0

431

user1 wait/lock/table/sql/handler 36

432

user2 wait/io/table/sql/handler 0

433

user2 wait/lock/table/sql/handler 0

434

execute dump_waits_host;

435

host event_name count_star

436

localhost wait/io/table/sql/handler 0

437

localhost wait/lock/table/sql/handler 36

438

execute dump_waits_global;

439

event_name count_star

440

wait/io/table/sql/handler 0

441

wait/lock/table/sql/handler 36

442

execute dump_waits_history;

443

event_name count(event_name) object_type object_schema object_name

444

execute dump_waits_index_io;

445

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

446

TABLE test t1 NULL 0 0 0 0 0 0 0

447

TABLE test t1 index_b 0 0 0 0 0 0 0

448

TABLE test t1 index_cb 0 0 0 0 0 0 0

449

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

450

TABLE test t2 NULL 0 0 0 0 0 0 0

451

TABLE test t2 index_b 0 0 0 0 0 0 0

452

TABLE test t2 index_cb 0 0 0 0 0 0 0

453

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

454

TABLE test t3 NULL 0 0 0 0 0 0 0

455

TABLE test t3 index_b 0 0 0 0 0 0 0

456

TABLE test t3 index_cb 0 0 0 0 0 0 0

457

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

458

execute dump_waits_table_io;

459

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

460

TABLE test t1 0 0 0 0 0 0 0

461

TABLE test t2 0 0 0 0 0 0 0

462

TABLE test t3 0 0 0 0 0 0 0

463

execute dump_waits_table_lock;

464

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

465

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

466

TABLE test t2 12 4 8 2 0 0 0 2 0 0 4

467

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

468

execute dump_objects_summary;

469

object_type object_schema object_name count_star

470

TABLE test t1 10

471

TABLE test t2 12

472

TABLE test t3 14

473

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

474

status

475

user3@localhost is connected

476

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

477

call dump_thread();

478

username event_name count_star

479

user1 wait/io/table/sql/handler 0

480

user1 wait/lock/table/sql/handler 36

481

username event_name count_star

482

user2 wait/io/table/sql/handler 0

483

user2 wait/lock/table/sql/handler 0

484

username event_name count_star

485

user3 wait/io/table/sql/handler 0

486

user3 wait/lock/table/sql/handler 0

487

username status

488

user4 not found

489

execute dump_waits_account;

490

user host event_name count_star

491

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

492

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

493

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

494

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

495

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

496

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

497

execute dump_waits_user;

498

user event_name count_star

499

user1 wait/io/table/sql/handler 0

500

user1 wait/lock/table/sql/handler 36

501

user2 wait/io/table/sql/handler 0

502

user2 wait/lock/table/sql/handler 0

503

user3 wait/io/table/sql/handler 0

504

user3 wait/lock/table/sql/handler 0

505

execute dump_waits_host;

506

host event_name count_star

507

localhost wait/io/table/sql/handler 0

508

localhost wait/lock/table/sql/handler 36

509

execute dump_waits_global;

510

event_name count_star

511

wait/io/table/sql/handler 0

512

wait/lock/table/sql/handler 36

513

execute dump_waits_history;

514

event_name count(event_name) object_type object_schema object_name

515

execute dump_waits_index_io;

516

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

517

TABLE test t1 NULL 0 0 0 0 0 0 0

518

TABLE test t1 index_b 0 0 0 0 0 0 0

519

TABLE test t1 index_cb 0 0 0 0 0 0 0

520

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

521

TABLE test t2 NULL 0 0 0 0 0 0 0

522

TABLE test t2 index_b 0 0 0 0 0 0 0

523

TABLE test t2 index_cb 0 0 0 0 0 0 0

524

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

525

TABLE test t3 NULL 0 0 0 0 0 0 0

526

TABLE test t3 index_b 0 0 0 0 0 0 0

527

TABLE test t3 index_cb 0 0 0 0 0 0 0

528

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

529

execute dump_waits_table_io;

530

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

531

TABLE test t1 0 0 0 0 0 0 0

532

TABLE test t2 0 0 0 0 0 0 0

533

TABLE test t3 0 0 0 0 0 0 0

534

execute dump_waits_table_lock;

535

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

536

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

537

TABLE test t2 12 4 8 2 0 0 0 2 0 0 4

538

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

539

execute dump_objects_summary;

540

object_type object_schema object_name count_star

541

TABLE test t1 10

542

TABLE test t2 12

543

TABLE test t3 14

544

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

545

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

546

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

547

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

548

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

549

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

550

select * from test.t1;

551

a b c d

552

101 1 1 3

553

201 1 1 2

554

301 1 1 0

555

select * from test.t2;

556

a b c d

557

102 2 2 2

558

103 3 3 2

559

202 2 2 1

560

203 3 3 1

561

302 2 2 0

562

303 3 3 0

563

select * from test.t3;

564

a b c d

565

104 4 4 2

566

105 5 5 2

567

106 6 6 2

568

204 4 4 1

569

205 5 5 1

570

206 6 6 1

571

304 4 4 0

572

305 5 5 0

573

306 6 6 0

574

update test.t1 set d=d+1;

575

update test.t2 set d=d+1;

576

update test.t3 set d=d+1;

577

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

578

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

579

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

580

select * from test.t1 where b=5;

581

a b c d

582

select * from test.t2 where b=5;

583

a b c d

584

select * from test.t3 where b=5;

585

a b c d

586

105 5 5 3

587

205 5 5 2

588

305 5 5 1

589

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

590

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

591

call dump_thread();

592

username event_name count_star

593

user1 wait/io/table/sql/handler 0

594

user1 wait/lock/table/sql/handler 36

595

username event_name count_star

596

user2 wait/io/table/sql/handler 0

597

user2 wait/lock/table/sql/handler 0

598

username event_name count_star

599

user3 wait/io/table/sql/handler 0

600

user3 wait/lock/table/sql/handler 36

601

username status

602

user4 not found

603

execute dump_waits_account;

604

user host event_name count_star

605

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

606

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

607

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

608

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

609

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

610

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

611

execute dump_waits_user;

612

user event_name count_star

613

user1 wait/io/table/sql/handler 0

614

user1 wait/lock/table/sql/handler 36

615

user2 wait/io/table/sql/handler 0

616

user2 wait/lock/table/sql/handler 0

617

user3 wait/io/table/sql/handler 0

618

user3 wait/lock/table/sql/handler 36

619

execute dump_waits_host;

620

host event_name count_star

621

localhost wait/io/table/sql/handler 0

622

localhost wait/lock/table/sql/handler 72

623

execute dump_waits_global;

624

event_name count_star

625

wait/io/table/sql/handler 0

626

wait/lock/table/sql/handler 72

627

execute dump_waits_history;

628

event_name count(event_name) object_type object_schema object_name

629

execute dump_waits_index_io;

630

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

631

TABLE test t1 NULL 0 0 0 0 0 0 0

632

TABLE test t1 index_b 0 0 0 0 0 0 0

633

TABLE test t1 index_cb 0 0 0 0 0 0 0

634

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

635

TABLE test t2 NULL 0 0 0 0 0 0 0

636

TABLE test t2 index_b 0 0 0 0 0 0 0

637

TABLE test t2 index_cb 0 0 0 0 0 0 0

638

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

639

TABLE test t3 NULL 0 0 0 0 0 0 0

640

TABLE test t3 index_b 0 0 0 0 0 0 0

641

TABLE test t3 index_cb 0 0 0 0 0 0 0

642

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

643

execute dump_waits_table_io;

644

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

645

TABLE test t1 0 0 0 0 0 0 0

646

TABLE test t2 0 0 0 0 0 0 0

647

TABLE test t3 0 0 0 0 0 0 0

648

execute dump_waits_table_lock;

649

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

650

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

651

TABLE test t2 24 8 16 4 0 0 0 4 0 0 8

652

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

653

execute dump_objects_summary;

654

object_type object_schema object_name count_star

655

TABLE test t1 20

656

TABLE test t2 24

657

TABLE test t3 28

658

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

659

status

660

user4@localhost is connected

661

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

662

call dump_thread();

663

username event_name count_star

664

user1 wait/io/table/sql/handler 0

665

user1 wait/lock/table/sql/handler 36

666

username event_name count_star

667

user2 wait/io/table/sql/handler 0

668

user2 wait/lock/table/sql/handler 0

669

username event_name count_star

670

user3 wait/io/table/sql/handler 0

671

user3 wait/lock/table/sql/handler 36

672

username event_name count_star

673

user4 wait/io/table/sql/handler 0

674

user4 wait/lock/table/sql/handler 0

675

execute dump_waits_account;

676

user host event_name count_star

677

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

678

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

679

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

680

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

681

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

682

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

683

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

684

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

685

execute dump_waits_user;

686

user event_name count_star

687

user1 wait/io/table/sql/handler 0

688

user1 wait/lock/table/sql/handler 36

689

user2 wait/io/table/sql/handler 0

690

user2 wait/lock/table/sql/handler 0

691

user3 wait/io/table/sql/handler 0

692

user3 wait/lock/table/sql/handler 36

693

user4 wait/io/table/sql/handler 0

694

user4 wait/lock/table/sql/handler 0

695

execute dump_waits_host;

696

host event_name count_star

697

localhost wait/io/table/sql/handler 0

698

localhost wait/lock/table/sql/handler 72

699

execute dump_waits_global;

700

event_name count_star

701

wait/io/table/sql/handler 0

702

wait/lock/table/sql/handler 72

703

execute dump_waits_history;

704

event_name count(event_name) object_type object_schema object_name

705

execute dump_waits_index_io;

706

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

707

TABLE test t1 NULL 0 0 0 0 0 0 0

708

TABLE test t1 index_b 0 0 0 0 0 0 0

709

TABLE test t1 index_cb 0 0 0 0 0 0 0

710

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

711

TABLE test t2 NULL 0 0 0 0 0 0 0

712

TABLE test t2 index_b 0 0 0 0 0 0 0

713

TABLE test t2 index_cb 0 0 0 0 0 0 0

714

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

715

TABLE test t3 NULL 0 0 0 0 0 0 0

716

TABLE test t3 index_b 0 0 0 0 0 0 0

717

TABLE test t3 index_cb 0 0 0 0 0 0 0

718

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

719

execute dump_waits_table_io;

720

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

721

TABLE test t1 0 0 0 0 0 0 0

722

TABLE test t2 0 0 0 0 0 0 0

723

TABLE test t3 0 0 0 0 0 0 0

724

execute dump_waits_table_lock;

725

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

726

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

727

TABLE test t2 24 8 16 4 0 0 0 4 0 0 8

728

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

729

execute dump_objects_summary;

730

object_type object_schema object_name count_star

731

TABLE test t1 20

732

TABLE test t2 24

733

TABLE test t3 28

734

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

735

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

736

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

737

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

738

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

739

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

740

select * from test.t1;

741

a b c d

742

101 1 1 4

743

201 1 1 3

744

301 1 1 2

745

401 1 1 0

746

select * from test.t2;

747

a b c d

748

102 2 2 3

749

103 3 3 3

750

202 2 2 2

751

203 3 3 2

752

302 2 2 1

753

303 3 3 1

754

402 2 2 0

755

403 3 3 0

756

select * from test.t3;

757

a b c d

758

104 4 4 3

759

105 5 5 3

760

106 6 6 3

761

204 4 4 2

762

205 5 5 2

763

206 6 6 2

764

304 4 4 1

765

305 5 5 1

766

306 6 6 1

767

404 4 4 0

768

405 5 5 0

769

406 6 6 0

770

update test.t1 set d=d+1;

771

update test.t2 set d=d+1;

772

update test.t3 set d=d+1;

773

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

774

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

775

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

776

select * from test.t1 where b=5;

777

a b c d

778

select * from test.t2 where b=5;

779

a b c d

780

select * from test.t3 where b=5;

781

a b c d

782

105 5 5 4

783

205 5 5 3

784

305 5 5 2

785

405 5 5 1

786

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

787

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

788

call dump_thread();

789

username event_name count_star

790

user1 wait/io/table/sql/handler 0

791

user1 wait/lock/table/sql/handler 36

792

username event_name count_star

793

user2 wait/io/table/sql/handler 0

794

user2 wait/lock/table/sql/handler 0

795

username event_name count_star

796

user3 wait/io/table/sql/handler 0

797

user3 wait/lock/table/sql/handler 36

798

username event_name count_star

799

user4 wait/io/table/sql/handler 0

800

user4 wait/lock/table/sql/handler 0

801

execute dump_waits_account;

802

user host event_name count_star

803

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

804

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

805

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

806

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

807

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

808

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

809

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

810

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

811

execute dump_waits_user;

812

user event_name count_star

813

user1 wait/io/table/sql/handler 0

814

user1 wait/lock/table/sql/handler 36

815

user2 wait/io/table/sql/handler 0

816

user2 wait/lock/table/sql/handler 0

817

user3 wait/io/table/sql/handler 0

818

user3 wait/lock/table/sql/handler 36

819

user4 wait/io/table/sql/handler 0

820

user4 wait/lock/table/sql/handler 0

821

execute dump_waits_host;

822

host event_name count_star

823

localhost wait/io/table/sql/handler 0

824

localhost wait/lock/table/sql/handler 72

825

execute dump_waits_global;

826

event_name count_star

827

wait/io/table/sql/handler 0

828

wait/lock/table/sql/handler 72

829

execute dump_waits_history;

830

event_name count(event_name) object_type object_schema object_name

831

execute dump_waits_index_io;

832

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

833

TABLE test t1 NULL 0 0 0 0 0 0 0

834

TABLE test t1 index_b 0 0 0 0 0 0 0

835

TABLE test t1 index_cb 0 0 0 0 0 0 0

836

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

837

TABLE test t2 NULL 0 0 0 0 0 0 0

838

TABLE test t2 index_b 0 0 0 0 0 0 0

839

TABLE test t2 index_cb 0 0 0 0 0 0 0

840

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

841

TABLE test t3 NULL 0 0 0 0 0 0 0

842

TABLE test t3 index_b 0 0 0 0 0 0 0

843

TABLE test t3 index_cb 0 0 0 0 0 0 0

844

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

845

execute dump_waits_table_io;

846

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

847

TABLE test t1 0 0 0 0 0 0 0

848

TABLE test t2 0 0 0 0 0 0 0

849

TABLE test t3 0 0 0 0 0 0 0

850

execute dump_waits_table_lock;

851

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

852

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

853

TABLE test t2 24 8 16 4 0 0 0 4 0 0 8

854

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

855

execute dump_objects_summary;

856

object_type object_schema object_name count_star

857

TABLE test t1 20

858

TABLE test t2 24

859

TABLE test t3 28

860

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

861

unlock tables;

862

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

863

unlock tables;

864

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

865

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

866

call dump_thread();

867

username event_name count_star

868

user1 wait/io/table/sql/handler 0

869

user1 wait/lock/table/sql/handler 48

870

username event_name count_star

871

user2 wait/io/table/sql/handler 0

872

user2 wait/lock/table/sql/handler 0

873

username event_name count_star

874

user3 wait/io/table/sql/handler 0

875

user3 wait/lock/table/sql/handler 36

876

username event_name count_star

877

user4 wait/io/table/sql/handler 0

878

user4 wait/lock/table/sql/handler 0

879

execute dump_waits_account;

880

user host event_name count_star

881

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

882

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

883

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

884

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

885

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

886

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

887

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

888

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

889

execute dump_waits_user;

890

user event_name count_star

891

user1 wait/io/table/sql/handler 0

892

user1 wait/lock/table/sql/handler 48

893

user2 wait/io/table/sql/handler 0

894

user2 wait/lock/table/sql/handler 0

895

user3 wait/io/table/sql/handler 0

896

user3 wait/lock/table/sql/handler 36

897

user4 wait/io/table/sql/handler 0

898

user4 wait/lock/table/sql/handler 0

899

execute dump_waits_host;

900

host event_name count_star

901

localhost wait/io/table/sql/handler 0

902

localhost wait/lock/table/sql/handler 84

903

execute dump_waits_global;

904

event_name count_star

905

wait/io/table/sql/handler 0

906

wait/lock/table/sql/handler 84

907

execute dump_waits_history;

908

event_name count(event_name) object_type object_schema object_name

909

execute dump_waits_index_io;

910

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

911

TABLE test t1 NULL 0 0 0 0 0 0 0

912

TABLE test t1 index_b 0 0 0 0 0 0 0

913

TABLE test t1 index_cb 0 0 0 0 0 0 0

914

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

915

TABLE test t2 NULL 0 0 0 0 0 0 0

916

TABLE test t2 index_b 0 0 0 0 0 0 0

917

TABLE test t2 index_cb 0 0 0 0 0 0 0

918

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

919

TABLE test t3 NULL 0 0 0 0 0 0 0

920

TABLE test t3 index_b 0 0 0 0 0 0 0

921

TABLE test t3 index_cb 0 0 0 0 0 0 0

922

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

923

execute dump_waits_table_io;

924

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

925

TABLE test t1 0 0 0 0 0 0 0

926

TABLE test t2 0 0 0 0 0 0 0

927

TABLE test t3 0 0 0 0 0 0 0

928

execute dump_waits_table_lock;

929

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

930

TABLE test t1 24 10 14 4 0 0 1 5 0 0 7

931

TABLE test t2 28 10 18 4 0 0 1 5 0 0 9

932

TABLE test t3 32 10 22 4 0 0 1 5 0 0 11

933

execute dump_objects_summary;

934

object_type object_schema object_name count_star

935

TABLE test t1 24

936

TABLE test t2 28

937

TABLE test t3 32

938

flush tables;

939

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

940

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

941

call dump_thread();

942

username event_name count_star

943

user1 wait/io/table/sql/handler 0

944

user1 wait/lock/table/sql/handler 48

945

username event_name count_star

946

user2 wait/io/table/sql/handler 0

947

user2 wait/lock/table/sql/handler 0

948

username event_name count_star

949

user3 wait/io/table/sql/handler 0

950

user3 wait/lock/table/sql/handler 36

951

username event_name count_star

952

user4 wait/io/table/sql/handler 0

953

user4 wait/lock/table/sql/handler 0

954

execute dump_waits_account;

955

user host event_name count_star

956

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

957

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

958

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

959

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

960

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

961

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

962

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

963

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

964

execute dump_waits_user;

965

user event_name count_star

966

user1 wait/io/table/sql/handler 0

967

user1 wait/lock/table/sql/handler 48

968

user2 wait/io/table/sql/handler 0

969

user2 wait/lock/table/sql/handler 0

970

user3 wait/io/table/sql/handler 0

971

user3 wait/lock/table/sql/handler 36

972

user4 wait/io/table/sql/handler 0

973

user4 wait/lock/table/sql/handler 0

974

execute dump_waits_host;

975

host event_name count_star

976

localhost wait/io/table/sql/handler 0

977

localhost wait/lock/table/sql/handler 84

978

execute dump_waits_global;

979

event_name count_star

980

wait/io/table/sql/handler 0

981

wait/lock/table/sql/handler 84

982

execute dump_waits_history;

983

event_name count(event_name) object_type object_schema object_name

984

execute dump_waits_index_io;

985

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

986

TABLE test t1 NULL 0 0 0 0 0 0 0

987

TABLE test t1 index_b 0 0 0 0 0 0 0

988

TABLE test t1 index_cb 0 0 0 0 0 0 0

989

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

990

TABLE test t2 NULL 0 0 0 0 0 0 0

991

TABLE test t2 index_b 0 0 0 0 0 0 0

992

TABLE test t2 index_cb 0 0 0 0 0 0 0

993

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

994

TABLE test t3 NULL 0 0 0 0 0 0 0

995

TABLE test t3 index_b 0 0 0 0 0 0 0

996

TABLE test t3 index_cb 0 0 0 0 0 0 0

997

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

998

execute dump_waits_table_io;

999

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1000

TABLE test t1 0 0 0 0 0 0 0

1001

TABLE test t2 0 0 0 0 0 0 0

1002

TABLE test t3 0 0 0 0 0 0 0

1003

execute dump_waits_table_lock;

1004

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

1005

TABLE test t1 24 10 14 4 0 0 1 5 0 0 7

1006

TABLE test t2 28 10 18 4 0 0 1 5 0 0 9

1007

TABLE test t3 32 10 22 4 0 0 1 5 0 0 11

1008

execute dump_objects_summary;

1009

object_type object_schema object_name count_star

1010

TABLE test t1 24

1011

TABLE test t2 28

1012

TABLE test t3 32

1013

set global read_only=1;

1014

set global read_only=0;

1015

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

1016

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

1017

call dump_thread();

1018

username event_name count_star

1019

user1 wait/io/table/sql/handler 0

1020

user1 wait/lock/table/sql/handler 48

1021

username event_name count_star

1022

user2 wait/io/table/sql/handler 0

1023

user2 wait/lock/table/sql/handler 0

1024

username event_name count_star

1025

user3 wait/io/table/sql/handler 0

1026

user3 wait/lock/table/sql/handler 36

1027

username event_name count_star

1028

user4 wait/io/table/sql/handler 0

1029

user4 wait/lock/table/sql/handler 0

1030

execute dump_waits_account;

1031

user host event_name count_star

1032

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

1033

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

1034

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

1035

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

1036

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

1037

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

1038

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

1039

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

1040

execute dump_waits_user;

1041

user event_name count_star

1042

user1 wait/io/table/sql/handler 0

1043

user1 wait/lock/table/sql/handler 48

1044

user2 wait/io/table/sql/handler 0

1045

user2 wait/lock/table/sql/handler 0

1046

user3 wait/io/table/sql/handler 0

1047

user3 wait/lock/table/sql/handler 36

1048

user4 wait/io/table/sql/handler 0

1049

user4 wait/lock/table/sql/handler 0

1050

execute dump_waits_host;

1051

host event_name count_star

1052

localhost wait/io/table/sql/handler 0

1053

localhost wait/lock/table/sql/handler 84

1054

execute dump_waits_global;

1055

event_name count_star

1056

wait/io/table/sql/handler 0

1057

wait/lock/table/sql/handler 84

1058

execute dump_waits_history;

1059

event_name count(event_name) object_type object_schema object_name

1060

execute dump_waits_index_io;

1061

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1062

TABLE test t1 NULL 0 0 0 0 0 0 0

1063

TABLE test t1 index_b 0 0 0 0 0 0 0

1064

TABLE test t1 index_cb 0 0 0 0 0 0 0

1065

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

1066

TABLE test t2 NULL 0 0 0 0 0 0 0

1067

TABLE test t2 index_b 0 0 0 0 0 0 0

1068

TABLE test t2 index_cb 0 0 0 0 0 0 0

1069

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1070

TABLE test t3 NULL 0 0 0 0 0 0 0

1071

TABLE test t3 index_b 0 0 0 0 0 0 0

1072

TABLE test t3 index_cb 0 0 0 0 0 0 0

1073

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

1074

execute dump_waits_table_io;

1075

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1076

TABLE test t1 0 0 0 0 0 0 0

1077

TABLE test t2 0 0 0 0 0 0 0

1078

TABLE test t3 0 0 0 0 0 0 0

1079

execute dump_waits_table_lock;

1080

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

1081

TABLE test t1 24 10 14 4 0 0 1 5 0 0 7

1082

TABLE test t2 28 10 18 4 0 0 1 5 0 0 9

1083

TABLE test t3 32 10 22 4 0 0 1 5 0 0 11

1084

execute dump_objects_summary;

1085

object_type object_schema object_name count_star

1086

TABLE test t1 24

1087

TABLE test t2 28

1088

TABLE test t3 32

1089

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

1090

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

1091

call dump_thread();

1092

username status

1093

user1 not found

1094

username event_name count_star

1095

user2 wait/io/table/sql/handler 0

1096

user2 wait/lock/table/sql/handler 0

1097

username event_name count_star

1098

user3 wait/io/table/sql/handler 0

1099

user3 wait/lock/table/sql/handler 36

1100

username event_name count_star

1101

user4 wait/io/table/sql/handler 0

1102

user4 wait/lock/table/sql/handler 0

1103

execute dump_waits_account;

1104

user host event_name count_star

1105

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

1106

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

1107

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

1108

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

1109

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

1110

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

1111

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

1112

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

1113

execute dump_waits_user;

1114

user event_name count_star

1115

user1 wait/io/table/sql/handler 0

1116

user1 wait/lock/table/sql/handler 48

1117

user2 wait/io/table/sql/handler 0

1118

user2 wait/lock/table/sql/handler 0

1119

user3 wait/io/table/sql/handler 0

1120

user3 wait/lock/table/sql/handler 36

1121

user4 wait/io/table/sql/handler 0

1122

user4 wait/lock/table/sql/handler 0

1123

execute dump_waits_host;

1124

host event_name count_star

1125

localhost wait/io/table/sql/handler 0

1126

localhost wait/lock/table/sql/handler 84

1127

execute dump_waits_global;

1128

event_name count_star

1129

wait/io/table/sql/handler 0

1130

wait/lock/table/sql/handler 84

1131

execute dump_waits_history;

1132

event_name count(event_name) object_type object_schema object_name

1133

execute dump_waits_index_io;

1134

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1135

TABLE test t1 NULL 0 0 0 0 0 0 0

1136

TABLE test t1 index_b 0 0 0 0 0 0 0

1137

TABLE test t1 index_cb 0 0 0 0 0 0 0

1138

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

1139

TABLE test t2 NULL 0 0 0 0 0 0 0

1140

TABLE test t2 index_b 0 0 0 0 0 0 0

1141

TABLE test t2 index_cb 0 0 0 0 0 0 0

1142

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1143

TABLE test t3 NULL 0 0 0 0 0 0 0

1144

TABLE test t3 index_b 0 0 0 0 0 0 0

1145

TABLE test t3 index_cb 0 0 0 0 0 0 0

1146

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

1147

execute dump_waits_table_io;

1148

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1149

TABLE test t1 0 0 0 0 0 0 0

1150

TABLE test t2 0 0 0 0 0 0 0

1151

TABLE test t3 0 0 0 0 0 0 0

1152

execute dump_waits_table_lock;

1153

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

1154

TABLE test t1 24 10 14 4 0 0 1 5 0 0 7

1155

TABLE test t2 28 10 18 4 0 0 1 5 0 0 9

1156

TABLE test t3 32 10 22 4 0 0 1 5 0 0 11

1157

execute dump_objects_summary;

1158

object_type object_schema object_name count_star

1159

TABLE test t1 24

1160

TABLE test t2 28

1161

TABLE test t3 32

1162

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

1163

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

1164

call dump_thread();

1165

username status

1166

user1 not found

1167

username status

1168

user2 not found

1169

username event_name count_star

1170

user3 wait/io/table/sql/handler 0

1171

user3 wait/lock/table/sql/handler 36

1172

username event_name count_star

1173

user4 wait/io/table/sql/handler 0

1174

user4 wait/lock/table/sql/handler 0

1175

execute dump_waits_account;

1176

user host event_name count_star

1177

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

1178

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

1179

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

1180

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

1181

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

1182

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

1183

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

1184

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

1185

execute dump_waits_user;

1186

user event_name count_star

1187

user1 wait/io/table/sql/handler 0

1188

user1 wait/lock/table/sql/handler 48

1189

user2 wait/io/table/sql/handler 0

1190

user2 wait/lock/table/sql/handler 0

1191

user3 wait/io/table/sql/handler 0

1192

user3 wait/lock/table/sql/handler 36

1193

user4 wait/io/table/sql/handler 0

1194

user4 wait/lock/table/sql/handler 0

1195

execute dump_waits_host;

1196

host event_name count_star

1197

localhost wait/io/table/sql/handler 0

1198

localhost wait/lock/table/sql/handler 84

1199

execute dump_waits_global;

1200

event_name count_star

1201

wait/io/table/sql/handler 0

1202

wait/lock/table/sql/handler 84

1203

execute dump_waits_history;

1204

event_name count(event_name) object_type object_schema object_name

1205

execute dump_waits_index_io;

1206

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1207

TABLE test t1 NULL 0 0 0 0 0 0 0

1208

TABLE test t1 index_b 0 0 0 0 0 0 0

1209

TABLE test t1 index_cb 0 0 0 0 0 0 0

1210

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

1211

TABLE test t2 NULL 0 0 0 0 0 0 0

1212

TABLE test t2 index_b 0 0 0 0 0 0 0

1213

TABLE test t2 index_cb 0 0 0 0 0 0 0

1214

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1215

TABLE test t3 NULL 0 0 0 0 0 0 0

1216

TABLE test t3 index_b 0 0 0 0 0 0 0

1217

TABLE test t3 index_cb 0 0 0 0 0 0 0

1218

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

1219

execute dump_waits_table_io;

1220

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1221

TABLE test t1 0 0 0 0 0 0 0

1222

TABLE test t2 0 0 0 0 0 0 0

1223

TABLE test t3 0 0 0 0 0 0 0

1224

execute dump_waits_table_lock;

1225

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

1226

TABLE test t1 24 10 14 4 0 0 1 5 0 0 7

1227

TABLE test t2 28 10 18 4 0 0 1 5 0 0 9

1228

TABLE test t3 32 10 22 4 0 0 1 5 0 0 11

1229

execute dump_objects_summary;

1230

object_type object_schema object_name count_star

1231

TABLE test t1 24

1232

TABLE test t2 28

1233

TABLE test t3 32

1234

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

1235

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

1236

call dump_thread();

1237

username status

1238

user1 not found

1239

username status

1240

user2 not found

1241

username status

1242

user3 not found

1243

username event_name count_star

1244

user4 wait/io/table/sql/handler 0

1245

user4 wait/lock/table/sql/handler 0

1246

execute dump_waits_account;

1247

user host event_name count_star

1248

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

1249

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

1250

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

1251

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

1252

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

1253

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

1254

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

1255

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

1256

execute dump_waits_user;

1257

user event_name count_star

1258

user1 wait/io/table/sql/handler 0

1259

user1 wait/lock/table/sql/handler 48

1260

user2 wait/io/table/sql/handler 0

1261

user2 wait/lock/table/sql/handler 0

1262

user3 wait/io/table/sql/handler 0

1263

user3 wait/lock/table/sql/handler 36

1264

user4 wait/io/table/sql/handler 0

1265

user4 wait/lock/table/sql/handler 0

1266

execute dump_waits_host;

1267

host event_name count_star

1268

localhost wait/io/table/sql/handler 0

1269

localhost wait/lock/table/sql/handler 84

1270

execute dump_waits_global;

1271

event_name count_star

1272

wait/io/table/sql/handler 0

1273

wait/lock/table/sql/handler 84

1274

execute dump_waits_history;

1275

event_name count(event_name) object_type object_schema object_name

1276

execute dump_waits_index_io;

1277

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1278

TABLE test t1 NULL 0 0 0 0 0 0 0

1279

TABLE test t1 index_b 0 0 0 0 0 0 0

1280

TABLE test t1 index_cb 0 0 0 0 0 0 0

1281

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

1282

TABLE test t2 NULL 0 0 0 0 0 0 0

1283

TABLE test t2 index_b 0 0 0 0 0 0 0

1284

TABLE test t2 index_cb 0 0 0 0 0 0 0

1285

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1286

TABLE test t3 NULL 0 0 0 0 0 0 0

1287

TABLE test t3 index_b 0 0 0 0 0 0 0

1288

TABLE test t3 index_cb 0 0 0 0 0 0 0

1289

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

1290

execute dump_waits_table_io;

1291

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1292

TABLE test t1 0 0 0 0 0 0 0

1293

TABLE test t2 0 0 0 0 0 0 0

1294

TABLE test t3 0 0 0 0 0 0 0

1295

execute dump_waits_table_lock;

1296

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

1297

TABLE test t1 24 10 14 4 0 0 1 5 0 0 7

1298

TABLE test t2 28 10 18 4 0 0 1 5 0 0 9

1299

TABLE test t3 32 10 22 4 0 0 1 5 0 0 11

1300

execute dump_objects_summary;

1301

object_type object_schema object_name count_star

1302

TABLE test t1 24

1303

TABLE test t2 28

1304

TABLE test t3 32

1305

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

1306

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

1307

call dump_thread();

1308

username status

1309

user1 not found

1310

username status

1311

user2 not found

1312

username status

1313

user3 not found

1314

username status

1315

user4 not found

1316

execute dump_waits_account;

1317

user host event_name count_star

1318

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

1319

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

1320

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

1321

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

1322

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

1323

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

1324

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

1325

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

1326

execute dump_waits_user;

1327

user event_name count_star

1328

user1 wait/io/table/sql/handler 0

1329

user1 wait/lock/table/sql/handler 48

1330

user2 wait/io/table/sql/handler 0

1331

user2 wait/lock/table/sql/handler 0

1332

user3 wait/io/table/sql/handler 0

1333

user3 wait/lock/table/sql/handler 36

1334

user4 wait/io/table/sql/handler 0

1335

user4 wait/lock/table/sql/handler 0

1336

execute dump_waits_host;

1337

host event_name count_star

1338

localhost wait/io/table/sql/handler 0

1339

localhost wait/lock/table/sql/handler 84

1340

execute dump_waits_global;

1341

event_name count_star

1342

wait/io/table/sql/handler 0

1343

wait/lock/table/sql/handler 84

1344

execute dump_waits_history;

1345

event_name count(event_name) object_type object_schema object_name

1346

execute dump_waits_index_io;

1347

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1348

TABLE test t1 NULL 0 0 0 0 0 0 0

1349

TABLE test t1 index_b 0 0 0 0 0 0 0

1350

TABLE test t1 index_cb 0 0 0 0 0 0 0

1351

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

1352

TABLE test t2 NULL 0 0 0 0 0 0 0

1353

TABLE test t2 index_b 0 0 0 0 0 0 0

1354

TABLE test t2 index_cb 0 0 0 0 0 0 0

1355

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1356

TABLE test t3 NULL 0 0 0 0 0 0 0

1357

TABLE test t3 index_b 0 0 0 0 0 0 0

1358

TABLE test t3 index_cb 0 0 0 0 0 0 0

1359

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

1360

execute dump_waits_table_io;

1361

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1362

TABLE test t1 0 0 0 0 0 0 0

1363

TABLE test t2 0 0 0 0 0 0 0

1364

TABLE test t3 0 0 0 0 0 0 0

1365

execute dump_waits_table_lock;

1366

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

1367

TABLE test t1 24 10 14 4 0 0 1 5 0 0 7

1368

TABLE test t2 28 10 18 4 0 0 1 5 0 0 9

1369

TABLE test t3 32 10 22 4 0 0 1 5 0 0 11

1370

execute dump_objects_summary;

1371

object_type object_schema object_name count_star

1372

TABLE test t1 24

1373

TABLE test t2 28

1374

TABLE test t3 32

1375

truncate performance_schema.events_waits_summary_by_thread_by_event_name;

1376

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

1377

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

1378

call dump_thread();

1379

username status

1380

user1 not found

1381

username status

1382

user2 not found

1383

username status

1384

user3 not found

1385

username status

1386

user4 not found

1387

execute dump_waits_account;

1388

user host event_name count_star

1389

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

1390

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

1391

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

1392

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

1393

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

1394

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

1395

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

1396

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

1397

execute dump_waits_user;

1398

user event_name count_star

1399

user1 wait/io/table/sql/handler 0

1400

user1 wait/lock/table/sql/handler 48

1401

user2 wait/io/table/sql/handler 0

1402

user2 wait/lock/table/sql/handler 0

1403

user3 wait/io/table/sql/handler 0

1404

user3 wait/lock/table/sql/handler 36

1405

user4 wait/io/table/sql/handler 0

1406

user4 wait/lock/table/sql/handler 0

1407

execute dump_waits_host;

1408

host event_name count_star

1409

localhost wait/io/table/sql/handler 0

1410

localhost wait/lock/table/sql/handler 84

1411

execute dump_waits_global;

1412

event_name count_star

1413

wait/io/table/sql/handler 0

1414

wait/lock/table/sql/handler 84

1415

execute dump_waits_history;

1416

event_name count(event_name) object_type object_schema object_name

1417

execute dump_waits_index_io;

1418

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1419

TABLE test t1 NULL 0 0 0 0 0 0 0

1420

TABLE test t1 index_b 0 0 0 0 0 0 0

1421

TABLE test t1 index_cb 0 0 0 0 0 0 0

1422

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

1423

TABLE test t2 NULL 0 0 0 0 0 0 0

1424

TABLE test t2 index_b 0 0 0 0 0 0 0

1425

TABLE test t2 index_cb 0 0 0 0 0 0 0

1426

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1427

TABLE test t3 NULL 0 0 0 0 0 0 0

1428

TABLE test t3 index_b 0 0 0 0 0 0 0

1429

TABLE test t3 index_cb 0 0 0 0 0 0 0

1430

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

1431

execute dump_waits_table_io;

1432

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1433

TABLE test t1 0 0 0 0 0 0 0

1434

TABLE test t2 0 0 0 0 0 0 0

1435

TABLE test t3 0 0 0 0 0 0 0

1436

execute dump_waits_table_lock;

1437

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

1438

TABLE test t1 24 10 14 4 0 0 1 5 0 0 7

1439

TABLE test t2 28 10 18 4 0 0 1 5 0 0 9

1440

TABLE test t3 32 10 22 4 0 0 1 5 0 0 11

1441

execute dump_objects_summary;

1442

object_type object_schema object_name count_star

1443

TABLE test t1 24

1444

TABLE test t2 28

1445

TABLE test t3 32

1446

truncate performance_schema.events_waits_summary_by_account_by_event_name;

1447

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

1448

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

1449

call dump_thread();

1450

username status

1451

user1 not found

1452

username status

1453

user2 not found

1454

username status

1455

user3 not found

1456

username status

1457

user4 not found

1458

execute dump_waits_account;

1459

user host event_name count_star

1460

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

1461

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

1462

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

1463

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

1464

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

1465

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

1466

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

1467

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

1468

execute dump_waits_user;

1469

user event_name count_star

1470

user1 wait/io/table/sql/handler 0

1471

user1 wait/lock/table/sql/handler 48

1472

user2 wait/io/table/sql/handler 0

1473

user2 wait/lock/table/sql/handler 0

1474

user3 wait/io/table/sql/handler 0

1475

user3 wait/lock/table/sql/handler 36

1476

user4 wait/io/table/sql/handler 0

1477

user4 wait/lock/table/sql/handler 0

1478

execute dump_waits_host;

1479

host event_name count_star

1480

localhost wait/io/table/sql/handler 0

1481

localhost wait/lock/table/sql/handler 84

1482

execute dump_waits_global;

1483

event_name count_star

1484

wait/io/table/sql/handler 0

1485

wait/lock/table/sql/handler 84

1486

execute dump_waits_history;

1487

event_name count(event_name) object_type object_schema object_name

1488

execute dump_waits_index_io;

1489

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1490

TABLE test t1 NULL 0 0 0 0 0 0 0

1491

TABLE test t1 index_b 0 0 0 0 0 0 0

1492

TABLE test t1 index_cb 0 0 0 0 0 0 0

1493

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

1494

TABLE test t2 NULL 0 0 0 0 0 0 0

1495

TABLE test t2 index_b 0 0 0 0 0 0 0

1496

TABLE test t2 index_cb 0 0 0 0 0 0 0

1497

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1498

TABLE test t3 NULL 0 0 0 0 0 0 0

1499

TABLE test t3 index_b 0 0 0 0 0 0 0

1500

TABLE test t3 index_cb 0 0 0 0 0 0 0

1501

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

1502

execute dump_waits_table_io;

1503

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1504

TABLE test t1 0 0 0 0 0 0 0

1505

TABLE test t2 0 0 0 0 0 0 0

1506

TABLE test t3 0 0 0 0 0 0 0

1507

execute dump_waits_table_lock;

1508

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

1509

TABLE test t1 24 10 14 4 0 0 1 5 0 0 7

1510

TABLE test t2 28 10 18 4 0 0 1 5 0 0 9

1511

TABLE test t3 32 10 22 4 0 0 1 5 0 0 11

1512

execute dump_objects_summary;

1513

object_type object_schema object_name count_star

1514

TABLE test t1 24

1515

TABLE test t2 28

1516

TABLE test t3 32

1517

truncate performance_schema.events_waits_summary_by_user_by_event_name;

1518

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

1519

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

1520

call dump_thread();

1521

username status

1522

user1 not found

1523

username status

1524

user2 not found

1525

username status

1526

user3 not found

1527

username status

1528

user4 not found

1529

execute dump_waits_account;

1530

user host event_name count_star

1531

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

1532

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

1533

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

1534

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

1535

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

1536

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

1537

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

1538

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

1539

execute dump_waits_user;

1540

user event_name count_star

1541

user1 wait/io/table/sql/handler 0

1542

user1 wait/lock/table/sql/handler 0

1543

user2 wait/io/table/sql/handler 0

1544

user2 wait/lock/table/sql/handler 0

1545

user3 wait/io/table/sql/handler 0

1546

user3 wait/lock/table/sql/handler 0

1547

user4 wait/io/table/sql/handler 0

1548

user4 wait/lock/table/sql/handler 0

1549

execute dump_waits_host;

1550

host event_name count_star

1551

localhost wait/io/table/sql/handler 0

1552

localhost wait/lock/table/sql/handler 84

1553

execute dump_waits_global;

1554

event_name count_star

1555

wait/io/table/sql/handler 0

1556

wait/lock/table/sql/handler 84

1557

execute dump_waits_history;

1558

event_name count(event_name) object_type object_schema object_name

1559

execute dump_waits_index_io;

1560

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1561

TABLE test t1 NULL 0 0 0 0 0 0 0

1562

TABLE test t1 index_b 0 0 0 0 0 0 0

1563

TABLE test t1 index_cb 0 0 0 0 0 0 0

1564

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

1565

TABLE test t2 NULL 0 0 0 0 0 0 0

1566

TABLE test t2 index_b 0 0 0 0 0 0 0

1567

TABLE test t2 index_cb 0 0 0 0 0 0 0

1568

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1569

TABLE test t3 NULL 0 0 0 0 0 0 0

1570

TABLE test t3 index_b 0 0 0 0 0 0 0

1571

TABLE test t3 index_cb 0 0 0 0 0 0 0

1572

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

1573

execute dump_waits_table_io;

1574

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1575

TABLE test t1 0 0 0 0 0 0 0

1576

TABLE test t2 0 0 0 0 0 0 0

1577

TABLE test t3 0 0 0 0 0 0 0

1578

execute dump_waits_table_lock;

1579

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

1580

TABLE test t1 24 10 14 4 0 0 1 5 0 0 7

1581

TABLE test t2 28 10 18 4 0 0 1 5 0 0 9

1582

TABLE test t3 32 10 22 4 0 0 1 5 0 0 11

1583

execute dump_objects_summary;

1584

object_type object_schema object_name count_star

1585

TABLE test t1 24

1586

TABLE test t2 28

1587

TABLE test t3 32

1588

truncate performance_schema.events_waits_summary_by_host_by_event_name;

1589

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

1590

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

1591

call dump_thread();

1592

username status

1593

user1 not found

1594

username status

1595

user2 not found

1596

username status

1597

user3 not found

1598

username status

1599

user4 not found

1600

execute dump_waits_account;

1601

user host event_name count_star

1602

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

1603

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

1604

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

1605

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

1606

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

1607

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

1608

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

1609

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

1610

execute dump_waits_user;

1611

user event_name count_star

1612

user1 wait/io/table/sql/handler 0

1613

user1 wait/lock/table/sql/handler 0

1614

user2 wait/io/table/sql/handler 0

1615

user2 wait/lock/table/sql/handler 0

1616

user3 wait/io/table/sql/handler 0

1617

user3 wait/lock/table/sql/handler 0

1618

user4 wait/io/table/sql/handler 0

1619

user4 wait/lock/table/sql/handler 0

1620

execute dump_waits_host;

1621

host event_name count_star

1622

localhost wait/io/table/sql/handler 0

1623

localhost wait/lock/table/sql/handler 0

1624

execute dump_waits_global;

1625

event_name count_star

1626

wait/io/table/sql/handler 0

1627

wait/lock/table/sql/handler 84

1628

execute dump_waits_history;

1629

event_name count(event_name) object_type object_schema object_name

1630

execute dump_waits_index_io;

1631

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1632

TABLE test t1 NULL 0 0 0 0 0 0 0

1633

TABLE test t1 index_b 0 0 0 0 0 0 0

1634

TABLE test t1 index_cb 0 0 0 0 0 0 0

1635

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

1636

TABLE test t2 NULL 0 0 0 0 0 0 0

1637

TABLE test t2 index_b 0 0 0 0 0 0 0

1638

TABLE test t2 index_cb 0 0 0 0 0 0 0

1639

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1640

TABLE test t3 NULL 0 0 0 0 0 0 0

1641

TABLE test t3 index_b 0 0 0 0 0 0 0

1642

TABLE test t3 index_cb 0 0 0 0 0 0 0

1643

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

1644

execute dump_waits_table_io;

1645

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1646

TABLE test t1 0 0 0 0 0 0 0

1647

TABLE test t2 0 0 0 0 0 0 0

1648

TABLE test t3 0 0 0 0 0 0 0

1649

execute dump_waits_table_lock;

1650

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

1651

TABLE test t1 24 10 14 4 0 0 1 5 0 0 7

1652

TABLE test t2 28 10 18 4 0 0 1 5 0 0 9

1653

TABLE test t3 32 10 22 4 0 0 1 5 0 0 11

1654

execute dump_objects_summary;

1655

object_type object_schema object_name count_star

1656

TABLE test t1 24

1657

TABLE test t2 28

1658

TABLE test t3 32

1659

truncate performance_schema.events_waits_summary_global_by_event_name;

1660

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

1661

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

1662

call dump_thread();

1663

username status

1664

user1 not found

1665

username status

1666

user2 not found

1667

username status

1668

user3 not found

1669

username status

1670

user4 not found

1671

execute dump_waits_account;

1672

user host event_name count_star

1673

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

1674

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

1675

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

1676

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

1677

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

1678

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

1679

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

1680

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

1681

execute dump_waits_user;

1682

user event_name count_star

1683

user1 wait/io/table/sql/handler 0

1684

user1 wait/lock/table/sql/handler 0

1685

user2 wait/io/table/sql/handler 0

1686

user2 wait/lock/table/sql/handler 0

1687

user3 wait/io/table/sql/handler 0

1688

user3 wait/lock/table/sql/handler 0

1689

user4 wait/io/table/sql/handler 0

1690

user4 wait/lock/table/sql/handler 0

1691

execute dump_waits_host;

1692

host event_name count_star

1693

localhost wait/io/table/sql/handler 0

1694

localhost wait/lock/table/sql/handler 0

1695

execute dump_waits_global;

1696

event_name count_star

1697

wait/io/table/sql/handler 0

1698

wait/lock/table/sql/handler 0

1699

execute dump_waits_history;

1700

event_name count(event_name) object_type object_schema object_name

1701

execute dump_waits_index_io;

1702

object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete

1703

TABLE test t1 NULL 0 0 0 0 0 0 0

1704

TABLE test t1 index_b 0 0 0 0 0 0 0

1705

TABLE test t1 index_cb 0 0 0 0 0 0 0

1706

TABLE test t1 PRIMARY 0 0 0 0 0 0 0

1707

TABLE test t2 NULL 0 0 0 0 0 0 0

1708

TABLE test t2 index_b 0 0 0 0 0 0 0

1709

TABLE test t2 index_cb 0 0 0 0 0 0 0

1710

TABLE test t2 PRIMARY 0 0 0 0 0 0 0

1711

TABLE test t3 NULL 0 0 0 0 0 0 0

1712

TABLE test t3 index_b 0 0 0 0 0 0 0

1713

TABLE test t3 index_cb 0 0 0 0 0 0 0

1714

TABLE test t3 PRIMARY 0 0 0 0 0 0 0

1715

execute dump_waits_table_io;

1716

object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete

1717

TABLE test t1 0 0 0 0 0 0 0

1718

TABLE test t2 0 0 0 0 0 0 0

1719

TABLE test t3 0 0 0 0 0 0 0

1720

execute dump_waits_table_lock;

1721

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

1722

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

1723

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

1724

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

1725

execute dump_objects_summary;

1726

object_type object_schema object_name count_star

1727

TABLE test t1 0

1728

TABLE test t2 0

1729

TABLE test t3 0

1730

show status like "performance_schema%";

1731

Variable_name Value

1732

Performance_schema_accounts_lost 0

1733

Performance_schema_cond_classes_lost 0

1734

Performance_schema_cond_instances_lost 0

1735

Performance_schema_digest_lost 0

1736

Performance_schema_file_classes_lost 0

1737

Performance_schema_file_handles_lost 0

1738

Performance_schema_file_instances_lost 0

1739

Performance_schema_hosts_lost 0

1740

Performance_schema_locker_lost 0

1741

Performance_schema_mutex_classes_lost 0

1742

Performance_schema_mutex_instances_lost 0

1743

Performance_schema_rwlock_classes_lost 0

1744

Performance_schema_rwlock_instances_lost 0

1745

Performance_schema_session_connect_attrs_lost 0

1746

Performance_schema_socket_classes_lost 0

1747

Performance_schema_socket_instances_lost 0

1748

Performance_schema_stage_classes_lost 0

1749

Performance_schema_statement_classes_lost 0

1750

Performance_schema_table_handles_lost 0

1751

Performance_schema_table_instances_lost 0

1752

Performance_schema_thread_classes_lost 0

1753

Performance_schema_thread_instances_lost 0

1754

Performance_schema_users_lost 0