Speeding up mysql

Anon

Hi. I recently reinstalled mysql - using the source files as opposed to the RPM I had used prior to this.

My problem is that my queries are now painfully slow. I've been reading a bit on this in the forums and it seems that the problem is with installation.

I'd like to re-install mysql or do whatever is necessary to speed things up. What is the best way to do this? Do I need to back anything up when I reinstall? What configuration commands do I need to make sure that the query is fast?

Thanks,
Kyle

Anon

The problem could be serveral things:
1 - the design of the database
2 - the configuration of MySQL
3 - your SQL query

... I don't think anyone can help you unless you provide more details about the above

Anon

Re-installing mysql from source means updating the mysqld binary,
this should not affect your current databases.

But, it is allways better to have a backup of your data before you update software.

To get the most out of mysql, read the manual!
It has tips about how to make it faster by re-compiling,
and by re-configuring.
Test the speed using the mysql "benchmark" functions, and see which method of compiling is faster for your server.