Why does it take such a long time to connect to the mSQL database server?
Sometimes you may have difficulty in connecting to the mSQL database server – msqld. msqld is a single threaded application and therefore can only deal with one SQL query at a time. If msqld is busy servicing an SQL query you may not be able to make another connection until the SQL query has finished. mSQL version 1.x is extremely inefficient in performing table joins. So an SQL query with only a single table join may take many minutes to complete. There is no solution to this problem in mSQL version 1.x. The only possible workaround is to ensure that your database schema is designed in such a way as to avoid table joins at all costs. Table joins are much more efficient under mSQL version 2.x so the problem will rarely be encountered.
Related Questions
- Every time when the server shuts down I get error reports that F-Secure SMTP and Real-Time Scanners cannot connect to the server. What is the problem?
- Every time I try to connect to a MySQL database on remote Linux server, I get the Lost connection to MySQL server during query error. Whats wrong?
- Why does it take such a long time to connect to the mSQL database server?
