SQL语句
mysql> CREATE TABLE ts (id INT, purchased DATE) engine=myisam
-> PARTITION BY RANGE(YEAR(purchased))
-> SUBPARTITION BY HASH(TO_DAYS(purchased))
-> (
-> PARTITION p0 VALUES LESS THAN (1990)
-> (
-> SUBPARTITION s0a
-> DATA DIRECTORY = '/home/bzuo/d1'
-> INDEX DIRECTORY = '/home/bzuo/d1',
-> SUBPARTITION s0b
-> DATA DIRECTORY = '/home/bzuo/d2'
-> INDEX DIRECTORY = '/home/bzuo/d2'
-> )
-> )
-> ;
ERROR 1 (HY000): Can't create/write to file '/home/bzuo/d1/ts#P#p0#SP#s0a.MYI' (Errcode: 13)目录权限
drwxrwxrwx 2 mysql mysql 4096 Mar 4 23:33 d1
drwxrwxrwx 2 mysql mysql 4096 Mar 4 23:21 d2报错
Can't create/write to file '/home/bzuo/d1/ts#P#p0#SP#s0a.MYI' BUG URL:
http://bugs.mysql.com/bug.php?id=29322手册上说可以,官网上也说可以,但是测试不行。
有谁做成功过,出来指点一下。
mysql> CREATE TABLE ts (id INT, purchased DATE) engine=myisam
-> PARTITION BY RANGE(YEAR(purchased))
-> SUBPARTITION BY HASH(TO_DAYS(purchased))
-> (
-> PARTITION p0 VALUES LESS THAN (1990)
-> (
-> SUBPARTITION s0a
-> DATA DIRECTORY = '/home/bzuo/d1'
-> INDEX DIRECTORY = '/home/bzuo/d1',
-> SUBPARTITION s0b
-> DATA DIRECTORY = '/home/bzuo/d2'
-> INDEX DIRECTORY = '/home/bzuo/d2'
-> )
-> )
-> ;
ERROR 1 (HY000): Can't create/write to file '/home/bzuo/d1/ts#P#p0#SP#s0a.MYI' (Errcode: 13)目录权限
drwxrwxrwx 2 mysql mysql 4096 Mar 4 23:33 d1
drwxrwxrwx 2 mysql mysql 4096 Mar 4 23:21 d2报错
Can't create/write to file '/home/bzuo/d1/ts#P#p0#SP#s0a.MYI' BUG URL:
http://bugs.mysql.com/bug.php?id=29322手册上说可以,官网上也说可以,但是测试不行。
有谁做成功过,出来指点一下。
解决方案 »
- 求一SQL语句,只保留一个字段中后面几个字符。
- mysql完全是字符操作吗?有windows界面的管理工具吗?
- 求一条SQL查询语句,请大家帮帮忙
- mysql访问被拒绝,为何,在线等。。。
- linux c mysql
- 关于postgresql数据库启动问题
- Help!! my postgreSQL can not start now!!!!!
- mysql数据库中TYPE=MyISAM是什么意思啊?
- 【急求】MySQL 单表数据4KW,大小2GB,修改表结构,加索引,卡死
- 求助怎么取两个关联表中的自增长字段赋值到存储过程中给第三个表批量添加数据
- 对指定列insert报错 求解
- mysql表中数据统计
[****]$ lsb_release -a
LSB Version: :core-4.0-amd64:core-4.0-ia32:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-ia32:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-ia32:printing-4.0-noarch
Distributor ID: CentOS
Description: CentOS release 5.7 (Final)
Release: 5.7
Codename: Final
+----+-------------+-----------+--------+---------------+------------+---------+----------------------+----------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------+--------+---------------+------------+---------+----------------------+----------+-------------+
| 1 | PRIMARY | SMSMT | ALL | idx_asset | NULL | NULL | NULL | 26171428 | Using where |
| 1 | PRIMARY | Business | eq_ref | PRIMARY | PRIMARY | 4 | ng1.SMSMT.BusinessId | 1 | Using where |
| 2 | SUBQUERY | NodeGroup | ref | BusinessID | BusinessID | 257 | const | 2 | Using where |
+----+-------------+-----------+--------+---------------+------------+---------+----------------------+----------+-------------+
3 rows in set (0.01 sec)
在查询里面,force index(idx_asset),强制指定了走索引idx_asset,但是实际上却还是全表扫描,这是为何?
索引如何建立的,只要上述2个条件是否用到索引
[****]$ lsb_release -aLSB Version: :core-4.0-amd64:core-4.0-ia32:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-ia32:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-ia32:printing-4.0-noarchDistributor ID: CentOSDescription: CentOS release 5.7 (Final)Release: 5.7Codename: Final 不行