Setting wait_timeout in my.cnf?
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 the server. However, when I set the variable in the mysql-client with: set wait_timeout=30; the variable wait_timeout is changed! What am I overlooking? I really want to set this in my config-file, rather that setting it manually in the client... Any hints? PS. Linux Redhat 9 out of the Box, kernel 2.4.20-8 Maarten -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Setting wait_timeout in my.cnf?
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 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 the server. However, when I set the variable in the mysql-client with: set wait_timeout=30; the variable wait_timeout is changed! What am I overlooking? I really want to set this in my config-file, rather that setting it manually in the client... Any hints? PS. Linux Redhat 9 out of the Box, kernel 2.4.20-8 Maarten -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Re: Setting wait_timeout in my.cnf?
nope, that didnt help. Thanks though! Any other suggestions? -Original Message- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 1:00 PM To: [EMAIL PROTECTED] Subject: Re: Setting wait_timeout in my.cnf? Hi Maarten, I havent tried it recently 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- From: Hoeven, Maarten van der Sent: Tuesday, November 11, 2003 12:02 PM To: [EMAIL PROTECTED] Subject: Setting wait_timeout in my.cnf? -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ 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 the server. However, when I set the variable in the mysql-client with: set wait_timeout=30; the variable wait_timeout is changed! What am I overlooking? I really want to set this in my config-file, rather that setting it manually in the client... Any hints? PS. Linux Redhat 9 out of the Box, kernel 2.4.20-8 Maarten -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html --- -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Setting wait_timeout in my.cnf?
tsss, how about that :) yes, I can set interactive_timeout to a value in my.cnf (interactive_timeout=30). This works! However, as a side-effect, wait_timeout is *also* set to 30. Right, problem solved. Thanks, Nils. Maarten -Original Message- From: Nils Valentin [mailto:[EMAIL 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://www.be-known-online.com/mysql/ On Tuesday 11 November 2003 21:37, Hoeven, Maarten van der wrote: nope, that didnt help. Thanks though! Any other suggestions? -Original Message- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 1:00 PM To: [EMAIL PROTECTED] Subject: Re: Setting wait_timeout in my.cnf? Hi Maarten, I havent tried it recently 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- From: Hoeven, Maarten van der Sent: Tuesday, November 11, 2003 12:02 PM To: [EMAIL PROTECTED] Subject: Setting wait_timeout in my.cnf? -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ 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 the server. However, when I set the variable in the mysql-client with: set wait_timeout=30; the variable wait_timeout is changed! What am I overlooking? I really want to set this in my config-file, rather that setting it manually in the client... Any hints? PS. Linux Redhat 9 out of the Box, kernel 2.4.20-8 Maarten -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html --- -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Amount of memory: rule of thumb
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 there such a rule of thumb? Of course, I'm ignoring all other parameters and settings now for convenience reasons... Greets, Maarten -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Amount of memory: rule of thumb
Ah, of course. My apologize for being insufficient. OS will be Linux, Redhat 7.2. Please note, I'm only looking for a very general (and probably rough) estimate for the amount of internal memory. That's why a rule of thumb. There are a lot of circumstances that can make the world look completely 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 to operating system. What is recommended for your OS? Best, Jerry Cornelius Hoeven, Maarten van der wrote: 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 there such a rule of thumb? Of course, I'm ignoring all other parameters and settings now for convenience reasons... Greets, Maarten -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What's faster: string or numeric comparison...?
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 VARCHAR(6). The question is: if I only store numerical values in this field, what definition (INT or VARCHAR) will be the fastest in the query above? More general: are INT-fields faster of slower in this kind of comparisons? PS. The reason I'm considering VARCHAR is that it might be possible I need to store characters in the field, in stead of only figures. Thanks, Maarten The Netherlands -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Abt Mysqldump
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 PROTECTED] Sent: Tuesday, September 02, 2003 1:33 PM To: [EMAIL PROTECTED] Subject: Abt Mysqldump Hello, I have dumped the database contents as one txt file by using this command mysqldump databasename -uusername -ppasswd textfilename. but while redumping back to mysql it is giving some errors in the textfile..is there any possibility to redump the contents without any error.. Regards, Uma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]