June 19, 2013

Comment: table_cache negative scalability

…31014 + 27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase I have …400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_…status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db

Comment: table_cache negative scalability

…31014 + 27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase I have …400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_…status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db

Post: Estimating Replication Capacity

…box does not do anything else … thread has different status in Show … +——–+————-+———–+——+———+——+———————————————————————–+——————+ | Id | User | Host | db ….00 sec) 4) Slave Catchup/Binlog Application method. …