CVSz Posted October 16, 2007 Posted October 16, 2007 Hi, Can you please help tweaking my.ini for me? My Server Spec ( Going to change to Quad Xeon, DDR2, HDD RAID Soon but need to fix the problem first): Intel P4 2.8E DDR 2 GB HDD 120 GB IDE IIS as Web server MySQL 5.0 Right now, I have about 300-500 visitors and causing very high CPU load (almost 100%) and the temperature is getting higher every sec. (Almost 90c) Here is my.ini:max_connections=300 key_buffer=220M join_buffer=2M record_buffer=5M sort_buffer=8M table_cache=400 myisam_sort_buffer_size=32M thread_cache_size=128 max_allowed_packet=16M wait_timeout=1200 connect_timeout=10 max_connect_errors=10 query_cache_limit = 1M query_cache_size = 32M query_cache_type = 1 skip-innodb default-character-set=tis620 skip-character-set-client-handshake old_passwords # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 server-id = 1 innodb_buffer_pool_size = 256M innodb_additional_mem_pool_size = 20M [mysqldump] quick max_allowed_packet = 20M [mysql] no-auto-rehash [isamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M character-sets-dir=C:/mysql/share/charsets set-collation=utf8_general_ci [mysqlhotcopy] interactive-timeout Any idea!? Please help. Thanks a lot.
bfarber Posted October 16, 2007 Posted October 16, 2007 You really ought to add some more memory for 500 users online. One box should be able to handle it, but 2GB is probably going to get eaten up quickly with that many people on your site. Temporarily, I'd restart the webserver and mysql and once it comes back up keep an eye on things to see what's getting hung up.
CVSz Posted October 17, 2007 Posted October 17, 2007 Thanks bfarber for the reply. I'm kinda know that my sv spec is not enough.... How do I monitor this problem? I'm kinda new to SQL. I've done some changes to my config and sometimes the CPU decreases but the RAM has been taken out instead. Thanks
Bobsuch Posted October 17, 2007 Posted October 17, 2007 Source here:http://www.ipsbeyond.com/forums/index.php?...ost&p=15837More memory will ALWAYS help. If you have 8GB of memory and add another 2GB, it would never hurt. :D The[color="#FF0000"][i][b] key_buffer_size [/b][/i][/color]is somewhat low for the amount of data in the database, however keep in mind this isn't a dedicated mysql server (it's mysql + web) and he only has[color="#FF0000"] [i][b]2GB [/b][/i][/color]right now. You might be able to up the value to like [color="#FF0000"][i][b]768MB[/b][/i] [/color]at the most, but be careful - if you give too much memory to mysql, apache will get mad, go on strike, and sue you.
bfarber Posted October 17, 2007 Posted October 17, 2007 Well, you said the CPU is low? If the CPU and load are low, let the memory get eaten up. That's better than letting it sit there and waste, right? Might as well use what you have. I pretty much always concentrate on Load CPU percentage in use RAM SWAP usage If the SWAP usage is low (reported from top - there usually is SOME, but it should be very low) then I wouldn't worry about the RAM being used up.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.