…MySQL manual,…sizeblogpercona.commanual Prepared_stmt_…cache_hitsblogpercona.commanual Ssl_session_cache_missesblogpercona.commanual Ssl_session_cache_modeblogpercona.commanual Ssl_session_cache_overflowsblogpercona.commanual Ssl_session_cache_sizeblogpercona.commanual Ssl_session_cache…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… can also see Server prepared statements were disabled for the run (same as we had few years ago). Prepared statements generally should have helped… thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5.3 a statement…| | optimizing | 0.000002 | | statistics | 0.000005 | | preparing | 0.000006 | | executing | 0.000001 | | …cache lock | 0.000003 | | checking query cache for query | 0.000007 | | checking privileges on cached…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… saying about Prepared Statements in MySQL 4.1 which came without query cache support but even worse not all of statements could be prepared not to mention other issues. I’m saying about SubSelects which were added in MySQL 4.1… for very long time. For example Query Cache support for Prepared Statements is only fixed in MySQL 5.1 and Most of other items…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache you would like MySQL to… procedures may require a lot of memory Prepared statements and Cursors. Single connection may have many prepared statements and cursors. Their number finally can…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… call. And what about the query cache and the table cache and the size needed for … the query is done. And there are prepared statements, which you can create and never deallocate. Any… 100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) | …
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
… used by other global buffers such as query_cache_size and key_buffer and will in …Could it be some buffers associated with opened tables, prepared statements etc ? Could it be some of the queries…thread in addition to global memory allocation. As MySQL is progressing the problem of memory allocation …
Comment: MySQL Prepared Statements
September 3, 2008 By 21 Comments
… = 120749009859430; . . a million rows of updates . The prepare/execute file looked like: reset query cache; prepare upd from “update company set data_source… supposedly mysql had already done a hard parse on the command. But it ran significantly slower (about 25%) than the statement-at…
Comment: Handling big result sets
June 27, 2006 By 13 Comments
…. Now here is the kicker: Using the new mysqli and prepared statement based on the code you provided: Number of rows: 1000000… it was around 1.9 to 2.0 s. Does mysql cache these prepared statements perhaps? Either way the performance benefit is worthwhile 
Thank… lines more and has somewhat more complicated due to the statement preparing etc. This shows the shortest and easiest path sure isn…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… from the Percona Software Repositories). Based on MySQL 5.1.66, including all the bug…a crash would happened between XA PREPARE and COMMIT stages, the prepared InnoDB transaction would not have…for a binary log transaction cache, when committing or rolling back a statement or a transaction. Bug fixed…
