Quote:
Originally Posted by PawnoQ
Does it make a huge difference?
|
It can, yes.
Quote:
Can the server performance/lag be improved/decreased by using the new MySQL-Plugin?
|
Performance around MySQL functions will see great improvement, especially if using threaded queries, as the server won't freeze briefly on each query.
Quote:
As i have heard the old Plugin does not use threading and can freeze the server for as long as a query takes
to execute, is that true?
|
Yes, using the mysql_query function (which still exists in newer versions of the plugin, but still causes the same effect) uses the same thread as the server. This means that everything else is not processed until this finishes (client-server sync, commands, etc). This can be especially noticeable when executing larger queries.
Quote:
Can there be a noticeable negative impact using the old Plugin?
|
Yes. Upgrading to a newer version is recommended for many reasons: increased security (which is especially important when handling information such as passwords, even if hashed), better performance, a wider array of functions/capabilities, issues with the plugin are routinely fixed through new releases. Query threading is a key point of newer versions, this uses a different thread to handle the query which means everything else still happens while the query is executing.
