[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!) - caoraivoso3 - 07.07.2014

hi all, i am changing my gamemode to the new system orm( i guess it is faster) but when i put the new version i see that this function
mysql_insert_id()
doesn't exists.
We have something similar? it gets the AUTO_INCREMENT id

AW: Re: [REL] MySQL Plugin (Now on github!) - Mellnik - 07.07.2014

Quote:

Originally Posted by caoraivoso3

hi all, i am changing my gamemode to the new system orm( i guess it is faster) but when i put the new version i see that this function
mysql_insert_id()
doesn't exists.
We have something similar? it gets the AUTO_INCREMENT id

pawn Код:

cache_insert_id();

Read through the include

Re: [REL] MySQL Plugin (Now on github!) - Danny - 08.07.2014

Hi, it's me again. After my update to R39-2 I noticed another problem: the plugin's performance on startup is very bad from localhost. Loading 66 rows with cache takes up to 12 seconds. This is the same for the other loading processes. My server even hangs because of it, going from OnPlayerConnect to OnPlayerRequestClass takes 102 (!!!) seconds. It worked like a charm before, when I was using R17.

I'm pretty sure I'm doing something wrong here. My OS is Windows 7 32-bit, I'm only using threaded queries (pqueries) in my script.

AW: Re: [REL] MySQL Plugin (Now on github!) - Mellnik - 08.07.2014

Quote:

Originally Posted by Danny

Hi, it's me again. After my update to R39-2 I noticed another problem: the plugin's performance on startup is very bad from localhost. Loading 66 rows with cache takes up to 12 seconds. This is the same for the other loading processes. My server even hangs because of it, going from OnPlayerConnect to OnPlayerRequestClass takes 102 (!!!) seconds. It worked like a charm before, when I was using R17.

I'm pretty sure I'm doing something wrong here. My OS is Windows 7 32-bit, I'm only using threaded queries (pqueries) in my script.

Could you turn on mysql_log(LOG_ALL) and post the entire mysql_log.txt? It contains exact query execution times.

Re: AW: Re: [REL] MySQL Plugin (Now on github!) - Danny - 08.07.2014

Quote:

Originally Posted by Mellnik

Could you turn on mysql_log(LOG_ALL) and post the entire mysql_log.txt? It contains exact query execution times.

Sure, here you go: http://tny.cz/f9a692ad
Amount of rows: http://puu.sh/a2fNj/ade97206a3.png

Unfortunately this isn't the log which caused a 102-second server hang. I deleted that one accidentally. But still you can see here loading takes up to one and a half minute. I have never experience that with the old plugin version and I read some replies of people toying with huge amounts of data to test the plugin, and they were all able to get a much better load time out of it.

The hang appears to be random: this afternoon I could reproduce it ~10 times, but when I tried it an hour or so ago I couldn't after 5 attempts.

EDIT: The 230-sized table in the puush link is one we don't use, sorry for including it on the screenshot.

Re : [REL] MySQL Plugin (Now on github!) - iLegendary - 08.07.2014

i have errors:

Код:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z-R3, ©2005-2014 SA-MP Team

[18:37:34] filterscripts = ""  (string)
[18:37:34] 
[18:37:34] Server Plugins
[18:37:34] --------------
[18:37:34]  Loading plugin: streamer
[18:37:34] 

*** Streamer Plugin v2.7.2 by Incognito loaded ***

[18:37:34]   Loaded.
[18:37:34]  Loading plugin: Whirlpool
[18:37:34]  
[18:37:34]  ==================
[18:37:34]  
[18:37:34]   Whirlpool loaded
[18:37:34]  
[18:37:34]  ==================
[18:37:34]  
[18:37:34]   Loaded.
[18:37:34]  Loading plugin: sscanf
[18:37:34] 

[18:37:34]  ===============================

[18:37:34]       sscanf plugin loaded.     

[18:37:34]          Version:  2.8.1        

[18:37:34]    © 2012 Alex "******" Cole  

[18:37:34]  ===============================

[18:37:34]   Loaded.
[18:37:34]  Loading plugin: mysql
[18:37:34]   Failed.
[18:37:34]  Loading plugin: nativechecker
[18:37:34]   Loaded.
[18:37:34]  Loaded 4 plugins.

[18:37:34] 
[18:37:34] Filterscripts
[18:37:34] ---------------
[18:37:34]   Loaded 0 filterscripts.

[18:37:34]    Error: Function not registered: 'mysql_log'
[18:37:34]    Error: Function not registered: 'mysql_connect'
[18:37:34]    Error: Function not registered: 'mysql_errno'
[18:37:34]    Error: Function not registered: 'mysql_tquery'
[18:37:34]    Error: Function not registered: 'mysql_format'
[18:37:34]    Error: Function not registered: 'cache_get_field_content_int'
[18:37:34]    Error: Function not registered: 'cache_get_field_content_float'
[18:37:34]    Error: Function not registered: 'cache_get_data'
[18:37:34]    Error: Function not registered: 'cache_get_field_content'
[18:37:34]    Error: Function not registered: 'cache_get_row_count'
[18:37:34] Script[gamemodes/gamemode.amx]: Run time error 19: "File or function is not found"
[18:37:34] Number of vehicle models: 0

Re: Re : [REL] MySQL Plugin (Now on github!) - Konstantinos - 08.07.2014

Quote:

Originally Posted by iLegendary

i have errors:

Код:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z-R3, ©2005-2014 SA-MP Team

[18:37:34] filterscripts = ""  (string)
[18:37:34] 
[18:37:34] Server Plugins
[18:37:34] --------------
[18:37:34]  Loading plugin: streamer
[18:37:34] 

*** Streamer Plugin v2.7.2 by Incognito loaded ***

[18:37:34]   Loaded.
[18:37:34]  Loading plugin: Whirlpool
[18:37:34]  
[18:37:34]  ==================
[18:37:34]  
[18:37:34]   Whirlpool loaded
[18:37:34]  
[18:37:34]  ==================
[18:37:34]  
[18:37:34]   Loaded.
[18:37:34]  Loading plugin: sscanf
[18:37:34] 

[18:37:34]  ===============================

[18:37:34]       sscanf plugin loaded.     

[18:37:34]          Version:  2.8.1        

[18:37:34]    © 2012 Alex "******" Cole  

[18:37:34]  ===============================

[18:37:34]   Loaded.
[18:37:34]  Loading plugin: mysql
[18:37:34]   Failed.
[18:37:34]  Loading plugin: nativechecker
[18:37:34]   Loaded.
[18:37:34]  Loaded 4 plugins.

[18:37:34] 
[18:37:34] Filterscripts
[18:37:34] ---------------
[18:37:34]   Loaded 0 filterscripts.

[18:37:34]    Error: Function not registered: 'mysql_log'
[18:37:34]    Error: Function not registered: 'mysql_connect'
[18:37:34]    Error: Function not registered: 'mysql_errno'
[18:37:34]    Error: Function not registered: 'mysql_tquery'
[18:37:34]    Error: Function not registered: 'mysql_format'
[18:37:34]    Error: Function not registered: 'cache_get_field_content_int'
[18:37:34]    Error: Function not registered: 'cache_get_field_content_float'
[18:37:34]    Error: Function not registered: 'cache_get_data'
[18:37:34]    Error: Function not registered: 'cache_get_field_content'
[18:37:34]    Error: Function not registered: 'cache_get_row_count'
[18:37:34] Script[gamemodes/gamemode.amx]: Run time error 19: "File or function is not found"
[18:37:34] Number of vehicle models: 0

The plugin failed to load: http://forum.sa-mp.com/showpost.php?...postcount=4921

Re : Re: Re : [REL] MySQL Plugin (Now on github!) - iLegendary - 08.07.2014

Quote:

Originally Posted by Konstantinos

The plugin failed to load: http://forum.sa-mp.com/showpost.php?...postcount=4921

I've got already test, and doesn't work !

Respuesta: Re : [REL] MySQL Plugin (Now on github!) - The-Krew - 08.07.2014

Quote:

Originally Posted by iLegendary

i have errors:

Код:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z-R3, ©2005-2014 SA-MP Team

[18:37:34] filterscripts = ""  (string)
[18:37:34] 
[18:37:34] Server Plugins
[18:37:34] --------------
[18:37:34]  Loading plugin: streamer
[18:37:34] 

*** Streamer Plugin v2.7.2 by Incognito loaded ***

[18:37:34]   Loaded.
[18:37:34]  Loading plugin: Whirlpool
[18:37:34]  
[18:37:34]  ==================
[18:37:34]  
[18:37:34]   Whirlpool loaded
[18:37:34]  
[18:37:34]  ==================
[18:37:34]  
[18:37:34]   Loaded.
[18:37:34]  Loading plugin: sscanf
[18:37:34] 

[18:37:34]  ===============================

[18:37:34]       sscanf plugin loaded.     

[18:37:34]          Version:  2.8.1        

[18:37:34]    © 2012 Alex "******" Cole  

[18:37:34]  ===============================

[18:37:34]   Loaded.
[18:37:34]  Loading plugin: mysql
[18:37:34]   Failed.
[18:37:34]  Loading plugin: nativechecker
[18:37:34]   Loaded.
[18:37:34]  Loaded 4 plugins.

[18:37:34] 
[18:37:34] Filterscripts
[18:37:34] ---------------
[18:37:34]   Loaded 0 filterscripts.

[18:37:34]    Error: Function not registered: 'mysql_log'
[18:37:34]    Error: Function not registered: 'mysql_connect'
[18:37:34]    Error: Function not registered: 'mysql_errno'
[18:37:34]    Error: Function not registered: 'mysql_tquery'
[18:37:34]    Error: Function not registered: 'mysql_format'
[18:37:34]    Error: Function not registered: 'cache_get_field_content_int'
[18:37:34]    Error: Function not registered: 'cache_get_field_content_float'
[18:37:34]    Error: Function not registered: 'cache_get_data'
[18:37:34]    Error: Function not registered: 'cache_get_field_content'
[18:37:34]    Error: Function not registered: 'cache_get_row_count'
[18:37:34] Script[gamemodes/gamemode.amx]: Run time error 19: "File or function is not found"
[18:37:34] Number of vehicle models: 0

same error

Re : [REL] MySQL Plugin (Now on github!) - iLegendary - 09.07.2014

Many people have this error and no solution given by the FAQ works..

Re: [REL] MySQL Plugin (Now on github!) - [Mr]Wallace - 09.07.2014

I have the same problem but my plugin (mysql.dll) is loaded .

i have the last a_mysql (R39-2) include and mysql R7 plugin

Quote:

[13:21:08] Server Plugins
[13:21:08] --------------
[13:21:08] Loading plugin: mysql.dll
[13:21:08]

> MySQL plugin R7 successfully loaded.

[13:21:08] Loaded.
[13:21:08] Loading plugin: nativechecker
[13:21:08] Loaded.
[13:21:08] Loaded 2 plugins.

[13:21:08]
[13:21:08] Filterscripts
[13:21:08] ---------------
[13:21:08] Loaded 0 filterscripts.

[13:21:08] Error: Function not registered: 'mysql_tquery'
[13:21:08] Error: Function not registered: 'cache_insert_id'
[13:21:08] Error: Function not registered: 'cache_get_row_int'
[13:21:08] Error: Function not registered: 'cache_affected_rows'
[13:21:08] Error: Function not registered: 'cache_get_row_float'
[13:21:08] Error: Function not registered: 'cache_get_field_content_int'
[13:21:08] Error: Function not registered: 'mysql_log'
[13:21:08] Script[gamemodes/wallace.amx]: Run time error 19: "File or function is not found"
[13:21:08] Number of vehicle models: 0
[13:21:21] --- Server Shutting Down.
[13:21:21]

Re: [REL] MySQL Plugin (Now on github!) - Patrick - 09.07.2014

r39 inlude, r7 plugin, how the hell is that going to work?

go Github and check the latest release.

https://github.com/pBlueG/SA-MP-MySQL/releases

Re : [REL] MySQL Plugin (Now on github!) - S4t3K - 09.07.2014

@Patrick_ : This is not an acceptable solution.

I mean, if he hadn't have the good include version, this would be a compiler error message, and thus not a run time error message.

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

Quote:

Originally Posted by S4t3K

@Patrick_ : This is not an acceptable solution.

I mean, if he hadn't have the good include version, this would be a compiler error message, and thus not a run time error message.

wat?

Quote:

Originally Posted by [Mr]Wallace

I have the same problem but my plugin (mysql.dll) is loaded .

i have the last a_mysql (R39-2) include and mysql R7 plugin

Don't you see your mistake there?

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

Quote:

Originally Posted by iLegendary

Many people have this error and no solution given by the FAQ works..

Many people (in our case exactly 2) also underestimate the solution with redistributables and don't install them or just place some .dll's randomly downloaded from some shady dll-sites and place them somewhere to make things work.
So if you really correctly installed those 3 x86 (32 bit) redistributables and it still don't works, make sure that

your Windows is up2date
you are using the correct libmysql.dll
you never "installed" (placed manually) some .dll's you downloaded from the internet

Which version of Windows are you using btw?

Quote:

Originally Posted by S4t3K

@Patrick_ : This is not an acceptable solution.

I mean, if he hadn't have the good include version, this would be a compiler error message, and thus not a run time error message.

This is the only solution. Do you really think you can't compile a script with a higher-version include and run that script with a lower-version plugin? Well of course you can do that, just like MrWallace.

Re : [REL] MySQL Plugin (Now on github!) - iLegendary - 09.07.2014

Window 7 Family Prenium SP1 (x64)

Re: [REL] MySQL Plugin (Now on github!) - Pupak - 09.07.2014

Suggestion for future version:

pawn Код:

native mysql_query_file(connectionHandle, file[], callback[] = "", format[] = "", {Float,_}:...);
native mysql_tquery_file(connectionHandle, file[], callback[] = "", format[] = "", {Float,_}:...);
native mysql_pquery_file(connectionHandle, file[], callback[] = "", format[] = "", {Float,_}:...);

That functions would read queries from the file and then fire it. It's scriptable of course, but currently I have to buffer every statement (query) in the file and then fire it one by one. Plus, you can dynamically allocate and release the memory where the query is stored in the plugin. I'm currently using it to set up the database if tables aren't created already.

It's nothing important, but if you run out of ideas, why not?

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

Quote:

Originally Posted by iLegendary

Window 7 Family Prenium SP1 (x64)

And you are sure you followed all points I mentioned? I honestly can't see any other reason apart from wrong dll-management and missing redistributables. You could also try starting the server in compatibility mode with administrator rights.

Quote:

Originally Posted by Pupak

Suggestion for future version:

pawn Код:

native mysql_query_file(connectionHandle, file[], callback[] = "", format[] = "", {Float,_}:...);
native mysql_tquery_file(connectionHandle, file[], callback[] = "", format[] = "", {Float,_}:...);
native mysql_pquery_file(connectionHandle, file[], callback[] = "", format[] = "", {Float,_}:...);

I'll think about it, but it's a nice idea (so it's likely that I will implement this in R40).

Re : [REL] MySQL Plugin (Now on github!) - iLegendary - 09.07.2014

Ok, i fixed problem : i reinstall my window 7, i fixed mscvp100 and other, and i reinstall one per one redistributables

Re: AW: Re: [REL] MySQL Plugin (Now on github!) - Danny - 09.07.2014

I'm sorry for 'bumping' my question, but can anybody help me out with this? I'm kinda on a schedule.

Quote:

Originally Posted by Danny

Quote:

Originally Posted by Danny

In the meantime I've been able again to reproduce the hang-issues. With some optimisations (replacing cache_get_row by cache_get_row_int/float in some places) I succeeded in reducing the hang time from > 100 to 81 seconds. But the issue hasn't been solved yet: I never had issues like this with the old plugin.