Results 1 to 3 of 3
Thread: mysql optimization?
-
01-03-2008, 07:49 PM #1Newbie
- Join Date
- Nov 2007
- Posts
- 7
mysql optimization?
I currently have a VPS with 1GB RAM, can anyone suggest a good optimization through the my.cnf file?
I tried "myself tuning primer", it ran but there were a lot of errors in the python script so I don't want to rely on that. Or is mysql auto-optimized when its installed?
Here's my current my.cnf:
Code:[mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 16K max_allowed_packet = 1M table_cache = 4 sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K net_buffer_length = 2K thread_stack = 64K skip-bdb skip-innodb [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer = 8M sort_buffer_size = 8M [myisamchk] key_buffer = 8M sort_buffer_size = 8M [mysqlhotcopy] interactive-timeout
-
01-04-2008, 02:38 AM #2Web Hosting Evangelist
- Join Date
- Apr 2003
- Location
- Melbourne, AU
- Posts
- 539
Are there existing performance problems?
WK Woon
CTO | http://www.aflexi.net - A flexible Network
Building the next generation CDN platform - DEMO .... coming soon
-
01-04-2008, 04:11 AM #3Disabled
- Join Date
- Apr 2005
- Location
- Cochin
- Posts
- 2,452
Mysql is not auto optimized, and you need to optimize it according to your personal performance requirement. One optimized my.cnf may not be the same for yours.
The process is server/VPS specific