Example operation MySQL short link

Example operation MySQL short link

How to set up a MySQL short link

1. Check the mysql connection number statement command:

2. First, log in to MYSQL as a super user. Note that you must be a super user, otherwise you will be prompted that you do not have permission to modify.

3. Press the Enter key to execute and the current timeout will be displayed:

4. The default timeout period is displayed, which is 8 hours (in seconds). Now reset the parameter, for example, we want to set the timeout period to 10 hours.

5. Press Enter to execute the displayed result:

6. You can re-use show global variables like 'wait_timeout' to verify.

This method is more intuitive, and the set parameters take effect immediately.

The above steps are very simple. Thank you for reading and supporting 123WORDPRESS.COM.

You may also be interested in:
  • Problems and solutions of error 08001 when linking to MySQL in IDEA and no table display after successful connection
  • After installing Navicat in MySQL, 2059 appears, Authentication plugin and local link virtual machine docker, remote link server
  • Python pymysql link database query results converted to Dataframe instance
  • Detailed explanation of MySQL multi-table query examples [link query, subquery, etc.]
  • Summary of the installation process of MySql 8.0.11 and the problems encountered when linking with Navicat
  • Detailed explanation of the use of MySQL group links
  • MySql uses skip-name-resolve to solve the problem of slow external network connection client
  • How to use ssh tunnel to connect to mysql server
  • How to view MySQL links and kill abnormal links

<<:  Summary of some practical little magic in Vue practice

>>:  Summary of Linux sftp command usage

Recommend

How MLSQL Stack makes stream debugging easier

Preface A classmate is investigating MLSQL Stack&...

How to use the Linux md5sum command

01. Command Overview md5sum - Calculate and verif...

Solutions to MySQL OOM (memory overflow)

OOM stands for "Out Of Memory", which m...

How to install and configure WSL on Windows

What is WSL Quoting a passage from Baidu Encyclop...

MySQL high concurrency method to generate unique order number

Preface After this blog post was published, some ...

Implementation of multi-port mapping of nginx reverse proxy

Code Explanation 1.1 http:www.baidu.test.com defa...

Simple steps to create a MySQL container with Docker

Preface We have already installed Docker and have...

Vue routing relative path jump method

Table of contents Vue routing relative path jump ...

Some questions about hyperlinks

I am very happy to attend this episode of potato ...

win2008 server security settings deployment document (recommended)

I had been working on the project before the New ...

Application and implementation of data cache mechanism for small programs

Mini Program Data Cache Related Knowledge Data ca...

Learn MySQL in a simple way

Preface The database has always been my weak poin...

SQL statements in Mysql do not use indexes

MySQL query not using index aggregation As we all...

About using Alibaba's iconfont vector icon in Vue

There are many import methods on the Internet, an...