Hi, Running 3.23.37 on freebsd We are making about 200-250 requetes per second on a server with 1Go RAM. We have lot of problems with the requetes which use order by, group by. It seems mysqld copies the data to a tmp table to make sort. The problem is it takes a while to be done. How to make it quicker ? -O long_query_time=10 -O wait_timeout=10 -O interactive_timeout=60 -O max_connect_errors=10000 -O key_buffer=384M -O table_cache=1000 -O sort_buffer=15M -O record_buffer=15M -O max_connections=200 -O thread_cache_size=250 -O max_user_connections=10 -O tmp_table_size=100M -O max_tmp_tables=100 kind of the requets which takes more than 10sec. | Query | 13 | Copying to tmp table | SELECT medias.idmedia, medias.titre, |medias.note, medias.idtype, categ.nomcat FROM medias, medias_de | Query | 11 | Copying to tmp table | select products.products_id, |products.products_name, products.products_price, products.products_imag | Query | 11 | Copying to tmp table | SELECT distinct(gallerie.id) as |id,gallerie.titre as titre,count(wall.id) as galtaille,gallerie.wall thanks for help Octave --------------------------------------------------------------------- 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
