MySQL my.cnf file

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

 

 

 

 

Top