--source include/have_innodb.inc

DROP TABLE IF EXISTS wp_blogs;

CREATE TABLE wp_blogs (

  blog_id bigint(20) NOT NULL auto_increment,

  site_id bigint(20) NOT NULL default '0',

  domain varchar(200) NOT NULL default '',

  path varchar(100) NOT NULL default '',

  registered datetime NOT NULL default '0000-00-00 00:00:00',

  last_updated datetime NOT NULL default '0000-00-00 00:00:00',

  public tinyint(2) NOT NULL default '1',

  archived tinyint(2) NOT NULL default '0',

  mature tinyint(2) NOT NULL default '0',

  spam tinyint(2) NOT NULL default '0',

  deleted tinyint(2) NOT NULL default '0',

  lang_id int(11) NOT NULL default '0',

  PRIMARY KEY  (blog_id),

  KEY domain (domain(50),path(5)),

  KEY lang_id (lang_id)

) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

insert into wp_blogs (domain, path) values ('domain.no', '/fondsinvesteringer/');

insert into wp_blogs (domain, path) values ('domain.no', '/');

insert into wp_blogs (domain, path) values ('foo', 'bar');

insert into wp_blogs (domain, path) values ('bar', 'foo');

insert into wp_blogs (domain, path) values ('foo', 'foo');

insert into wp_blogs (domain, path) values ('bar', 'bar');

insert into wp_blogs (domain, path) values ('foo', 'foobar');

insert into wp_blogs (domain, path) values ('bar', 'foobar');

insert into wp_blogs (domain, path) values ('foobar', 'foobar');

set global innodb_prefix_index_cluster_optimization=off;

SELECT blog_id FROM wp_blogs WHERE domain IN ('domain.no') AND path IN ( '/fondsinvesteringer/', '/' );

set global innodb_prefix_index_cluster_optimization=on;

SELECT blog_id FROM wp_blogs WHERE domain IN ('domain.no') AND path IN ( '/fondsinvesteringer/', '/' );

DROP TABLE wp_blogs;

SET GLOBAL innodb_prefix_index_cluster_optimization=DEFAULT;

set global innodb_prefix_index_cluster_optimization=off;

SELECT blog_id FROM wp_blogs WHERE domain IN ('domain.no') AND path IN ( '/fondsinvesteringer/', '/' );

blog_id

2

1

set global innodb_prefix_index_cluster_optimization=on;

SELECT blog_id FROM wp_blogs WHERE domain IN ('domain.no') AND path IN ( '/fondsinvesteringer/', '/' );

blog_id

2