The manual describes wait_timeout thusly:
"The number of seconds the server waits for activity on a non-interactive connection
before closing it. On thread startup, the session wait_timeout value is initialized
from the global wait_timeout value or from the global interactive_timeout value,
dep
I have been maintaining a mod-perl/MySQL4 web search engine with about 3M records,
which gains and drops about 100k records daily.
It runs on a dual-Opteron 242 system with 8GB RAM, 15k SCSI driv, SUSE Professional
for AMD64.
It recently grew to this size (from about 1M records), and I am encoun
> If you are using MySQL 4.x, using a RAM disk isn't going to speed
> up similar Selects very much because it caches them. If you are doing a
lot
> of different Selects then it will help.
Its a web search engine with 10-15 search options, so yes the selects will
vary and very often every row will
- Original Message -
From: "Seth Brundle" <[EMAIL PROTECTED]>
To: "Eric" <[EMAIL PROTECTED]>
Sent: Wednesday, January 28, 2004 5:50 PM
Subject: Re: 64-bit Linux MySQL and ramdisks
> > I am curious, is there really that big of a benefit to using a
After some research, I chose a dual Opteron MySQL server for my new search box. For
storage, I only update the tables once a day, so I plan on putting my data directory
on a Linux ramdrive and backing it up to the hard disk after each update for maximum
performance.
If anyone has any reccommend
PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> In the last episode (Mar 31), Seth Brundle said:
> > First people, please dont get all angry about my suggestion...please
> > hear me out...
> >
> > > I really hate on-line forums. They're difficult
> No but those in need of help does. And those ppl who are capable of
helping
> them are usually busy. Do they keep a browser open and refresh the forum
> frequently? I'll answer that question: no.
Many forums packages have the ability to distribute the discussion as a
mailing list as well (Yahoo!
> Most ppl don't like forums.
I disagee with that, but then again I probably dont have any more idea then
you do.
> Do you know even one serious project which uses
> a forum? I know Slackware did and it really was a PAIN.
All of the projects on SourceForge.net?
Also, by forum I also mean usenet
> It's much more convenient than a web forum, and much
> faster too, because I don't have to wait for some remote, overloaded
server
> to respond.
This makes no sense as message I post to a Yahoo! Group get emailed to
opt-in members and appears on the group within seconds, while I may not
receive
> > I really hate on-line forums. They're difficult to track because I
> > must remember visit them daily.
>
> Agreed. I don't need yet another web page to keep track of. I prefer to
> let my mail reader thread up the messages on this list, then I browse
> through every now and then and delete e
First people, please dont get all angry about my suggestion...please hear me
out...
> I really hate on-line forums. They're difficult to track because I
> must remember visit them daily.
OK this is the first issue - 95% of people who need MySQL info do not need
it daily. Mailing lists are a poor
I really hate mailing lists - they are dinosaurs for this type of thing.
A web discussion board is a much more powerful and flexible tool for this
type of community. Thread tracking, archiving, searching, dont have to
download 50 emails a day just to monitor a couple threads...cmon its 2003!
Cant
Is it possible to place MySQL data directories on a Linux ramdisk mount?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this th
I just built a P4 3.06 1GB DDR 333 15k U160 SCSI MySQL Linux server.
I was dissapointed because I couldnt get the dual-channel DDR 400 MB I tried
first to run stable :(
dual-channel memory controllers definitely made a slight difference on the
benchmarks with the same ram.
alter-table 2
I attempted to optimize a table last night, which usually takes about 5
minutes but I expected to take longer as I had done a slew of deletes.
Well, it took over an hour, and from the last modified dates on the table
and temp files, it looked like they hadnt been updated in 10-15 minutes.
Eventua
I have a MySQL database I will be launching soon which has a search engine
database accesable over DBI/mod_perl/Apace. It has about 2M records, and is
a 4GB table with 1GB index.
Every day I insert 76k records all at once and delete about another 76k.
While these inserts are happening, the select
16 matches
Mail list logo