PDA

View Full Version : Best MySQL plugin?


CH | FuDo
28/01/2014, 03:16 PM
Okay, title of topic says everything. Which MySQL plugin is best to use? Thank you.

ikey07
28/01/2014, 03:21 PM
This one:
http://forum.sa-mp.com/showthread.php?t=122983

Also it has Static Linux Distributions versions, which make it easier to use, many will suggest you BlueG's plugin, but I dont find it usleful.

maddinat0r
28/01/2014, 03:22 PM
BlueG's MySQL plugin of course. The support is good, there is a good documentation about every function (http://wiki.sa-mp.com/wiki/MySQL/R33) and it's actively developed.

Jimmy0wns
28/01/2014, 03:22 PM
Strickenkid, the fastest one.

Konstantinos
28/01/2014, 03:24 PM
Strickenkid, the fastest one.

Don't say things you cannot prove. Strickenkid's plugin is very old and slow, it's not recommended at all.

Scenario
28/01/2014, 03:34 PM
BlueG's. Strickenkid's plugin hasn't been updated in YEARS, it's outdated and slow.

CH | FuDo
28/01/2014, 03:34 PM
Well, I use Blue-G but when I upload on my Linux server, I got this error

Loading plugin: mysql.so
[20:28:57] Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)

How to fix this? Thank you!

maddinat0r
28/01/2014, 03:56 PM
Well, I use Blue-G but when I upload on my Linux server, I got this error

Loading plugin: mysql.so
[20:28:57] Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)

How to fix this? Thank you!
Use the mysql_static.so.

EDIT:
Strickenkid, the fastest one.
I made a benchmark:

Sending 100 unthreaded queries (10000 rows per query) and fetching every field per index
Strickenkid's: 3300ms
BlueG's: 3100ms

So yeah, BlueG's plugin is still faster. I think I don't need to make a benchmark using threaded queries.

CH | FuDo
28/01/2014, 04:11 PM
Use the mysql_static.so.


Added to server.cfg on line plugins mysql_static.so
Still not working.. Any other help? Thank you.

maddinat0r
28/01/2014, 04:35 PM
Added to server.cfg on line plugins mysql_static.so
Still not working.. Any other help? Thank you.

What do you mean with "still not working"? I can't help you without getting at least an error message.
It's also impossible that the mysql_static.so generates the same error message you had before, so don't answer like "the error is the same".