RE: How to set max_connections ?

2002-06-11 Thread Rekha Das
Do I need to have some kind of permissions to change a variable ? Thanks, Rekha -Original Message- From: Steve Katen [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 6:17 PM To: Rekha Das; '[EMAIL PROTECTED]' Subject: Re: How to set max_connections ? what do you mean

RE: How to set max_connections ?

2002-06-11 Thread Rekha Das
Where can I get a sample my.cnf? Thanks, Rekha -Original Message- From: Steve Katen [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 6:17 PM To: Rekha Das; '[EMAIL PROTECTED]' Subject: Re: How to set max_connections ? what do you mean it doesn't do anything? you

How to set max_connections ?

2002-06-10 Thread Rekha Das
Hi all, I am trying to set max_connections to 200 on my server. Currently it is 100. My mysql version 3.22.32. My problem is I am not able to find my.cnf. And if I set the variable on command line like this: --set-variable = max_connections=200; Then it does not do anything. What am I doing wr

Time function

2001-04-02 Thread Rekha Das
What time function should I use to add 2 hours to a time value I am getting from the database ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arch

Slow query

2001-01-15 Thread Rekha Das
I have two tables named a and b having around 2000 records each. I have written a query to retrieve records from these two tables. I have a left outer join in my query. My problem is that my query is very slow. It takes around 2 minutes to fetch all the records. What can I do to make it fast ? --

Question

2001-01-15 Thread Rekha Das
I need to know whether the primary key field already has a index on it or we need to create one. -Rekha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the