- 浏览: 88622 次
- 性别:
- 来自: 北京
文章分类
最新评论
-
xiaoyi829:
应该可以grzrt 写道分区表partition,能用hand ...
初识mysql插件之HandlerSocket -
grzrt:
分区表partition,能用handlersocket查询指 ...
初识mysql插件之HandlerSocket
select company_albums.id,company.name as company_name,company.url as company_url,company_albums.name as company_albums_name,company_albums.url as company_albums_url,view_count,thumbnail_path,qq ,brand_shop_id
from company,company_albums
where company_albums.com_id=company.id
ORDER BY `view_count` desc
LIMIT 69600, 15 ;
explain select company_albums.id,company.name as company_name,company.url as company_url,company_albums.name as company_albums_name,company_albums.url as company_albums_url,view_count,thumbnail_path,qq ,brand_shop_id
from company,company_albums
where company.id=company_albums.com_id
ORDER BY `view_count` desc
LIMIT 69600, 15 \G;
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: company_albums
type: ALL
possible_keys: com_idx
key: NULL
key_len: NULL
ref: NULL
rows: 72441
Extra: Using filesort
*************************** 2. row ***************************
id: 1
select_type: SIMPLE
table: company
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: test_01.company_albums.com_id
rows: 1
Extra:
2 rows in set (0.00 sec)
----------------------------------------
select company_albums.id,company_albums.name as company_albums_name,company_albums.url as company_albums_url,view_count,thumbnail_path,company.name as company_name,company.url as company_url,qq ,brand_shop_id
from company_albums ,(select company_albums.id as ca_id
from company,company_albums
where company_albums.com_id=company.id
ORDER BY `view_count` desc
LIMIT 69600, 15) as t,company
where company.id=company_albums.com_id and t.ca_id = company_albums.id
order by view_count desc;
explain select company_albums.id,company_albums.name as company_albums_name,company_albums.url as company_albums_url,view_count,thumbnail_path,company.name as company_name,company.url as company_url,qq ,brand_shop_id
from company_albums ,(select company_albums.id as ca_id
from company,company_albums
where company_albums.com_id=company.id
ORDER BY `view_count` desc
LIMIT 69600, 15) as t,company
where company.id=company_albums.com_id and t.ca_id = company_albums.id
order by view_count desc\G;
*************************** 1. row ***************************
id: 1
select_type: PRIMARY
table: <derived2>
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
ref: NULL
rows: 18
Extra: Using temporary; Using filesort
*************************** 2. row ***************************
id: 1
select_type: PRIMARY
table: company_albums
type: eq_ref
possible_keys: PRIMARY,com_idx
key: PRIMARY
key_len: 4
ref: t.ca_id
rows: 1
Extra:
*************************** 3. row ***************************
id: 1
select_type: PRIMARY
table: company
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: test_01.company_albums.com_id
rows: 1
Extra:
*************************** 4. row ***************************
id: 2
select_type: DERIVED
table: company_albums
type: ALL
possible_keys: com_idx
key: NULL
key_len: NULL
ref: NULL
rows: 72441
Extra: Using filesort
*************************** 5. row ***************************
id: 2
select_type: DERIVED
table: company
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: test_01.company_albums.com_id
rows: 1
Extra: Using index
5 rows in set (0.34 sec)
from company,company_albums
where company_albums.com_id=company.id
ORDER BY `view_count` desc
LIMIT 69600, 15 ;
explain select company_albums.id,company.name as company_name,company.url as company_url,company_albums.name as company_albums_name,company_albums.url as company_albums_url,view_count,thumbnail_path,qq ,brand_shop_id
from company,company_albums
where company.id=company_albums.com_id
ORDER BY `view_count` desc
LIMIT 69600, 15 \G;
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: company_albums
type: ALL
possible_keys: com_idx
key: NULL
key_len: NULL
ref: NULL
rows: 72441
Extra: Using filesort
*************************** 2. row ***************************
id: 1
select_type: SIMPLE
table: company
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: test_01.company_albums.com_id
rows: 1
Extra:
2 rows in set (0.00 sec)
----------------------------------------
select company_albums.id,company_albums.name as company_albums_name,company_albums.url as company_albums_url,view_count,thumbnail_path,company.name as company_name,company.url as company_url,qq ,brand_shop_id
from company_albums ,(select company_albums.id as ca_id
from company,company_albums
where company_albums.com_id=company.id
ORDER BY `view_count` desc
LIMIT 69600, 15) as t,company
where company.id=company_albums.com_id and t.ca_id = company_albums.id
order by view_count desc;
explain select company_albums.id,company_albums.name as company_albums_name,company_albums.url as company_albums_url,view_count,thumbnail_path,company.name as company_name,company.url as company_url,qq ,brand_shop_id
from company_albums ,(select company_albums.id as ca_id
from company,company_albums
where company_albums.com_id=company.id
ORDER BY `view_count` desc
LIMIT 69600, 15) as t,company
where company.id=company_albums.com_id and t.ca_id = company_albums.id
order by view_count desc\G;
*************************** 1. row ***************************
id: 1
select_type: PRIMARY
table: <derived2>
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
ref: NULL
rows: 18
Extra: Using temporary; Using filesort
*************************** 2. row ***************************
id: 1
select_type: PRIMARY
table: company_albums
type: eq_ref
possible_keys: PRIMARY,com_idx
key: PRIMARY
key_len: 4
ref: t.ca_id
rows: 1
Extra:
*************************** 3. row ***************************
id: 1
select_type: PRIMARY
table: company
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: test_01.company_albums.com_id
rows: 1
Extra:
*************************** 4. row ***************************
id: 2
select_type: DERIVED
table: company_albums
type: ALL
possible_keys: com_idx
key: NULL
key_len: NULL
ref: NULL
rows: 72441
Extra: Using filesort
*************************** 5. row ***************************
id: 2
select_type: DERIVED
table: company
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: test_01.company_albums.com_id
rows: 1
Extra: Using index
5 rows in set (0.34 sec)
发表评论
-
mysql dump 备份及脚本!
2011-06-10 13:38 1518导出多张表的时候表之间用空格分开: # mysqldump ... -
mysql备份脚本
2011-06-03 17:32 659!/bin/sh # mysql_backup.sh: bac ... -
CentOS挂载移动硬盘
2011-06-03 15:12 10431, 首先确认fuse,CentOS 5.5 带有fuse,可 ... -
MySQL 左连接 右连接
2011-06-03 14:03 798表A记录如下: aID aNum 1 ... -
[转]CentOS5 下安装与配置飞鸽传书(Ipmsg)完美完结篇
2011-05-27 10:29 1524CentOS5 下安装与配置飞鸽传书(Ipmsg)完美完结篇 ... -
深入SQL语句性能调整
2011-05-17 13:20 804本文sqlserver为例 有 ... -
windows和linux下开启mysql日志
2011-05-11 10:24 2238mysql有以下几种日志: 错误日志: -log-err 查询 ... -
MYSQL数据库设计的一点总结
2011-04-13 14:48 672选表类型: 大家都知道 ... -
mysql 清理碎片
2011-04-13 09:59 830显示你数据库中存在碎片的全部列表: select tab ... -
MySQL 建表语法
2011-04-12 14:21 7261、最简单的: CREATE TABLE t1( id ... -
MySQL性能优化
2011-04-02 10:53 697作者:andyao 原文link: http://andyao ... -
Mysql Innodb 引擎优化-参数
2011-03-30 16:49 732介绍: InnoDB给MySQL提供了具有提交,回滚和崩溃 ... -
MySQL前端和后台的系统优化
2011-03-30 16:39 766本文中介绍的系统优化 ... -
MySQL配置文件my.cnf 做笔记用
2011-03-30 16:33 736MySQL配置文件my.cnf 例子最详细翻译,可以保存做笔记 ... -
测试脚本mysql_插入100万行数据
2011-03-29 16:31 1312CREATE DEFINER=`root`@`localhos ... -
Mysql日期和时间函数
2011-03-29 15:50 638这里是一个使用日期函 ... -
MySQL数据库优化的具体方法说明
2011-03-29 15:39 722以下的文章主要讲述的是实现MySQL数据库简单实用优化的具体方 ... -
MySQL之Explain
2011-03-29 15:16 598前记:很多东西看似简 ... -
MySQL维护命令集锦--查看表的状态(show table status)
2011-03-29 15:11 1155查看表的引擎类型等状态信息: show table statu ... -
mysql show status参数详解
2011-03-29 15:03 869Aborted_clients 由于客户没有正确 ...
相关推荐
最快的排序算法 C语言最简单的排序算法冒泡排序并返回排序前索引序号,排序算法数据结构
详细讲述了在SQLITE中使用时间字段作索引进行SQL插入及查询操作的方法
NULL 博文链接:https://hackpro.iteye.com/blog/1845366
系统跑久了,对于所有的索引想做一个具体的确认,所以写了这么一段, 可以用来分析自己数据的表及索引详情 针对记录数比较大的表,尤其要注意索引的情况,非常影响性能
当需要频繁对某一字段的值进行查询、定位或者使用该字段做关联专题图时,为了提高数据查询或地图显示效率,往往需要对该字段创建索引。本范例将示范如何对非系统字段创建字段索引和删除字段已有索引。
如果需要频繁使用某一字段的值进行定位、查询等操作,若为此类字段建立索引,这样可以很大程度地提高程序运行的效率。本范例演示如何获取可创建索引的字段名称、为字段创建索引、删除字段索引。
MySQL SQL高级特性 字段约束-索引-视图-外键学习实践,很不错
排序索引flash课件源文件,适合演示使用!
介绍了数据结构的一个重要的算法 索引排序
oracle 全文检索 oracle全文索引 多列字段检索,匹配多列字段搜索功能。
怎么给字符串字段加索引?
json_decode 索引为数字时自动排序问题解决方法.docx
MySQL通常使用GROUPBY(本质上是排序动作)完成DISTINCT操作,如果DISTINCT操作和ORDERBY操作组合使用,通常会用到临时表.这样会影响性能. 在一些情况下,MySQL可以使用索引优化DISTINCT操作,但需要活学活用.本文涉及一个...
主要介绍了MySQL常用的建表、添加字段、修改字段、添加索引SQL语句写法,总结分析了MySQL建表、编码设置、字段添加、索引操作所涉及的SQL语句,需要的朋友可以参考下
MySQL高级特性字段约束-索引-视图-外键学习实践PDF文档;
NULL 博文链接:https://opq149766320.iteye.com/blog/561173
11怎么给字符串字段加索引?.pptx
简单的listview实现自定义的A-Z索引定位
了表,或少了字段,或字段类型长度不一样,或索引 不一样, 或存储过程,视图,触发器,默认值等不一样,就产生 相应的S QL语句! 二.操作方法: 先把源数据库的连接属性(数据库名,服务器名, 用户名, 密码)填好,按读源数据,...
当where子句对某一列使用函数时,除非利用这个简单的技术强制索引,否则Oracle优化器不能在查询中使用索引。 通常情况下,如果在WHERE子句中不使用诸如UPPER、REPLACE 或SUBSTRD等函数,就不能对指定列建立特定的...