Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

few doubts

Quote Reply
few doubts
Hi,

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.
Subject Author Views Date
Thread few doubts hegu 4345 May 4, 2003, 4:55 AM
Thread Re: [hegu] few doubts
Chaz 4282 May 4, 2003, 8:04 AM
Post Re: [Chaz] few doubts
hegu 4260 May 4, 2003, 9:45 AM
Thread Re: [hegu] few doubts
Alex 4252 May 5, 2003, 12:07 PM
Thread Re: [Alex] few doubts
hegu 4243 May 5, 2003, 2:12 PM
Thread Re: [hegu] few doubts
Alex 4243 May 5, 2003, 2:17 PM
Post Re: [Alex] few doubts
hegu 4235 May 5, 2003, 2:24 PM