Hi all,
gosh, I must be overlooking something obvious. Running mysql 4.0.16. I
want to set the wait_timeout in my.cnf (section [mysql]) like:
wait_timeout = 300
also tried the depricated
set-variable = wait_timeout=300
Both are not working; still default to 28800. Sure, I stopped and
started
correction: section shoud be read as [mysqld]
-Original Message-
From: Hoeven, Maarten van der
Sent: Tuesday, November 11, 2003 12:02 PM
To: [EMAIL PROTECTED]
Subject: Setting wait_timeout in my.cnf?
Hi all,
gosh, I must be overlooking something obvious. Running mysql 4.0.16. I
want
but substitute any underbar (_) with a hiven
(-)
when doing a setting in the my.cnf.
--
kind regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql/
On Tuesday 11 November 2003 20:22, Hoeven, Maarten van der wrote:
correction: section shoud be read as [mysqld]
-Original Message
PROTECTED]
Sent: Tuesday, November 11, 2003 1:48 PM
To: [EMAIL PROTECTED]
Cc: Hoeven, Maarten van der
Subject: Re: Setting wait_timeout in my.cnf?
Hmm.
You could try
show variables like %timeout%;
perhaps interactive_timeout
can help you out ?
--
kind regards
Nils Valentin
Tokyo/Japan
http
Hi all,
Is there a rule of thumb how much internal memory you should install,
when pursuing maximum performance? A rule of thumb like: Internal
memory should be equal or more than the size of the database. Example:
total database size=3 GB; therefor internal memory should be at least 3
Gb.
Is
different.
Thanks,
Maarten
-Original Message-
From: Berry Sizemore [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 3:37 PM
To: Hoeven, Maarten van der
Cc: [EMAIL PROTECTED]
Subject: Re: Amount of memory: rule of thumb
jihad!
My opinion is memory concerns are bound
Hi all,
consider I want to compare one field stored in two tables (the field
being a key in both tables), like
SELECT table1.field FROM table1, table2 WHERE table1.field=table2.field
I have the choice (I'm developping the datamodel right now) to define
this field as an INT(6) or as an
What are the errors?
For example, is the error like unable to create the tables, because the
tables still exist? See the dumpfile if tables are created (by default).
If so, delete the tables first, and redump back the dumpfile.
-Original Message-
From: Uma Shankari T. [mailto:[EMAIL
