Results 1 to 3 of 3
Thread: MySQL more RAM less CPU
-
09-19-2006, 01:58 PM #1Newbie
- Join Date
- Mar 2006
- Posts
- 25
MySQL more RAM less CPU
Hello,
I always have ~1.5GB free RAM, how can I optimize server, that loads will be lower? I want that MySQL would use more RAM (then CPU load will be lower, yes?). My my.cnf
Code:[root@int etc]# free -m total used free shared buffers cached Mem: 3042 2993 48 0 80 1164 -/+ buffers/cache: 1748 1293 Swap: 2054 15 2039
Code:[mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock #skip-innodb skip-locking key_buffer = 512M #tmp_table_size = 32M max_allowed_packet = 16M max_connections = 800 #max_user_connections = 300 table_cache = 20000 join_buffer_size = 3M sort_buffer_size = 3M read_buffer_size = 3M myisam_sort_buffer_size = 128M thread_cache_size = 3000 wait_timeout = 30 connect_timeout = 10 query_cache_limit = 4M query_cache_size = 256M query_cache_type = 1 tmp_table_size = 300M thread_concurrency=4 #log-bin=on-bin server-id=1 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=32M sort_buffer=64M read_buffer=64M write_buffer=64M [myisamchk] key_buffer=32M sort_buffer=64M read_buffer=64M write_buffer=64M [mysqlhotcopy] interactive-timeout
Uptime: 85849 Threads: 4 Questions: 6296494 Slow queries: 1 Opens: 110275 Flush tables: 886 Open tables: 10 Queries per second avg: 73.344
Thank you for your suggestions.Last edited by intserv; 09-19-2006 at 02:03 PM.
-
09-21-2006, 03:59 AM #2Junior Guru Wannabe
- Join Date
- Feb 2003
- Posts
- 44
How big are your indexes?
What is MySQL mainly used for? (forum, busy website, etc.)
-
09-21-2006, 04:19 AM #3Newbie
- Join Date
- Mar 2006
- Posts
- 25
Using mysql for webhosting server with ~250 clients, ~10 big websites.