…how to recover a single tablespace using stock MySQL server. First, you must meet certain prerequisites to be able to…to avoid the server shutdown. You must not drop, truncate…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…ability to enable logging atomically, not just for new connections as in MySQL. This…26.23M rss, 62.49M vsz # Current date: Thu Dec 29 07:09:32 2011 … 0.0192 1.00 0.00 TRUNCATE TABLE poller_time # 14 0x3E84BF7C0C2A3005 0…. the “Query_time distribution” section shows how this query times mostly, which …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…how do you determine the memory consumption per connection in average? This leads to… ‘Com_purge’, ’0′ ‘Com_purge_before_date‘, ’0′ ‘Com_rename_table’, ’0′ ‘…stmt_send_long_data’, ’0′ ‘Com_truncate‘, ’0′ ‘Com_unlock_tables’, ’102′ ‘Com… # Lowered from 32M according to MySQL innodb_additional_mem_pool…
