mysql tips

While testing of mysql using sysbench I wanted to ensure that sysbench client is using SSL connection. For this  performance_schema came handy. mysql> SELECT CONNECTION_TYPE from performance_schema.threads where processlist_command='Query'; +-----------------+ | CONNECTION_TYPE | +-----------------+ | SSL/TLS         | +-----------------+ mysql> desc performance_schema.threads ; +---------------------+---------------------+------+-----+---------+-------+ | Field               | Type                | Null | Key | Default | Extra | +---------------------+---------------------+------+-----+---------+-------+ | THREAD_ID           | bigint(20) unsigned | NO   | PRI | NULL    |       | | NAME                | varchar(128)        | NO...