On Tue, Oct 21, 2003 at 08:59:31PM -0600, Travis Reeder wrote: > It seems mostly to be mysql pinned, not the app. like 99% mysql until > all data is processed and keeps going up when data coming in is more > than can be processed.
So MySQL is using 99% of the CPU? Any idea why? Are you doing too many table scans? Too much computation in the queries? Lots of LIKE "%foo%" queries? If the CPU is truly the bottleneck and you can't improve the performance by tweaking queries and settings, then faster CPUs will help. > What could I change in my.cnf to get better performance? I just have a > default mysql install (4.0). It's hard to say. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 39 days, processed 1,493,160,737 queries (439/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
