I have lot of update/insert queries as well as select queries with a lot of
sorts. Please let me know what settings should I use for optimal performance. I
am using MyISAM tables.
The db size is 30 G.
Thanks
-
Do you Yahoo!?
Yahoo! Small
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 11, 2004 7:42 AM
> To: Dathan Vance Pattishall
> Subject: RE: my.cnf setup
>
> Thanks for the feedback!
>
> I have made the changes you suggested. I do have a ques
[EMAIL PROTECTED] wrote:
I am running a mysql server off a Dell 2650.
Dual 2.8Ghz Intel Xeon processors
1 Gig of RAM
The MySQL data comes up rather slowly. Would like some suggestions on my
my.cnf file if you had a minute.
Conner:
The problem is very unlikely your my.cnf, and very likely your app
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 10, 2004 2:23 PM
> To: [EMAIL PROTECTED]
> Subject: my.cnf setup
>
> I am running a mysql server off a Dell 2650.
> Dual 2.8Ghz Intel Xeon processors
> 1 Gig of RAM
&
I am running a mysql server off a Dell 2650.
Dual 2.8Ghz Intel Xeon processors
1 Gig of RAM
The MySQL data comes up rather slowly. Would like some suggestions on my
my.cnf file if you had a minute.
here is what I have
++--+
| Variable_name
Kirti S. Bajwa wrote:
Hello List:
I have setup MySQL and it is working fine. I tested connection to MySQL.
Now I have gone one step futher and added a password for mysql, as follows:
shell> ./mysqladmin -u root password mysqlpw
Now I want to setup myc.cnf. Our SQL server is a standalone ser
Hello List:
I have setup MySQL and it is working fine. I tested connection to MySQL.
Now I have gone one step futher and added a password for mysql, as follows:
shell> ./mysqladmin -u root password mysqlpw
Now I want to setup myc.cnf. Our SQL server is a standalone server (RH9,
Dual CPU, 1.5GB
