"'Yemi Obembe" <[EMAIL PROTECTED]> wrote on 17/06/2005 09:40:39:
> Hi all, > just want to know if there is a specific number of concorent users > dat can query from a mysql databasee at d same time. MySQL has a configurable limit to the number of simultaneous connections that it can support. See http://dev.mysql.com/doc/mysql/en/server-system-variables.html This can be increased provided you have the system resources to handle the increased number of connections. On a finer grain, MySQL will interleave simultaneous queries, subject to table locking, as they pause requiring disk access. However, once they are performing memory-locked operations, a single query will lock a CPU. On multi-CPU machines, it will generally run queries in parallel on the separate CPUs. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
