Re: How to partition that table?

[Klaus Redegeld]

the 'slow' selects are all:

SELECT id FROM path WHERE path='$path' AND protocol='$protocol'

Will a normal index be more efficient then a unique key when reading/writing ?
Will 'limit 1' help, as I expect just one record?

| Name               | Engine | Version | Row_format | Rows      | Avg_row_length | Data_length | Max_data_length  | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time          | Collation       | Checksum | Create_options | Comment |
+--------------------+--------+---------+------------+-----------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------+
| path               | MyISAM |      10 | Dynamic    | 109781813 |             62 |  6852857056 |  281474976710655 |   9523100672 |         0 |      109781814 | 2010-09-06 16:02:04 | 2011-06-30 04:02:39 | 2011-06-29 13:49:47 | utf8_unicode_ci |     NULL |                |         |

The machine has 24 GB RAM, and key_buffer = 6G