Hi,
I saw these two posts when i am searching the forums.
You may also want to tweak your MySQL setup if you have 2 gigs of ram. Look at their my-huge.cnf sample configuration. This will greatly improve the performance of MySQL, especially on large databases.
Cheers,
Alex
--
Gossamer Threads Inc.
I run Links SQL and the entire DMOZ dump on two machines (web and database). Both machines are running RedHat. The web server is running Apache w/mod_perl. The database server is:
1000Mhz AMD Athlon
1.5 GB RAM
Ultra160 10k hard drives
I get all queries back in seconds. The speed also depends on the indexing method you are using (I use INTERNAL). I do a bit of tweaking (adding MySQL indexes to certain fields, etc.) I have however limited my search results to 2000 max, which helps. Oh, and I just installed this Search Cache plugin would seems to work very well:
http://www.gossamer-threads.com/...;;page=unread#unread
Sean
My questions are:
1. What is this my-huge.cnf? Is it a file? I searched the linkssql files. No luck.
2. How to set up Internal indexing method? In admin panel?
3. How to limit search results?
Any help would be appreciated.
I saw these two posts when i am searching the forums.
Quote:
You may also want to tweak your MySQL setup if you have 2 gigs of ram. Look at their my-huge.cnf sample configuration. This will greatly improve the performance of MySQL, especially on large databases.
Cheers,
Alex
--
Gossamer Threads Inc.
Quote:
I run Links SQL and the entire DMOZ dump on two machines (web and database). Both machines are running RedHat. The web server is running Apache w/mod_perl. The database server is:
1000Mhz AMD Athlon
1.5 GB RAM
Ultra160 10k hard drives
I get all queries back in seconds. The speed also depends on the indexing method you are using (I use INTERNAL). I do a bit of tweaking (adding MySQL indexes to certain fields, etc.) I have however limited my search results to 2000 max, which helps. Oh, and I just installed this Search Cache plugin would seems to work very well:
http://www.gossamer-threads.com/...;;page=unread#unread
Sean
My questions are:
1. What is this my-huge.cnf? Is it a file? I searched the linkssql files. No luck.
2. How to set up Internal indexing method? In admin panel?
3. How to limit search results?
Any help would be appreciated.