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
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