Hello.
SHOW STATUS and a piece of SHOW PROCESSLIST with slow queries could give additional information, so the probability of the helpful answer grows. matt_lists <[EMAIL PROTECTED]> wrote: > Anybody have any suggested settings for our my.ini ? > > 4 gig box, running windows 2003 > > peak memory usage for mysql is 1.4 gig currently > > using myisam files, lots of little index querys, and some very large > queries at night > > 615 tables, 88.3 gb of myd, 45.2 gb of myi, 33 of the tables/indexes > break 1 gig, largest is 6 gig > > if you discount the piddly little tables, there are only 125 tables with > size that matter, ie larger than 50mb > > > Here's what we have now, sugestions welcome > > max_connections=100 > query_cache_size=512M > query_cache_type=1 > table_cache=1024 > tmp_table_size=400M > thread_cache_size=8 > myisam_max_sort_file_size=100G > myisam_max_extra_sort_file_size=100G > myisam_sort_buffer_size=369M > key_buffer_size=318M > read_buffer_size=64K > read_rnd_buffer_size=256K > sort_buffer_size=256K > open-files-limit=500 > myisam-recover=BACKUP,FORCE > memlock > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
