Hi,
i'm using MySQL 3.23.37 on a Linux system with an average of about
20 queries/second.
First of all i have a little question how i can optimize a query.
The query is like that:
select * from tbl where key_field1 constant1 and key_field2
constant2
Examine that query with explain
Stefan Pinkert wrote:
Examine that query with explain select... show that the indexes are not
used. The keyfields are unsigned tiny int where every bit has a different
meaning. Any clue how i can rewrite this query in a way where the indexes
are
used?
If MySQL thinks it will be faster to
]
Betreff: Re: Optimization question and possible bug
.
In the database i have a merge-table that merges 10 myisam tables.
Sometimes the loadaverage of the system raise above 50 and the
long-query-log is
filled with some query accessing the merge table. This happens 2-3
times a
day.
Only