What is the maximum number of MySQL connections?

Source: Internet
Author: User
What I mean is a connection?
A process connection Mysql,mysql assign a process to the request to connect to PHP, is this even a connection?
For example, the maximum number of MySQL connections is 50, does it mean that the MySQL restaurant has 50 waiters, right?
If the use of persistent connection, it means that the waiter only to a specific customer (PHP process) services, the other customers can not use the waiter, right???

Reply content:

What I mean is a connection?
A process connection Mysql,mysql assign a process to the request to connect to PHP, is this even a connection?
For example, the maximum number of MySQL connections is 50, does it mean that the MySQL restaurant has 50 waiters, right?
If the use of persistent connection, it means that the waiter only to a specific customer (PHP process) services, the other customers can not use the waiter, right???

You understand the right.

However, the general PHP initial concurrency is not high when it is better to take a connection to complete the disconnection, because the database generally support the concurrent connections are very low, hundred levels. You said long links are typically used for connection pooling technology, which is used by the application code to maintain SQL queues to thoroughly crush database performance.

MySQL is your restaurant with a total of 50 seats, one less per use. If you have 50 seats full of people. But the guests can still come into your restaurant. But there is no place to eat. Too few meals (too few connections). Increase the number of connections is to increase the dining place

  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.