I was working at a payment service team from 2019-2021. The blog is based on my experience at that time. 在支付系统中,数据库则是最容易产生性能瓶颈的组件。 在本文中,我们将讨论支付服务是如何在大规模下对My
Show MySQL processlist SHOW FULL PROCESSLIST Check Binlog show variables like 'log_bin' show tables SHOW TABLES command provides you with an option that allows you to filter the returned tables using the LIKE operator or an expression in the WHERE clause as follows: SHOW TABLES LIKE pattern; SHOW TABLES WHERE expression; > SHOW TABLES LIKE 'p%'; +------------------------------+ | Tables_in_testdb (p%) | +------------------------------+ | productlines | | products | +------------------------------+ 2