Re: [Maria-discuss] New Question: Non-blocking calls from PHP
Hi Justin! The name reminds me a a fatal trap for developers and sys admins (async npm module), but the tools sounds useful. Is it publicly available? Is it entirely implemented via stored procedures + event scheduler? bye Federico -------------------------------------------- Mer 24/2/16, Justin Swanhart <greenlion@gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP A: "AskMonty KB" <noreply@askmonty.org> Cc: "Maria Discuss" <maria-discuss@lists.launchpad.net> Data: Mercoledì 24 febbraio 2016, 15:32 Replying here in addition to the web page (ugh Frankenstein's monster)... I just finished the first version of 'async' which runs queries in the background (in parallel!) using a queue table, a crafty stored procedure for a worker thread, and an event which executes the workers. http://swanhart.livejournal.com/138754.html On Sun, Feb 21, 2016 at 8:55 AM, AskMonty KB <noreply@askmonty.org> wrote: Hello, A new question has been asked in " MariaDB Connector/C API Functions" by shestero. Please answer it at http://mariadb.com/kb/en/non-blocking-calls-from-php/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I want to use non-blocking API ( https://mariadb.com/kb/en/mariadb/non-blocking-api-reference ) from PHP. Is it possible now? If no, can anybody give me directions how to implement my own PHP-extension in C (using Connector/C) or update the existing module? I don't think it's very complex, do I need to add just wraper-like implementations using blocking function as samples, don't I? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/non-blocking-calls-from-php/ _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp -----Segue allegato----- _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hi, It is completely native. It consists of a queue table, a thread state table, a settings table, a stored procedure worker, an event to execute the worker (more than one run in parallel) and procs to drop off, check on, and get the results of a SQL statement (which always waits if the SQL is not done yet). I don't know if MariaDB 5.5 or 10 adds GET DIAGNOSTICS, but it will work with any version that has it. You can comment that out and just put a generic error into the table if it isn't supported, and it will work with any version that has SIGNAL. --Justin On Wed, Feb 24, 2016 at 10:01 AM, Federico Razzoli <federico_raz@yahoo.it> wrote:
Hi Justin! The name reminds me a a fatal trap for developers and sys admins (async npm module), but the tools sounds useful. Is it publicly available? Is it entirely implemented via stored procedures + event scheduler?
bye Federico
-------------------------------------------- Mer 24/2/16, Justin Swanhart <greenlion@gmail.com> ha scritto:
Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP A: "AskMonty KB" <noreply@askmonty.org> Cc: "Maria Discuss" <maria-discuss@lists.launchpad.net> Data: Mercoledì 24 febbraio 2016, 15:32
Replying here in addition to the web page (ugh Frankenstein's monster)...
I just finished the first version of 'async' which runs queries in the background (in parallel!) using a queue table, a crafty stored procedure for a worker thread, and an event which executes the workers. http://swanhart.livejournal.com/138754.html
On Sun, Feb 21, 2016 at 8:55 AM, AskMonty KB <noreply@askmonty.org> wrote: Hello,
A new question has been asked in " MariaDB Connector/C API Functions" by shestero. Please answer it at http://mariadb.com/kb/en/non-blocking-calls-from-php/ as the person asking the question may not be subscribed to the mailing list.
--------------------------------
I want to use non-blocking API ( https://mariadb.com/kb/en/mariadb/non-blocking-api-reference ) from PHP.
Is it possible now?
If no, can anybody give me directions how to implement my own PHP-extension in C (using Connector/C) or update the existing module? I don't think it's very complex, do I need to add just wraper-like implementations using blocking function as samples, don't I?
--------------------------------
To view or answer this question please visit: http://mariadb.com/kb/en/non-blocking-calls-from-php/
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
-----Segue allegato-----
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
oh, it is in the Swanhart Toolkit in the async/ subdir - http://github.com/greenlion/swanhart-tools On Wed, Feb 24, 2016 at 10:04 AM, Justin Swanhart <greenlion@gmail.com> wrote:
Hi,
It is completely native. It consists of a queue table, a thread state table, a settings table, a stored procedure worker, an event to execute the worker (more than one run in parallel) and procs to drop off, check on, and get the results of a SQL statement (which always waits if the SQL is not done yet).
I don't know if MariaDB 5.5 or 10 adds GET DIAGNOSTICS, but it will work with any version that has it. You can comment that out and just put a generic error into the table if it isn't supported, and it will work with any version that has SIGNAL.
--Justin
On Wed, Feb 24, 2016 at 10:01 AM, Federico Razzoli <federico_raz@yahoo.it> wrote:
Hi Justin! The name reminds me a a fatal trap for developers and sys admins (async npm module), but the tools sounds useful. Is it publicly available? Is it entirely implemented via stored procedures + event scheduler?
bye Federico
-------------------------------------------- Mer 24/2/16, Justin Swanhart <greenlion@gmail.com> ha scritto:
Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP A: "AskMonty KB" <noreply@askmonty.org> Cc: "Maria Discuss" <maria-discuss@lists.launchpad.net> Data: Mercoledì 24 febbraio 2016, 15:32
Replying here in addition to the web page (ugh Frankenstein's monster)...
I just finished the first version of 'async' which runs queries in the background (in parallel!) using a queue table, a crafty stored procedure for a worker thread, and an event which executes the workers. http://swanhart.livejournal.com/138754.html
On Sun, Feb 21, 2016 at 8:55 AM, AskMonty KB <noreply@askmonty.org> wrote: Hello,
A new question has been asked in " MariaDB Connector/C API Functions" by shestero. Please answer it at http://mariadb.com/kb/en/non-blocking-calls-from-php/ as the person asking the question may not be subscribed to the mailing list.
--------------------------------
I want to use non-blocking API ( https://mariadb.com/kb/en/mariadb/non-blocking-api-reference ) from PHP.
Is it possible now?
If no, can anybody give me directions how to implement my own PHP-extension in C (using Connector/C) or update the existing module? I don't think it's very complex, do I need to add just wraper-like implementations using blocking function as samples, don't I?
--------------------------------
To view or answer this question please visit: http://mariadb.com/kb/en/non-blocking-calls-from-php/
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
-----Segue allegato-----
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (2)
-
Federico Razzoli -
Justin Swanhart