Go runtime related problems in TiDB production environment About me ● Arthur Mao(毛康力), Senior Engineer@PingCAP ● TiDB core developer (top3 contributor) ● GitBook about golang internals (@tiancaiamao) not exhausted, but where is the bottleneck? Description ● The table is wide in the customer environment ○ CPU usage is higher with less columns ● The deployment does not consider NUMA ○ CPU usage is

case . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 354 Test environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 354 Test engine . . . . Test case configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 355 Environment configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356 Run the test engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 358 Set up the test environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 358 Test phase . . . . . . . . . .

case . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 327 Test environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 327 Test engine . . . . Test case configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 328 Environment configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 329 Run the test engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331 Set up the test environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331 Test phase . . . . . . . . . .

case . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 491 Test environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 491 Test engine . . . . Test case configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 492 Environment configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 493 Run the test engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 496 Set up the test environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 497 Test phase . . . . . . . . . .

case . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 462 Test environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 462 Test engine . . . . Test case configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 463 Environment configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 464 Run the test engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 467 Set up the test environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 468 Test phase . . . . . . . . . .

Script 436 Setting the Greenplum Database Timezone 437 Setting Greenplum Environment Variables 437 To set up the gpadmin environment for Greenplum Database 438 Next Steps 438 Allowing Client Connections Utilities 493 Greenplum Environment Variables 493 Required Environment Variables 493 GPHOME 493 PATH 494 LD_LIBRARY_PATH 494 MASTER_DATA_DIRECTORY 494 Optional Environment Variables 494 PGAPPNAME Client and Loader Tools 655 Prerequisites 655 Setting Up Your Greenplum Database Clients Runtime Environment 655 Running the Client and Loader Programs 656 Greenplum Database Documentation References 656

Greenplum Database Timezone 422 Setting Greenplum Environment Variables 422 VMware Tanzu Greenplum 6 Documentation VMware, Inc 17 To set up the gpadmin environment for Greenplum Database 423 Next Steps 423 Segment Host iptables Rules 473 Installation Management Utilities 473 Greenplum Environment Variables 474 Required Environment Variables 474 GPHOME 474 PATH 474 VMware Tanzu Greenplum 6 Documentation VMware, Inc 19 LD_LIBRARY_PATH 474 MASTER_DATA_DIRECTORY 475 Optional Environment Variables 475 PGAPPNAME 475 PGDATABASE 475 PGHOST 475 PGHOSTADDR 475 PGPASSWORD 475 PGPASSFILE 475 PGOPTIONS

Script 419 Setting the Greenplum Database Timezone 419 Setting Greenplum Environment Variables 420 To set up the gpadmin environment for Greenplum Database 420 Next Steps 421 Allowing Client Connections Utilities 471 Greenplum Environment Variables 471 Required Environment Variables 471 GPHOME 471 PATH 472 LD_LIBRARY_PATH 472 MASTER_DATA_DIRECTORY 472 Optional Environment Variables 472 PGAPPNAME Client and Loader Tools 629 Prerequisites 629 Setting Up Your Greenplum Database Clients Runtime Environment 630 Running the Client and Loader Programs 630 Greenplum Database Documentation References 631

with Greenplum 342 The Functional Unit 342 Deploying VMware Greenplum to an Existing vSphere Environment 342 Determining the RAID Type 343 vSAN ESA 343 vSAN OSA 343 Planning for a Deployment 343 Script 430 Setting the Greenplum Database Timezone 430 Setting Greenplum Environment Variables 431 To set up the gpadmin environment for Greenplum Database 431 Next Steps 432 Allowing Client Connections Utilities 497 Greenplum Environment Variables 497 Required Environment Variables 497 GPHOME 498 PATH 498 LD_LIBRARY_PATH 498 MASTER_DATA_DIRECTORY 498 Optional Environment Variables 498 PGAPPNAME

Script 411 Setting the Greenplum Database Timezone 412 Setting Greenplum Environment Variables 412 To set up the gpadmin environment for Greenplum Database 413 Next Steps 413 Allowing Client Connections Utilities 468 Greenplum Environment Variables 468 Required Environment Variables 469 GPHOME 469 PATH 469 LD_LIBRARY_PATH 469 MASTER_DATA_DIRECTORY 469 Optional Environment Variables 470 PGAPPNAME Client and Loader Tools 633 Prerequisites 633 Setting Up Your Greenplum Database Clients Runtime Environment 634 Running the Client and Loader Programs 634 Greenplum Database Documentation References 635