maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

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@xxxxxxxx>
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@xxxxxxxxx> ha scritto:
>
>  Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP
>  A: "AskMonty KB" <noreply@xxxxxxxxxxxx>
>  Cc: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
>  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@xxxxxxxxxxxx>
>  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@xxxxxxxxxxxxxxxxxxx
>
>  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@xxxxxxxxxxxxxxxxxxx
>  Unsubscribe : https://launchpad.net/~maria-discuss
>  More help   : https://help.launchpad.net/ListHelp
>