> How much data are you searching through? (how big is your dbmail db?) Roughly 100 GB; it's got 750K messages or so.
> How much ram does the db server have? 2 GB > How much ram is allocated to the db software? How do I check? > Are you running MySQL or Postgres? or something else? MySQL > If MySQL, How big is your innodb_buffer_pool_size variable in my.cnf ? Just bumped it to 1 GB. Doesn't seem to be affecting things. But, upon reading the stuff that popped up when I plugged "innodb_buffer_pool_size" into Google, it looks like I'd need HUGE amounts of RAM for it to make a "real" difference -- at least, with a 100+ GB database. Thanks! -Ken > > > SG > > > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is believed to be clean. > > -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
