Hi!
>>>>> "Michael" == Michael Bacarella <[EMAIL PROTECTED]> writes: Michael> Well, looks like I found the culprit. Michael> Increasing thread_cache_size from 0 to 50 totally alleviated the stress Michael> (both on the database and our clients). Recommended by the manual, Michael> of course. That's strange. This is the first time I have seen someone needed to increase this to get the same performance with 3.23 as with 3.22. 3.22 didn't have this option, so I don't think this is the bases to your problem. When you upgraded to 3.23, did you upgrade your OS at the same time ? Michael> For list-archival's sake: Michael> FreeBSD 4.3-STABLE Michael> /etc/my.cnf: Michael> [mysqld] Michael> user=mysql Michael> set-variable = wait_timeout=3600 Michael> set-variable = tmp_table_size=8000000 Michael> set-variable = max_connections=500 Michael> set-variable = table_cache=256 Michael> set-variable = sort_buffer=4M Michael> set-variable = key_buffer=64M Michael> set-variable = thread_cache_size=50 Michael> top: Michael> CPU states: 66.3% user, 0.0% nice, 30.2% system, 3.1% interrupt, 0.4% idle Michael> Mem: 33M Active, 92M Inact, 29M Wired, 8368K Cache, 35M Buf, 87M Free Michael> Swap: 1024M Total, 88K Used, 1024M Free Michael> mytop (a great utiltiy, may I add) is reassuring: Michael> Queries Total: 129,866 Avg/Sec: 450.92 Slow: 0 Michael> Threads Total: 3 Active: 1 Cached: 48 Michael> Key Efficiency: 99.73% Bytes in: 16,118,135 Bytes out: 26,368,181 Michael> Unfortunately, the application does make a new connection for every Michael> hit, which is why thread_cache_size probably made a difference. Yes, it should help in this case, but doesn't explain the difference to 3.23. Usually the thread_cache_size has only a 2-3 % impact on the overall performance. Michael> Out of curiousity, what was different about 3.22? Based on the above, I can't say what it could be. You don't even have any 'slow' queries... If you ever found out what it could be, please keep us informed! Michael> Anyway, Thanks to all who responded. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
