Re: Monitor a Query then retrieve data using process ID
> several joins, which I know mysql doesn't really like
Untrue. Joins are fine. You just need to optimise them.
> monitoring the query and getting the results when the query is done
Show Full Processlist shows the state of current query processes.
The PHP mysqli API has a MYSQLI_ASYNC switch and mysqli_poll() func for asynchronous querying.
> result set in cache
Turn on query_cache_type and query_cache_size.
Subject
Written By
Posted
Re: Monitor a Query then retrieve data using process ID
June 24, 2016 09:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.