05.07.2014, 16:28
Quote:
1) These pools are only for mysql_pquery as far as I know. Just leave it the default setting.
2) Check if mysql_errno returns 0 after mysql_connect, if yes connection was successful. 3) Yes, the entire R39 plugin is save to use. |
Quote:
Mellnik already summed it up pretty well. However, I want to give you a more detailed answer on 1):
The multi-thread system holds a pool of several direct connections to the MySQL server. Usually, there are only two direct connections: the threaded one (mysql_tquery) and the unthreaded one (mysql_query). However, there is also mysql_pquery, which concurrently sends queries over several direct connections, which are in the pool mentioned earlier. You can adjust that number of connections via the pool_size parameter in mysql_connect. The MySQL server limits the number of direct connections (I think 10 by default), so settings the pool size to a high number is very bad and will possibly prevent other programs from accessing the MySQL server. |