can u show the explain plan for your query
On Tue, Jul 10, 2012 at 2:59 PM, Darek Maciera <darekmaciera@stripped>wrote:
> Hello,
>
> I have table:
>
> mysql> DESCRIBE books;
>
> |id |int(255) | NO | PRI |
> NULL | auto_increment |
> | idu | int(255) | NO | MUL | NULL
> | ksd | char(15) | YES | | NULL
> | idn | int(1) | NO | MUL | NULL
> | text1 | text | NO | | NULL
> | ips | int(1) | NO | MUL | NULL
> | ips2 | int(1) | NO | MUL | NULL
> | date | timestamp | NO | | CURRENT_TIMESTAMP
> | date2 | date | NO | | NULL
> | text2 | text | NO | | NULL
> | text3 | text | NO | | NULL
>
> I have indexes in this table:
>
> mysql> SHOW INDEX FROM uzytkownicy_strona_kody;
>
> | books | 0 | PRIMARY | 1 | id | A
> | 369625 | NULL | NULL | | BTREE |
> |
> | books | 1 | idx_idu | 1 | idu | A
> | 184812 | NULL | NULL | | BTREE |
> |
> | books | 1 | idx_id | 1 | id | A
> | 369625 | NULL | NULL | | BTREE |
> |
> | books | 1 | idx_idn | 1 | idn | A
> | 8 | NULL | NULL | | BTREE |
> |
> | books | 1 | idx_ips | 1 | ips | A |
> 8 | NULL | NULL | | BTREE | |
> | books | 1 | idx_ips2 | 1 | ips2 | A |
> 8 | NULL | NULL | | BTREE | |
>
> Every books have unique: 'ksd'. There are about 370.000 records in this
> table.
>
> But this SELECT take too long time:
>
> mysql> SELECT * FROM books WHERE ksd ='A309CC47B7';
> 1 row in set (2.59 sec)
>
>
> Table is in InnoDB engine. I added to my.cnf: innodb_buffer_pool_size =
> 512MB
>
> Any suggestions? Help, please..
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
>
