sql spam filter Hi
I'm running MySQL-3.23.37 on a cobalt raq. I have a table with approx 40,000 records and a dozen users running simple queries and updates - names, addresses that kinda thing, but every time a query is run mysql takes everything it can get and the box freezes: 10:33am up 12:18, 1 user, load average: 0.37, 0.55, 1.74 66 processes: 64 sleeping, 2 running, 0 zombie, 0 stopped CPU states: 71.5% user, 20.5% system, 0.0% nice, 7.9% idle Mem: 517188K av, 207384K used, 309804K free, 50216K shrd, 13508K buff Swap: 131532K av, 40240K used, 91292K free 122896K cached PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND 28351 mysql 10 0 7064 5924 856 S 0 77.3 1.1 1:41 mysqld Is there somethig I need to optimise?? I'm using the "as supplied" my_large.cnf. Any help, suggestions gratefully rec'd Steve --------------------------------------------------------------------- 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