List:General Discussion« Previous MessageNext Message »
From:<gunmuse Date:February 22 2005 11:05pm
Subject:RE: Memory Tables and My.cnf config may not be right
View as plain text  
Don't want this to roll to far down the list.


  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

Thread
Memory Tables and My.cnf config may not be rightgunmuse22 Feb
  • RE: Memory Tables and My.cnf config may not be rightgunmuse23 Feb