…buffers and so if you close connection MySQL can clean them up. Killing connections (or stopping related applications) and observing whenever memory…to look at Prepared_stmt_count to see how many prepared statements are allocated on server and Com_stmt_send_long_data to see whenever sending long data…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…to MySQL Server, all MySQL Security guarantees is you can stop one from seeing data you do not want one to see (or change data…send data for each of them using mysql_stmt_send_long_data call – Server buffers such data…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
… have the atomic data, not just the aggregated data that I showed how to maintain cheaply in the …MySQL servers I work with when they’re running a simple read-mostly workload with most data…would normally be sending queries to the server would be stopped, waiting for existing queries to complete. That…
Post: Living with backups
November 6, 2008 By 28 Comments
…operation from MySQL data directory will result in a total disaster after MySQL stops responding to …utility called ionice. It allows to affect how I/O scheduler will be …sends STOP signal to the archiving process. Whenever the number of connected threads drops down back to 9 or less, the script sends…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql…to send…to stop the replication for some time and when see how long it takes to…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…how do you determine the memory consumption per connection in average? This leads to…stop‘, ’0′ ‘Com_stmt_close’, ’304204263′ ‘Com_stmt_execute’, ’304205150′ ‘Com_stmt_prepare’, ’410680831′ ‘Com_stmt_reset’, ’0′ ‘Com_stmt_send_long_data… # Lowered from 32M according to MySQL innodb_additional_mem_pool…
