Ok folks your little words of wisdom crunched our problem out and and we built a metacrawler that is faster than momma and dogpile because we now NEVER touch a harddrive while searching. We will be applying this search to our Blogging software at firebasesoftware.com by Monday.
Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 3:17 PM To: Mysql Subject: Memory Tables and My.cnf config may not be right My Memory table hit 16Mb and locked up. Is there something in my.cnf that I don't have correct. I thought I set it to 128MB memory tables. max_connections = 3500 max_user_connections = 1500 key_buffer = 750M myisam_sort_buffer_size = 130M join_buffer_size = 128M read_buffer_size = 1M sort_buffer_size = 128M read_rnd_buffer_size = 16M table_cache = 28192 thread_cache_size = 1512 wait_timeout = 7 connect_timeout = 10 max_allowed_packet = 16M max_connect_errors = 20 query_cache_limit = 8M query_cache_size = 32M query_cache_type = 0 skip-innodb thread_concurrency = 8 safe-show-database interactive_timeout= 15 tmp_table_size = 128000000 Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183
