setting key_buffer_size correctly

2001-02-15 Thread twilight
Hello, I have a large database with a lot of queries and was trying to tune MySQL to get the best performance. I was reading the manuals and it said to set the key_buffer_size to the best value, you take the first two of the following values and divide by each other. I believe it said you should g

Query Help

2001-02-05 Thread twilight
Hello, I have a table of 26 million rows that I need to query. The table is a keywords database with the keyword and a pointer to what page it came off of. (pageid|keyword) The problem is that when I use the following query is the group by make the query take about 14 seconds to do. However, if I