Hey guys

I have a 1.7ghz, 1gig of ram box, running mysql.
I compiled mysql, didnt use rpm.

It's starting to get lots of mysql processes being spawned

At first it was quite, but the more db's and the more thigns you add the more work gets done.... anyway.

I was wondering if there is anyone out there that compiled mysql also, and has a good , perhaps "sooped" up my.cnf for a large machine such as mine? ors omething like tat.. share yours please

processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 1
model name : Intel(R) Pentium(R) 4 CPU 1.70GHz
stepping : 2
cpu MHz : 1694.531
cache size : 256 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm
bogomips : 3381.65

# cat /proc/meminfo
total: used: free: shared: buffers: cached:
Mem: 1052884992 1046196224 6688768 49152 11853824 525574144
Swap: 2097434624 2867200 2094567424
MemTotal: 1028208 kB
MemFree: 6532 kB

Taken from George at vbulletin.com
Can you post your mysql configuration variables located at /etc/my.cnf
mysqladmin -u root -p variables
your mysql extended-status output either still telnet as root user type

mysqladmin -u root -p extended-status
copy and paste output here

Try to use this my.cnf file and see if it makes a difference
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=650
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=2M
set-variable = record_buffer=2M
set-variable = sort_buffer=3M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=7200
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
open_files_limit=8192
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

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

[mysqlcheck]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=32M
set-variable = write_buffer=32M

[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=16M
set-variable = write_buffer=16M



Hope this helps
Steven