I do have slow queries, but they are big joins across all the big tables, and users doing querys on tables without using a key, the contract requires dynamic query on any fields, and the tables are too big to index every possible key combination they would use (30-40 columns on some)
So far, I've got no major issues, aside from big queries and there's no way around that, unless mysql changes on how it combines indexes, ie it does not combine them currently.
Matt
Gleb Paharenko wrote:
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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
