…to implicit extension to CHAR. The lack of these features in the MEMORY storage engine (also known as HEAP) in MySQL…how to request it explicitly and how to set the data…6267700 kB Two client threads… comparable due to…fields agains the fixed row format. For that we modify the default sysbench schema to…
Post: Intro to OLAP
July 12, 2010 By 10 Comments
…to automate that aggregation process. Comparing the performance of OLAP with and without aggregation over multiple MySQL storage engines at various data…two different order statuses. Such a dimension would add an extra join, which is expensive. Any yes/no field and/or fields…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…data from 1988 to 2010′; mysql> use ontime1; Database changed mysql…data, so ICE gets over 16:1 compression ratio(compared to Innodb, 8:1 compared to raw input data…to show (click show/hide to change the columns) That the “public dns” field is selected SSH to…two nodes. You should start two…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…MySQL does have its limitations, it reports only a subset of stats, however if you compare that to…0.00 SELECT data_template_rrd data_input_fields # 16 0xBE797E1DD5E4222F…_time distribution” section shows how this query times …two important things that you would probably like to fix with respect to…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…How to determine which MySQL High-Availability solution is best? What is really tricky with MySQL…two types of setup. The first one is a basic proof of concept of the technology with the hardware tested, the data…to compare…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… problem itself. No matter how much you want it to fit, some things may …this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions like Tokyo Tyrant …field ( called email address ). Seems simple enough right? My two tables each contain 5M rows of data….
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… STATUS output and how to use this info to improve MySQL Performance. To start with …3463, OS waits 3163 There are two portions in this section. One…”. Spin locks are low cost wait, compared to OS wait, it is however…CASCADE Trying to add in child table, in index `par_ind` tuple: DATA TUPLE: 2 fields; …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… We could not compare a search key K to an index …to experiment with. Q17: How InnoBD handles blobs/text fields (needs more info) According to…can decide (incorrectly) to swap out MySQL. There are two solutions here. Memlock…. INNODB uses fuzzy checkpointing to commit data to disk. The problem …
Comment: How to find wrong indexing with glance view
August 23, 2008 By 27 Comments
…like all fields are linked one-to-one to users …mysql can use index to filter records before fetching any rows. How… with quite good selectivity comparing with other enumns. Age…Gender, Age, Available). So mysql can choose between two which is more …data. Each index will be between 5GB and size of data …
