Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 2

Displaying posts with tag: tmp_table_size (reset)

Profiling your slow queries using pt-query-digest and some love from Percona Server
+2 Vote Up -0Vote Down
posted by Ovais Tariq on Wed 28 Dec 2011 12:23 UTC
Tags:
(edit) mysql, innodb, performance, optimization, query plan, profiling, temporary tables, queries, slow query, query analysis, long_query_time, query execution, mk-query-digest, general query log, tmp_table_size, percona server, Percona Toolkit, 95th percentile, log_slow_verbosity, microslow patch, microtime, pt-query-digest, slow logging
This guide will get you up and running with how to identify the bottleneck queries using the excellent tool pt-query-digest. You will learn how to use and analyze the output returned by pt-query-digest. You will also learn some differences between slow query logging in various MySQL versions. Later on in the post I will also show you how to make use of the extra diagnostic data available with Percona Server.
Why a new memory engine may change everything ?
+1 Vote Up -1Vote Down
posted by Cedric PEINTRE on Mon 26 Sep 2011 16:00 UTC
Tags:
(edit) engine, blob, Percona, temporary table, admin, mariadb, text, max_heap_table_size, tmp_table_size, dynamic row format, memory engine

I’m sure you are aware that the last Percona server release includes a new improved MEMORY storage engine for MySQL.
This new engine is based on Dynamic Row Format and offers some of great features, specialy for VARCHAR, VARBINARY, TEXT and BLOB fields in MEMORY tables.

But because this new MEMORY engine by Percona has some limitations and because Percona server hasn’t used it for its internal temporary tables yet, I would like to talk about what can be the real benefits to have a brand new MEMORY engine based on Dynamic row format specialy for internal memory


  [Read more...]
Showing entries 1 to 2

Planet MySQL © 1995, 2013, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.