… 1.0, and it cannot be worked around in pt-table-checksum 2.0 because the bug in in DBD::mysql. This bug affects pt-table-checksum 2.0 but not 1.0 because the newer version uses prepared statements with… have not verified this, that DBD::mysql 4.014 has some sort of caching mechanism which causes it to use the wrong prepared statement.
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
… terms of memory allocation target, which could be something like “Prepared Statement Cache“, “Table Cache” etc. For global pools we need just global accounting… the planning and feature design is long started for MySQL 5.7 (or whatever next release is going to be called) and I…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
If you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not… prepared statements – I would like to be able to simply able to pass data array and let library to take care about emulating. Cached Prepared Statements It would be great if library could cache them so you…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and….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
… marketing then fair technical comparison and we, technical people, just can …prepared statements were disabled for the run (same as we had few years ago). Prepared statements…cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…front in one call. And what about the query cache and the table cache and the size needed for…, and keeps it around until the query is done. And there are prepared statements, which you can create and…And keys for user locks! I set my max_allowed_packet bigger and ran the following on my laptop: mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql…and write something instructional to the client about it. Preparing… alerting, backups, caching, reverse proxies, and high availability…statements and analyze them individually. The goal is always to develop X-Ray Vision and…
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
…I would log in to customers system and find MySQL using too much memory. I would look at … by other global buffers such as query_cache_size and key_buffer and will in many cases see some… Could it be some buffers associated with opened tables, prepared statements etc ? Could it be some of the queries …
Comment: Handling big result sets
June 27, 2006 By 13 Comments
… run. 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… a few 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
… are available here and from the Percona Software Repositories). Based on MySQL 5.1.66, …XA PREPARE and COMMIT stages, the prepared InnoDB transaction would not have the slave position recorded and … a binary log transaction cache, when committing or rolling back a statement or a transaction. Bug …
