hi. I'm using MySQL 3.23.38, default settings for the mysql variables(my-large.cnf), linux 2.2.14-5.0smp kernel - Red Hat 6.2, Records 140750, Size 101.0 MB, mem 1G, CPU PIII 800. But for some reason queries take too many time.
During the long query, I did a "mysqladmin proc" to see what was going on. Under the column "State" I saw the value "copying to tmp table" which lasted a good 6 seconds. So I'm thinking that the copying to tmp table is slowing down the query - but I don't know why. I think I'm not the only one. Anyone can help me? -- Best regards, Alvin mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- 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
