How are MYSQL Prepared Statements Cached?

[screative]

If I have two users and they load the same page and the page has prepared statements in it is the prepared statement query parsed and cached from the first user who loaded the page used for the second user's page load to speed up their query results?

Is the parsed query cache stateless across all connections and is once it is parsed and cached is that cached used for all users who use the site? Or is it state full and can only be reused in the same connection?

[johanafm]

This is how it works[url] if you are using the query cache.

To get any definitive performance results, you'd have to benchmark with and without prepared statements, and with or without the query cache. Prepared statements do not necessarily give a performance gain, but I don't know if they can incur a performance hit. As for the query cache, I know for a fact that it may reduce performance under some conditions. We actually turned it off for some of the databases in use and got a decent performance boost.