[Plugin] [REL] MySQL Plugin (Now on github!)

[Plugin] [REL] MySQL Plugin (Now on github!) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: [Plugin] [REL] MySQL Plugin (Now on github!) (/showthread.php?tid=56564)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128

Re: [REL] MySQL Plugin (Now on github!) - IstuntmanI - 07.03.2014

Nice one ! Thanks !

Re: [REL] MySQL Plugin (Now on github!) - iZN - 07.03.2014

Thanks maddinat0r.

Re: [REL] MySQL Plugin (Now on github!) - iBeast - 07.03.2014

Thanks.

Re: [REL] MySQL Plugin (Now on github!) - kristo - 09.03.2014

What should I replace mysql_free_result with after updating from R37 to R38?

Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 09.03.2014

Quote:

Originally Posted by kvann

What should I replace mysql_free_result with after updating from R37 to R38?

Why do you use mysql_free_result at all? mysql_free_result was a PAWN function defined inside the include which did absolutely nothing.

Re: [REL] MySQL Plugin (Now on github!) - kurta999 - 09.03.2014

What about re-adding mysql_ping() but for get the real time ping between mysql server and the samp server?

Re: [REL] MySQL Plugin (Now on github!) - kristo - 09.03.2014

Quote:

Originally Posted by maddinat0r

Why do you use mysql_free_result at all? mysql_free_result was a PAWN function defined inside the include which did absolutely nothing.

Ohh... I hadn't looked at the include at all.

Re: [REL] MySQL Plugin (Now on github!) - Calgon - 09.03.2014

Quote:

Originally Posted by maddinat0r

Why do you use mysql_free_result at all? mysql_free_result was a PAWN function defined inside the include which did absolutely nothing.

Do results clear automatically now?

Re: [REL] MySQL Plugin (Now on github!) - Kyle - 09.03.2014

Quote:

Originally Posted by Calgon

Do results clear automatically now?

Afaik they have done for awhile, atleast R26+.

Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 09.03.2014

Quote:

Originally Posted by Calgon

Do results clear automatically now?

They do since R7. You have to delete the cache manually though if you are using "cache_save" or "mysql_query".

EDIT:
Whoops, forgot that there were also uncached queries in R7. Results are cleared automatically since R21.

Re: [REL] MySQL Plugin (Now on github!) - KovaNovik - 09.03.2014

My script was working in R37, but now in R38, it isn't.

Now I recompiled it and it says: error 017: undefined symbol "mysql_num_rows".

What I have to do now?

Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 09.03.2014

Quote:

Originally Posted by KovaNovik

My script was working in R37, but now in R38, it isn't.

Now I recompiled it and it says: error 017: undefined symbol "mysql_num_rows".

What I have to do now?

Replace "mysql_num_rows" with "cache_num_rows" or "cache_get_row_count".

Re: [REL] MySQL Plugin (Now on github!) - Admigo - 10.03.2014

@ maddinat0r: Can you help with a problem i have with mysql r38? You can find it here:
https://sampforum.blast.hk/showthread.php?tid=499935

Re: [REL] MySQL Plugin (Now on github!) - DobbysGamertag - 12.03.2014

Is there a reason why it spams my logs? or is this normal?

Code:

[03:38:19] [DEBUG] CMySQLHandle::Create - creating new connection..
[03:38:19] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[03:38:19] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[03:38:19] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:38:19] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:38:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been disabled
[03:38:19] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:38:19] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:38:19] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:38:19] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:38:19] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:38:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been disabled
[03:38:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been disabled
[03:38:19] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:38:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been disabled

Just one mysql_connect() with mysql_log(LOG_ALL,LOG_TYPE_TEXT); in OnGameModeInit(). I think the DB type is InnoDB. Can someone explain this? The last MySQL plugin i used was fine and had none of this (R6).

Re: [REL] MySQL Plugin (Now on github!) - Kar - 12.03.2014

thats because of your pool size

Re: [REL] MySQL Plugin (Now on github!) - Arjanz - 12.03.2014

R5 was best

Re: [REL] MySQL Plugin (Now on github!) - DobbysGamertag - 12.03.2014

So my issue is nothing to worry about? Or should I change pool size?

Re: [REL] MySQL Plugin (Now on github!) - iZN - 12.03.2014

Quote:

Originally Posted by Arjanz

R5 was best

How R5 is best? After R6, the MySQL plugin supports threaded queries which are faster than unthreaded queries of MySQL R1 to R6 or R6-2 (which was later moved to R7 with threaded queries support).

Quote:

Originally Posted by DobbysGamertag

So my issue is nothing to worry about? Or should I change pool size?

What is your pool size set to? It is 2 by default.

Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 12.03.2014

Quote:

Originally Posted by DobbysGamertag

Is there a reason why it spams my logs? or is this normal?

Code:

[03:38:19] [DEBUG] CMySQLHandle::Create - creating new connection..
[03:38:19] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[03:38:19] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[03:38:19] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:38:19] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:38:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been disabled
[03:38:19] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:38:19] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:38:19] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[03:38:19] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:38:19] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:38:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been disabled
[03:38:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been disabled
[03:38:19] [DEBUG] CMySQLConnection::Connect - connection was successful
[03:38:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been disabled

You knew, there is a nice F.A.Q. on the Github site with exactly the same question as yours (I don't blame you for not seeing it, just want to say that there is a F.A.Q).

Quote:

Originally Posted by F.A.Q.

Q: I get a ton of debug messages regarding connections even though I'm calling mysql_connect only once, why is that so?
A: That's because the plugin uses multiple direct database connections per connection handle. The number of direct connections (and thus the number of those log messages) is 2+pool_size.

Re: [REL] MySQL Plugin (Now on github!) - Kar - 19.03.2014

@maddinat0r, why did you start field indexes at 0 and not 1?