MySQL中的多线程？ [英] Multithreading in MySQL?

问题描述

MySQL操作是多线程的吗？

Are MySQL operations multithreaded?

具体来说，在运行select时，select（或join）算法是否会产生多个线程一起运行？

Specifically, on running a select, does the select (or join) algorithm spawn multiple threads to run together? Would being multi-threaded prevent being able to support a lot of concurrent users?

推荐答案

在MySQL服务器中运行的几个后台线程。多线程防止能够支持很多并发用户。此外，每个数据库连接由单个线程提供服务。在MySQL中不能实现并行查询（使用多线程选择）。

Several background threads run in a MySQL server. Also, each database connection is served by a single thread. Parallel queries (selects using multiple threads) are not implemented in MySQL.

MySQL可以支持很多并发useres。例如，Facebook使用MySQL成功启动。

MySQL as is can support "a lot of concurrent useres". For example Facebook started successfully with MySQL.

这篇关于MySQL中的多线程？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！