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.
Quote Reply
Re: [hegu] few doubts In reply to
Hi Hegu,

Assuming you're talking about Links SQL, you'd be much better off asking your questions in one of the Links SQL forums.

Regarding your first question, my-huge.cnf is a MySQL config file. Try this link for more info: http://www.mysql.com/...rver_parameters.html

Regards,
Charlie
Quote Reply
Re: [Chaz] few doubts In reply to
Ooops...

I will post this in LinksSQL.

Thanks.
Quote Reply
Re: [hegu] few doubts In reply to
It does apply to both so, I'll also answer here.. that file is a sample configuration file that comes with MySQL and shows defaults you can use if you have over 1 gig of memory.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] few doubts In reply to
Hi Alex,

I saw this file 'mysql.cfg' in 'mysqlman' folder. Is this you are talking as my-huge.cfg?

I saw these lines in this mysql.cfg file:

=====================================

# MYSQLDUMP
# --------------------------------------------------------
# For very large databases, it might be a good idea to divide
# the contents of the tables into pages to be written into files
# to reduce the load on memory.
# (on = 1, off = 0)
dump_in_pages => 0,

=====================================

'0' is set to '1'?

Thanks.
Quote Reply
Re: [hegu] few doubts In reply to
No, here's an example one.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] few doubts In reply to
Hi Alex,

What i have to do it with this file exactly? Where to set it up?

I have to give this file to my web host to set up for me?Blush Sorry. Entirely newbie stuff.

Thanks.

Last edited by:

hegu: May 5, 2003, 3:09 PM