[ubuntu] help me tune up my MySQL - my.cnf

view full story

http://ubuntuforums.org – hi, i just compiled MySQL 5.5.24 from source and now I'd like to tune up MySQL for best performance for my VPS. hw: *-cpu product: Six-Core AMD Opteron(tm) Processor 2431 vendor: Hynix Semiconductor (Hyundai Electronics) physical id: 1 bus info: cpu@0 width: 64 bits 1GB RAM Thank's a lot ;) cur. my.cnf: # Example MySQL config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # an important part, or systems up to 128M where MySQL is used together with # other programs (such as a web server (Hardware)