my.cnf file in mySQL... Tweaking for RAM issues?

[Guest]

My host is saying I'm using 440+ megs of RAM in a 24 hour period, and my store is fairly small. I only have about 1000 products and average only about 36 visitors per day and only about 3 gigs of bandwidth per month. I'm really stumped as to what could be eating all the bandwidth.

 

I've looked at the my.cnf file as it is now and compared it to the my-medium.cnf to see if I need to change anything. I really don't understand the settings and was wondering if any of you could advise.

 

Here's the way the my.cnf fill reads now:

# This will be passed to all mysql clients

[client]

#password = my_password

user  = ********

port  = 4232

socket  = /vs3/********/tmp/mysql.sock

 

# Here is entries for some specific programs

# The following values assume you have at least 32M ram

 

# The MySQL server

[mysqld]

user  = ********

port  = 4232

socket  = /vs3/********/tmp/mysql.sock

tmpdir          = /vs3/********/tmp

basedir        = /vs3/********/usr/local/mysql/

 

skip-locking

set-variable = key_buffer=16M

set-variable = max_allowed_packet=1M

set-variable = thread_stack=128K

# Start logging

log

 

[mysqldump]

quick

set-variable = max_allowed_packet=16M

 

[mysql]

no-auto-rehash

 

[isamchk]

set-variable = key_buffer=16M

 

And this is the suggested configuration for systems with up to 128 megs of RAM (like a web server):

# The following options will be passed to all MySQL clients

[client]

#password = your_password

port  = 3306

socket  = /tmp/mysql.sock

 

# Here follows entries for some specific programs

 

# The MySQL server

[mysqld]

port  = 3306

socket  = /tmp/mysql.sock

skip-locking

set-variable = key_buffer=16M

set-variable = max_allowed_packet=1M

set-variable = table_cache=64

set-variable = sort_buffer=512K

set-variable = net_buffer_length=8K

set-variable = myisam_sort_buffer_size=8M

log-bin

server-id = 1

 

# Uncomment the following if you are using BDB tables

#set-variable = bdb_cache_size=4M

#set-variable = bdb_max_lock=10000

 

# Point the following paths to different dedicated disks

#tmpdir  = /tmp/ 

#log-update  = /path-to-dedicated-directory/hostname

 

[mysqldump]

quick

set-variable = max_allowed_packet=16M

 

[mysql]

no-auto-rehash

#safe-updates # Remove the comment character if you are not familiar with SQL

 

[isamchk]

set-variable = key_buffer=20M

set-variable = sort_buffer=20M

set-variable = read_buffer=2M

set-variable = write_buffer=2M

 

[myisamchk]

set-variable = key_buffer=20M

set-variable = sort_buffer=20M

set-variable = read_buffer=2M

set-variable = write_buffer=2M

 

[mysqlhotcopy]

interactive-timeout

 

 

Obviously, the second one has quite a few more variables set. Anyone in the know think that this could be my problem? By not defining the buffer sizes, is mySQL using more than it should and thus eating up too much of my RAM?

 

Any help or suggestions is greatly appreciated,

 

Bob

[241]

This is what I am using for one setup, I have missed out the top part and xxxx out another. This is a small setup

 

#socket=MySQL
skip-locking
set-variable	= key_buffer=16K
set-variable	= max_allowed_packet=1M
set-variable	= thread_stack=64K
set-variable	= table_cache=4
set-variable	= sort_buffer=64K
set-variable	= net_buffer_length=2K
server-id	= 1

# Uncomment the following if you want to log updates
#log-bin

# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = xxxxxxxxx
datadir = xxxxxxxxx


# Uncomment the following if you are NOT using BDB tables
#skip-bdb

# Uncomment the following if you are using Innobase tables
#innodb_data_file_path = ibdata1:100M
#innodb_data_home_dir = c:\ibdata
#innodb_log_group_home_dir = c:\iblogs
#innodb_log_arch_dir = c:\iblogs
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable	= max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable	= key_buffer=8M
set-variable	= sort_buffer=8M

[myisamchk]
set-variable	= key_buffer=8M
set-variable	= sort_buffer=8M

[mysqlhotcopy]
interactive-timeout

[1quicksi]

See my post in Tips and Tricks B)

[Guest]

How big a store/database are you using this with? Have you run into any performance issues?

 

Thanks,

 

Bob