Hello, I'm running MySQL 5.1.46 on Linux. It works fine. I have a larger database that has one 700MB table. Its slow because of the way to do my selects. I'm not very good at optimizing things so I don't know how to improve it.
For example when I do:
select distinct channel_num from Track where account_num = '123'
I get this for "show processlist" and of course it takes like 500 seconds:
Copying to tmp table
How can I improve this?
channel_num along with some text fields are pretty much what makes up the table.
Theres a bunch of indexes, but I don't know if they're helping or hurting the problem. For example theres a field account_num, video_num, channel_num and some dates which all have a unique index. Theres 11 indexes on this table. Is that too much?