Stefano,
I have a fairly old version of mySQL 4.0.18. But until now, I haven't had
any problems with it.
My connector in the JAMES lib is: mm.mysql-2.0.14.jar
I have never been certain about the correct way to set up the config for
mySQL (ini files vs. cnf files and different places you can optionally put
them etc.) In mySQL 4 version, they have a my.ini that has to be in /WINNT
directory. Then they have an optional my.cnf file that must be in c:\. It
appears the directory requirements have changed in later releases, and they
have everything in the install dir. But I'm still on the old way. At this
point, I have a tiny my.ini in c:/WINNT:
[mysqld]
basedir=c:/mysql
datadir=c:/mysql/data
set-variable = max_allowed_packet=16M
[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld-nt.exe
(I remember some problem where I had to set the max_allowed_packet size
here. But it's been too long to remember why.)
In the c:\ root directory, when SMTP is working ok, I have zero other
configuration (no my.cnf at all). I figure it's simply using all the
defaults.
When I started all of this investigation to attempt to make it run more
efficiently, I realized that there should be a my.cnf file in the root.
There were several sample cnf files in the mysql root, so I simply copied
my-huge.cnf to c:\my.cnf. That's when SMTP died. If I rename my.cnf to
my-cnf.inactive, SMTP starts working. Rename it back, it dies. The
my-huge.cnf is below. But I believe it's untouched from the shipped sample
version.
If you tell me that it's time to bite the bullet and move up the entire
mySQL and drivers to the current version, then I'll accept that. I just
don't want to add another degree of instability unless I have a pretty good
idea that it will solve the problem.
I'm running Windows Server 2003. 1GB of memory. But memory usage is fine.
Not coming close the ceiling on that.
I am using the distributed binaries of both JAMES (2.3.0) and mySQL.
# Example mysql config file.
# Copy this file to c:\my.cnf to set global 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=MySQL
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
set-variable = key_buffer=384M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
set-variable = myisam_sort_buffer_size=64M
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 = d:/mysql/
#datadir = d:/mysql/data/
# Uncomment the following if you are NOT using BDB tables
#skip-bdb
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=384M
#set-variable = bdb_max_lock=100000
# Uncomment the following if you are using Innobase tables
#innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
#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=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
_________________________________________________________________
Puzzles, trivia teasers, word scrambles and more. Play for your chance to
win! http://club.live.com/home.aspx?icid=CLUB_hotmailtextlink
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
