… to understand which of the applications were responsible for memory allocation. If you figured out … can query temporary tables too: mysql> select sum(data_length+index_length) from information_schema.global_…16384 INDEX_LENGTH: 0 CREATE_TIME: NULL UPDATE_TIME: NULL 3 rows in set (0.00 sec) Innodb …
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
…#635399. (Yasufumi Kinoshita) Old variable use_global_long_query_time was deleted. (Oleg Tsarev) Bug…Yasufumi Kinoshita) Old variable enable_query_response_time_stats was renamed to query_response_time_stats. (Oleg Tsarev)…. (Yasufumi Kinoshita) The XtraDB version was set to 20.0. (Aleksandr Kuzminsky…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
…response_time_distribution and compile option –without-response_time_distribution in Response Time Distribution. (Oleg Tsarev) Bugs Fixed Bug #643149 – Slow query…, slow_query_log_microseconds_timestamp, use_global_long_query_time. (Oleg Tsarev…Tsarev) Bug #676158 – Setting the query cache size to…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…in terms of counters you can get from SHOW GLOBAL STATUS. I’ll start out by copying and …standpoint of response time measurements, which you should, you will eventually arrive at this question. “I have a query I …it as a heuristic for how big your working set is. Set the key_buffer_size to that. If …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… short queries, this can be a non-trivial part of the app’s response time. …, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+… don’t spend a lot of time on settings and status. It is not…
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
… MySQL was getting overloaded with thousands of same queries… which corresponded to cache miss storm but …so we did it on MySQL side instead. “SET GLOBAL max_connections=20″ to limit number of …some cases when cold performance gives too bad response time you may want to prime the caches by…
Post: Living with backups
November 6, 2008 By 28 Comments
…the regular database activities, which need fast response times, and doing backups which would gladly act… To check what is the current setting you need to query your block devices. In case…was_running= 1; } … my $sth= $dbh->prepare(‘SHOW GLOBAL STATUS LIKE “Threads_connected”‘); … if ($$row[1] < …
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…pool can be found here and for setting up LRU dump/restore here. Bug Fixes… in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables caused the… platform-specific distribution: The compilation of the Response Time Distribution patch has been fixed on Solaris (…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…responsible appropriately for insert buffer merges, asynchronous log flushes, read-ahead and flushing of dirty buffers. Normal reads originated from query…times, so sometimes you may see a bit conflicting information. This is by design as requiring global…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 28 Comments
…query to each table will immediately block against the requested global read lock, and subsequent read queries will block against the write query…time to flush. During that time…response…
