List:General Discussion« Previous MessageNext Message »
From:Adarsh Sharma Date:September 5 2012 6:26pm
Subject:Re: Understanding Slow Query Log
View as plain text  
true Michael, pasting the output :

CREATE TABLE `WF_1` (
  `id` varchar(255) NOT NULL,
  `app_name` varchar(255) DEFAULT NULL,
  `app_path` varchar(255) DEFAULT NULL,
  `conf` text,
  `group_name` varchar(255) DEFAULT NULL,
  `parent_id` varchar(255) DEFAULT NULL,
  `run` int(11) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `bean_type` varchar(31) DEFAULT NULL,
  `auth_token` text,
  `created_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `external_id` varchar(255) DEFAULT NULL,
  `last_modified_time` datetime DEFAULT NULL,
  `log_token` varchar(255) DEFAULT NULL,
  `proto_action_conf` text,
  `sla_xml` text,
  `start_time` datetime DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `wf_instance` mediumblob,
  PRIMARY KEY (`id`),
  KEY `I_WF_1_DTYPE` (`bean_type`),
  KEY `I_WF_1_END_TIME` (`end_time`),
  KEY `I_WF_1_EXTERNAL_ID` (`external_id`),
  KEY `I_WF_1_LAST_MODIFIED_TIME` (`last_modified_time`),
  KEY `I_WF_1_STATUS` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |


show indexes from WF_1;
+---------+------------+------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
| Table   | Non_unique | Key_name                     | Seq_in_index |
Column_name        | Collation | Cardinality | Sub_part | Packed | Null |
Index_type | Comment |
+---------+------------+------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
|WF_1 |          0 | PRIMARY                      |            1 | id
          | A         |      551664 |     NULL | NULL   |      | BTREE
 |         |
|WF_1 |          1 | I_WF_1_DTYPE              |            1 | bean_type
       | A         |          18 |     NULL | NULL   | YES  | BTREE      |
        |
|WF_1 |          1 | I_WF_1_END_TIME           |            1 | end_time
        | A         |      551664 |     NULL | NULL   | YES  | BTREE      |
        |
|WF_1 |          1 | I_WF_1_EXTERNAL_ID        |            1 | external_id
       | A         |      551664 |     NULL | NULL   | YES  | BTREE      |
        |
|WF_1 |          1 | I_WF_1_LAST_MODIFIED_TIME |            1 |
last_modified_time | A         |      551664 |     NULL | NULL   | YES  |
BTREE      |         |
|WF_1 |          1 | I_WF_1_STATUS             |            1 | status
        | A         |          18 |     NULL | NULL   | YES  | BTREE      |
        |
+---------+------------+------------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+


Thanks

On Wed, Sep 5, 2012 at 8:43 PM, Michael Dykman <mdykman@stripped> wrote:

> The attachments do not appear to be coming through.
>
> I am more curious what the cardinality of bean_type is.  What is the
> result of
> select count(*) as cnt, bean_type from WS_1 group by bean_type  ?
>
> Low cardinality can render an index usrless.
>
> On 2012-09-05 5:19 AM, "Adarsh Sharma" <eddy.adarsh@stripped> wrote:
>
> I already attached the list.
>
> Attaching one more time & thanks for the interest.
>
> Cheers
>
>
>
> On Wed, Sep 5, 2012 at 11:44 AM, Manuel Arostegui <manuel@stripped>
> wrote:
> >
> >
> >
> > 2012/9/5 Adar...
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

Thread
Understanding Slow Query LogAdarsh Sharma1 Sep
  • Re: Understanding Slow Query Logyoku ts1 Sep
  • Re: Understanding Slow Query LogSuresh Kuna1 Sep
    • RE: Understanding Slow Query LogRick James4 Sep
      • Re: Understanding Slow Query LogAdarsh Sharma5 Sep
        • Re: Understanding Slow Query LogManuel Arostegui5 Sep
          • Re: Understanding Slow Query LogAdarsh Sharma5 Sep
Re: Understanding Slow Query LogAdarsh Sharma5 Sep
  • RE: Understanding Slow Query LogRick James5 Sep
    • Re: Understanding Slow Query LogAndy Wallace5 Sep
      • RE: Understanding Slow Query LogRick James5 Sep
        • Re: Understanding Slow Query LogAndy Wallace5 Sep