Hi
Here is my my.cnf. pls suggest the changes to make the
performance better. I am upgrading to the latest version.
===============
# Example mysql config file.
# You can copy this to one of:
# /usr/local/mysql/etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /usr/local/mysql/var) or
# ~/.my.cnf to set user-specific options.
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options
# This will be passed to all mysql clients
[client]
#password = my_password
port = 3306
socket = /tmp/mysql.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer=8M
set-variable = back_log=25
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
set-variable = max_connections=50
set-variable = table_cache=32
set-variable = sort_buffer=500K
set-variable = record_buffer=100K
set-variable = net_buffer=5K
# Start logging
log
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=16M
=========================
with best wishes
Arun
Date sent: Sun, 13 May 2001 18:41:50 -0700
From: Jeremy Zawodny <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Copies to: [EMAIL PROTECTED]
Subject: Re: Mysql Problem
Send reply to: [EMAIL PROTECTED]
> On Fri, May 11, 2001 at 07:48:04PM +0530, [EMAIL PROTECTED] wrote:
> >
> > I am facing great problems beacuse of Mysql server which is not able
> > to take load.
> >
> > My apache is working fine even when the load average shoots of to
> > 130 but my mysql server goes sleep when the load of apache shoots
> > above 30. I am on a dedicated server.
> >
> > My Mysql Ver 3.22.32
>
> You may try upgrading to 3.23.xx. There were some performance
> improvements in the newer versions.
>
> > I have red hat linux 6.2 as OS and memory of 256 MB .
> >
> > I am attaching my my.cnf file , pls look into it and suggest ways
> > for improving my server performance.
>
> Attachements are filtered by this list, in case you didn't notice.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
>
> MySQL 3.23.29: up 130 days, processed 804,119,056 queries (71/sec. avg)
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
